T-SQL Comparing Rates

Question

Post reply

T-SQL Comparing Rates

Steve Jones - SSC Editor

SSC Guru

Points: 736478
More actions
February 3, 2014 at 10:09 am

#281827

A writeup based on this thread. Show how this works and why one method may be better than the other
http://www.sqlservercentral.com/Forums/Topic1537283-3077-1.aspx

Viewing 9 posts - 1 through 8 (of 8 total)

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

WayneS SSC Guru Points: 95460 More actions · Answer 1

Steve, I'll take this one.

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

Steve Jones - SSC Editor SSC Guru Points: 736478 More actions · Answer 2

Steve Jones - SSC Editor

SSC Guru

Points: 736478

February 5, 2014 at 10:41 am

#1686292

Excellent. And thanks

Steve Jones - SSC Editor SSC Guru Points: 736478 More actions · Answer 3

Bump. This one is open for anyone again. Wayne decided not to tackle it.

mrscmp Grasshopper Points: 22 More actions · Answer 4

Hi Steve,

The final solution that was provided by the poster would run extremely slowly when dealing with larger row counts and a simple way of avoiding this can be implemented that has practical uses in optimising complex queries in general.

I would be happy to explain with examples.

Claire

Steve Jones - SSC Editor SSC Guru Points: 736478 More actions · Answer 5

Claire,

Please feel free to tackle it. If I don't hear something in about a month, I'll bump this topic.

mrscmp Grasshopper Points: 22 More actions · Answer 6

Hi Steve,

As it's my first article for you it took longer than I expected to format and load onto your system. I still couldn't get the colours from my code to remain, any thoughts?

Just writing to let you know it was sent yesterday and I know it takes a couple of weeks to process.

Many thanks,

Claire

ClaireM SSC Veteran Points: 223 More actions · Answer 7

Submitted and available for your perusal here.

http://www.sqlservercentral.com/articles/T-SQL/107611/

Steve Jones - SSC Editor SSC Guru Points: 736478 More actions · Answer 8

ClaireM (4/8/2014)

Submitted and available for your perusal here.

http://www.sqlservercentral.com/articles/T-SQL/107611/%5B/quote%5D

Good job and thanks