WayneS

Forum Replies Created

Viewing 15 posts - 1,426 through 1,440 (of 5,588 total)

RE: INNER JOIN with multiple "ON" : ON t.ID = t2.ID ON t.FKID = t3.ID

I seem to recall reading that there is an example of this in the AdventureWorks database... it's also used when you are joining multiple tables, and the tables don't have...
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

May 3, 2011 at 2:03 pm

#1319377
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

Nadrek (5/3/2011)
Craig Farrell (5/3/2011)
B'narg! Whaaaa? After a point I'd have expected the Perm table to stabilize more to the memory build.
Wow.
Try one of the two double-CTE versions I...
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

May 3, 2011 at 1:59 pm

#1319374
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

Craig Farrell (5/3/2011)
WayneS (5/3/2011)
Here's the results that I have. The "DemilitedSplit8Kpt" is the new DelimitedSplit8K function, with a permanent tally table.
10 to 20 Characters per Element:
B'narg! Whaaaa? After...
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

May 3, 2011 at 1:57 pm

#1319373
RE: INNER JOIN with multiple "ON" : ON t.ID = t2.ID ON t.FKID = t3.ID

This MSDN link might help explain it a bit better
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

May 3, 2011 at 1:35 pm

#1319361
RE: SQL GreenHorn issue... Combining table data to a concat string

Check out this article: Creating a comma-separated list (SQL Spackle)[/url]
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

May 3, 2011 at 11:03 am

#1319245
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

Jeff Moden (5/2/2011)
WayneS (5/2/2011)
mtassin (5/2/2011)
WayneS (5/2/2011)
BTW, since the new code was not compared to a physical, permanent tally table, I thought that I would mention that while testing this code...
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

May 3, 2011 at 10:46 am

#1319237
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

ChrisM@home (5/3/2011)
Jeff, please please please write a book, without changing your style. Give us all an opportunity to repay you for what you've done for us.
+10!
Yes, please do write a...
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

May 3, 2011 at 9:46 am

#1319185
RE: Are the posted questions getting worse?

GilaMonster (5/2/2011)
Woot!!!!!!!!!!
http://www.allenkinsel.com/archive/2011/05/further-promoting-the-growth-of-speakers/
Congrats Gail!
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

May 3, 2011 at 9:29 am

#1319169
RE: Are the posted questions getting worse?

GilaMonster (5/2/2011)
[Jim].[dba].[Murphy] (5/2/2011)
I understand 'the last one' (after BI) might have a 'M' both before and after the 'C'.
You know, it just might. 🙂
Good luck with that! You're 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

May 2, 2011 at 2:07 pm

#1318716
RE: Add leading zero to int

ramadesai108 (5/2/2011)
I am trying to store the number in a char field. Wayne has the correct answer. Thanks Wayne, that works.
I'm glad that it works... but you really shouldn't store...
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

May 2, 2011 at 1:05 pm

#1318677
RE: Add leading zero to int

RIGHT('0000' + convert(varchar(4), MyNumberToConvert),4)
Edit: note that it's now a string, not a number.
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

May 2, 2011 at 11:33 am

#1318595
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

mtassin (5/2/2011)
WayneS (5/2/2011)
Mark, the only possible explanation that I can give is the elimination of the disk IO. When I ran this test, I fully expected the physical tally table...
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

May 2, 2011 at 10:57 am

#1318557
RE: Are the posted questions getting worse?

SQLRNNR (5/2/2011)
Stefan Krzywicki (5/2/2011)
WayneS (5/2/2011)
Stefan Krzywicki (5/2/2011)
And now I feel like I'm talking about breath mints...
So... what's the difference between a person with an alphabet soup of certs, and a...
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

May 2, 2011 at 10:43 am

#1318548
RE: Are the posted questions getting worse?

Stefan Krzywicki (5/2/2011)
And now I feel like I'm talking about breath mints...
So... what's the difference between a person with an alphabet soup of certs, and a breath mint?
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

May 2, 2011 at 10:25 am

#1318530
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

mtassin (5/2/2011)
WayneS (5/2/2011)
BTW, since the new code was not compared to a physical, permanent tally table, I thought that I would mention that while testing this code out for you,...
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

May 2, 2011 at 10:02 am

#1318512

Viewing 15 posts - 1,426 through 1,440 (of 5,588 total)