Viewing 15 posts - 9,316 through 9,330 (of 10,144 total)
Grant Fritchey (12/1/2008)
December 1, 2008 at 7:45 am
Here's the relevant statements ripped from the sproc for easy testing:
[font="Courier New"]DECLARE @FromDate SmallDateTime,
@ToDate SmallDateTime,
@ProfCode smallint,
@Branch smallint = 0,
@WHCode VARCHAR(5) = NULL,...
December 1, 2008 at 7:02 am
GilaMonster (12/1/2008)
KPR (12/1/2008)
sorry to reduce it to one sec.That may not be possible. You're doing a lot of work in there.
What are these?
dbo.fn_ProfileLegalVechile(@ProfCode,@Branch)
dbo.fn_ProfileWareHouse(@ProfCode,@WHCode)
dbo.fn_ProfileCurrency(@ProfCode,@CCYCode)
I'd agree with Gail here. If two...
December 1, 2008 at 6:34 am
KPR (12/1/2008)
December 1, 2008 at 6:20 am
Have a look at WAITFOR in BOL, it's exactly what you need.
December 1, 2008 at 6:00 am
KPR (12/1/2008)
I have tried like this but after running 2 to 3 times Proc is executing in 1 Min 33 secs.
I'm sure it is - it looks like the original...
December 1, 2008 at 5:57 am
KPR (12/1/2008)
Earlier Proc was returning 279 rows in 1 min 25 secs for 5 days.Now it is returning 685 rows in 56 secs.
How are you testing, KPI? If you're amending...
December 1, 2008 at 5:33 am
KPR (12/1/2008)
Thanks for your response. I tried with your scenarios(Select ...into #trades).
...
December 1, 2008 at 5:07 am
Madhivanan (12/1/2008)
It must be faster. If not compare the execution paln by applying thesehttp://sqlblogcasts.com/blogs/madhivanan/archive/2008/09/12/return-top-n-rows.aspx
Only the third method would work - and it's exactly the same as the OP's suggestion.
December 1, 2008 at 4:08 am
dana_turcanu1981 (12/1/2008)
Hy.I need a temporary table that loks like this:
Col1
1
2
3
4
5
Can I create it with a select statement? I wouldn't like to use a "for"
Thanks
This is quite quick:
SELECT IDENTITY (INT, 1,...
December 1, 2008 at 4:00 am
Hello
1. This sproc would probably run more quickly if you remove all of the statements relating to transactions - you don't need it.
You're SELECTING data from live tables into a...
December 1, 2008 at 3:42 am
Eight seconds for around 12 million (simple) rows looks good to me:
[font="Courier New"]-- Return all colours in a batch, but do not return more than two of the same
SELECT *...
December 1, 2008 at 3:11 am
bhuvnesh.dogra (12/1/2008)
so i cannot insert that SQL table data into Excel(Placed at local drive)Am i right ?
If the instance of SQL server which is executing your statement...
December 1, 2008 at 2:11 am
Jeff Moden (11/29/2008)
November 30, 2008 at 6:06 am
rbarryyoung (11/29/2008)
You should use dynamic SQL for this, unless you want to make one stored procedure for every business unit.
If you choose to take the dynamic SQL route, then generally...
November 30, 2008 at 3:39 am
Viewing 15 posts - 9,316 through 9,330 (of 10,144 total)