Select queries - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Select queries

Author

Topic

lokesh143
Starting Member

2 Posts

Posted - 2010-09-27 : 02:08:16

Hi
Iam having 8 select quries,3 insert stmts,and update stmt
Can any one help me how to reduce the time in retrieving data from database.Iam running all quries in job scheduler

pk_bohra
Master Smack Fu Yak Hacker

1182 Posts

Posted - 2010-09-27 : 05:30:36

Can you show us the queries, insert and update statement

lokesh143
Starting Member

2 Posts

Posted - 2010-09-27 : 07:51:47

quote:
Originally posted by pk_bohra

Can you show us the queries, insert and update statement

Insert into dbo.Tempschedular_dummy"
+ "(CardNumber,CardExpiryDt,MemberLevel,Flag,NewMemberLvl,NewCardExpiryDt,Mnth,Yr)"
+ "values(?,?,?,?,?,?,'"+(Calendar.getInstance().get(Calendar.MONTH)+1)+"','"+Calendar.getInstance().get(Calendar.YEAR)+"')

UPDATE G_CUSTOMERS SET CardExpiryDT='"+NewCardExpiryDt+"',MemberLevel='" + updlvl + "', MemberLvlChngDt = getdate(),updatedon = getdate() where CardNo = '"+ cardno + "'"

INSERT INTO G_LvlChangeRenewal"
+ "(ProfileCD,CardNo,TranType,PreivousLvl,CurrentLvl,PreviousExpiryDt,CurrentExpiryDt)"
+ " VALUES ('1','" + cardno + "','" + downgrad + "','"
+ currlevel + "','" + updlvl + "','" + expdt + "','"
+ NewCardExpiryDt.toString()+ "')

SELECT dbo.FGCalLast2YrPurchaseAmtRenewal('" + cardno + "','" + expdt + "') as amt1
select count(*) as tmpcount from dbo.Tempschedular_dummy
Insert into RenewalSchedularProcessStatus (Mnth,yr,NumberOfRecords,CountOfSuccess,CountOfRemaing) " +
"values('"+(Calendar.getInstance().get(Calendar.MONTH)+1)+"','"+Calendar.getInstance().get(Calendar.YEAR)+"','"+cntqry+"','"+tmpcnt+"',?)

select paravalue3 as lvl from G_PARAMETER WHERE PARACODE = ? and "
+ "(dbo.FGCalLast1YrPurchaseAmtRenewal("+ cardno + "," + expdt + "))"
+ " between convert(numeric(18,2),paravalue1) and convert(numeric(18,2),paravalue2)

select count(*) as tmpcount from dbo.Tempschedular_dummy
SELECT cardno,CardExpiryDT,MemberLevel From dbo.G_CUSTOMERS WHERE CardExpiryDT >= "
+ " ( select dateadd(mm,-1,FirstDtOfMonth) from vG_1stDtOfCurrMM) AND CardExpiryDT < "
+ " ( select dateadd(dd,-1,FirstDtOfMonth)+1 from vG_1stDtOfCurrMM) AND CardisActive = 0

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources