Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

T-SQL Comparing Rates Expand / Collapse
Author
Message
Posted Monday, February 3, 2014 10:09 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 7:45 PM
Points: 33,264, Visits: 15,424
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







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1537399
Posted Wednesday, February 5, 2014 10:40 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 8:51 AM
Points: 6,600, Visits: 8,900
Steve, I'll take this one.

Wayne
Microsoft Certified Master: SQL Server 2008
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, How to ask a question, Performance Problems, Common date/time routines,
CROSS-TABS and PIVOT tables Part 1 & Part 2, Using APPLY Part 1 & Part 2, Splitting Delimited Strings
Post #1538283
Posted Wednesday, February 5, 2014 10:41 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 7:45 PM
Points: 33,264, Visits: 15,424
Excellent. And thanks






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1538285
Posted Tuesday, February 18, 2014 8:26 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 7:45 PM
Points: 33,264, Visits: 15,424
Bump. This one is open for anyone again. Wayne decided not to tackle it.






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1542604
Posted Thursday, February 20, 2014 2:57 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, March 21, 2014 8:08 AM
Points: 2, Visits: 30
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
Post #1543375
Posted Thursday, February 20, 2014 2:43 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 7:45 PM
Points: 33,264, Visits: 15,424
Claire,

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







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1543741
Posted Wednesday, March 12, 2014 5:26 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, March 21, 2014 8:08 AM
Points: 2, Visits: 30
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
Post #1550157
Posted Tuesday, April 8, 2014 10:40 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 7:33 PM
Points: 14, Visits: 222
Submitted and available for your perusal here.

http://www.sqlservercentral.com/articles/T-SQL/107611/
Post #1559577
Posted Tuesday, April 8, 2014 1:37 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 7:45 PM
Points: 33,264, Visits: 15,424
ClaireM (4/8/2014)
Submitted and available for your perusal here.

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


Good job and thanks







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1559682
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse