Forum Replies Created
Viewing 15 posts - 1,171 through 1,185 (of 5,588 total)
-
RE: Are the posted questions getting worse?
The Dixie Flatline (6/12/2011)
If I passed, could I add "Thread Certified" to my resume` ?Sure... but would you only work for people that knew what it meant?
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 -
RE: convert month name to month number
Dehqon D. (6/11/2011)
Your are genious , Jeff ModenI like your simplicity.
Agreed. Jeff has a way with cutting to the chase and seeing what is really 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 -
RE: Is this possible to use LIKE ALL in SP.
I think that this article will help you out: Delimited Split Function[/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 -
RE: Inserting into an Table with Identity Column from n number of tables
kr.nithin (6/10/2011)
Thanks for the help provided. I figured out the problem. There was data type mismatch , hence the issue.I have another issue:
I want to update only those values...
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 -
RE: unpivot note
flyingrockfishguy (6/10/2011)
I made a small syntax error in this query, and would have expected an error when I tried to run it. The results are quite interesting.SELECT ExtraValue,VendorID
Employee,...
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 -
RE: Temp Table Vs Table Variables
Jeff Moden (6/10/2011)
Please see what I consider to be the definitive article on that subject and others at the following URL: http://www.sqlservercentral.com/articles/Temporary+Tables/66720/:blush:
Thanks Jeff!
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 -
RE: Are the posted questions getting worse?
GilaMonster (6/9/2011)
I post too much.Maybe, maybe not. We're still learning from you, and I'm hoping that you'll keep on posting so I can keep on learning.
(Congrats on the 25k. )
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 -
RE: Can this be converted to a set based query?
Tony,
Well, I can't think of any other way to optimize this. I think that this leaves you with two choices:
1. Use the iTVF. Pros: same code is used by two...
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 -
RE: Can this be converted to a set based query?
tfeuz (6/8/2011)
LOL - you missed the constraint on Rb_Ruleid again -- I added it back in:Just making sure you're looking at the code as a sanity check! :w00t:
Does this index...
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 -
RE: Can this be converted to a set based query?
Tony,
Starting over. The main (not single) procedure is totally rewritten to combine the TVF with it. If this works, we'll combine the TVF into the single procedure also.
Start off by...
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 -
RE: Can this be converted to a set based query?
tfeuz (6/8/2011)
WayneS (6/7/2011)
tfeuz (6/7/2011)
Wayne,I had to make a fix to the code -- you did not constrain by the rule id when you create the temp table -- it caused...
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 -
RE: Can this be converted to a set based query?
Tony:
Is RB_InvoicesToProcess 1:1 with Invoices?
Is RB_InvoicesToProcess_Moved 1:1 with Invoices?
Just to verify, you can have the same invoice in both of those tables?
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 -
RE: Can this be converted to a set based query?
TheSQLGuru (6/7/2011)
I was giving my own presentation @ sqlsat77 while yours was in progress. 😀Ah, so you were. I heard it went pretty well.
As long as they have fairly uniform...
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 -
RE: Can this be converted to a set based query?
tfeuz (6/7/2011)
Wayne,I had to make a fix to the code -- you did not constrain by the rule id when you create the temp table -- it caused duplicate values...
Note...
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 -
RE: Can this be converted to a set based query?
TheSQLGuru (6/7/2011)
I applaud you Wayne for thinking outside the box on this with a switch to an mTVF. I am sure you aware that the optimizer can no integrage...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
Viewing 15 posts - 1,171 through 1,185 (of 5,588 total)