WayneS

Forum Replies Created

Viewing 15 posts - 2,776 through 2,790 (of 5,588 total)

RE: Urgent help needed to convert 100 rows into 100 columns

thejask08 (10/19/2010)
How to do it SQL SERVER 2000. ROW_NUMBER(), OVER() doesnt exist in SQL SERVER 2000.
Please help how to do this in sql server 2000.
It would help to be mindful...
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

October 19, 2010 at 4:49 pm

#1239416
RE: More efficient way

Bill_CCAC (10/19/2010)
I will but I'm not quite finished with it yet. As soon as I get it sorted I'll posted it.
This turned into a nice post. Thanks all
I'd suggest...
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

October 19, 2010 at 4:41 pm

#1239414
RE: Dead lock on Collection Set

Roy Ernest (10/19/2010)
I think I will try a rewrite of the sproc and test it in our QA with load testing and see if it will cause any dead locks.
If...
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

October 19, 2010 at 4:35 pm

#1239412
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (10/19/2010)
WayneS (10/18/2010)
... we need several hundred years of records to know this, and we barely have one hundred. I also believe that this whole global...
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

October 19, 2010 at 4:33 pm

#1239410
RE: Insert trigger not working

aspardeshi (10/18/2010)
Secondly, I have seen many triggers, but the one of your kind is totally unknown and completely new to me in terms of clauses. Can you please explain what...
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

October 18, 2010 at 10:24 pm

#1238824
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (10/18/2010)
I'm with Lynn. I'm not sold that global warming, even if it is happening, is a bad thing. It might be part of a long...
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

October 18, 2010 at 10:12 pm

#1238821
RE: Are the posted questions getting worse?

Lynn Pettis (10/18/2010)
I can still remember a time, many years ago when my mom and her friend were having a heated debate between Nixon and McGovern. At one point...
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

October 18, 2010 at 10:00 pm

#1238819
RE: Store pdf's in database --- text, image, or filestream?

Please see this link.
Text/image are depreciated - they are going away in a future version of SQL. Use varbinary(max) instead.
Which to use: FileStream or varbinary? It depends:
How many files to...
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

October 18, 2010 at 5:11 pm

#1238785
RE: Date Gap Problem

Here's an update to my code. I've moved the 1462 dates we're concerned with into a separate temp table, instead of being called through a CTE numerous times. Greatly improves...
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

October 17, 2010 at 10:23 pm

#1238214
RE: Date Gap Problem

Jeff Moden (10/17/2010)
WayneS (10/17/2010)
This works, but the performance is atrocious.
Because of the very large datespan from any date in this century to 9999-12-31, I'm thinking that my ol' friend the...
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

October 17, 2010 at 10:08 pm

#1238210
RE: Date Gap Problem

Jeff Moden (10/17/2010)
Sorry... forgot to print out the results...
MemberIDStartDateEndDateGap
12006-10-01 00:00:00.0002007-12-31 00:00:00.0000
12008-01-15 00:00:00.0002008-12-31 00:00:00.00015
22007-02-03 00:00:00.0002007-12-31 00:00:00.0000
22008-01-15 00:00:00.0002008-12-31 00:00:00.00015
32006-10-01 00:00:00.0002007-09-30 00:00:00.0000
32008-01-01 00:00:00.0002008-12-31 00:00:00.00093
Jeff, are these gaps correct? By my calc, there are...
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

October 17, 2010 at 10:04 pm

#1238208
RE: Date Gap Problem

Kevin,
This works, but the performance is atrocious. I'm posting it so that others (Jeff???) can see what I'm doing, and to improve upon it.
declare @GapDays int,
...
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

October 17, 2010 at 9:58 pm

#1238207
RE: Are the posted questions getting worse?

Jeff Moden (10/17/2010)
WayneS (10/14/2010)
"Don't try this at home... we're professionals!"
Heh... I have the perfect SQL subject for that... Quirky Update. 😀
SOM!
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

October 17, 2010 at 8:56 pm

#1238202
RE: Are the posted questions getting worse?

GilaMonster (10/17/2010)
Tom.Thomson (10/17/2010)
What's the betting he calls you all sorts of names
Yes
and says the idea of having a stored procedure is an unwanted overhead?
Don't think so. More likely, 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

October 17, 2010 at 4:12 pm

#1238169
RE: How to return last 10 rows of a table?

Mike John (10/17/2010)
Snap!
It would have been hard to get two answers closer...
Mike
Nah, I've seen the same answer from different folks come in within the same minute before here.
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

October 17, 2010 at 11:06 am

#1238134

Viewing 15 posts - 2,776 through 2,790 (of 5,588 total)