Need help with a query

Question

Need help with a query

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply

WayneS SSC Guru Points: 95460 More actions · Answer 1

lmu92 (5/5/2010)
Might be agood idea to turn it into an article...

Yes, it would. Which reminds me... are you writing one based upon that post last year where you found something that was working faster with a c.u.r.s.o.r... the tally table wasn't getting you what you needed?

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

LutzM SSC Guru Points: 107049 More actions · Answer 2

WayneS (5/5/2010)
lmu92 (5/5/2010)
Might be agood idea to turn it into an article...
Yes, it would. Which reminds me... are you writing one based upon that post last year where you found something that was working faster with a c.u.r.s.o.r... the tally table wasn't getting you what you needed?

Are you sure it was me? :unsure:

I really can't remember any such scenario. Honestly.

Lutz
A pessimist is an optimist with experience.

How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

WayneS SSC Guru Points: 95460 More actions · Answer 3

lmu92 (5/6/2010)
WayneS (5/5/2010)
lmu92 (5/5/2010)
Might be agood idea to turn it into an article...
Yes, it would. Which reminds me... are you writing one based upon that post last year where you found something that was working faster with a c.u.r.s.o.r... the tally table wasn't getting you what you needed?
Are you sure it was me? :unsure:
I really can't remember any such scenario. Honestly.

You're right, it wasn't you, it was Flo. http://www.sqlservercentral.com/Forums/Topic695508-338-1.aspx

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2