WayneS

Forum Replies Created

Viewing 15 posts - 2,731 through 2,745 (of 5,588 total)

RE: How to use PIVOT in this case?

Jeff Moden (10/24/2010)
WayneS (10/13/2010)
bhushan.bagul (10/13/2010)
thanks for your reply!!!
Glad to be of help. Does it work right for you?
Heh... don'cha just love it?
Exercising my brain: yes.
Lack of feedback: no.
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 24, 2010 at 8:29 pm

#1241399
RE: Are the posted questions getting worse?

Does anyone know how to expand a VMWare virtual disk, and have it properly show up in an XP guest OS? If so, please help me out here.
Thanks!
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 24, 2010 at 11:43 am

#1241345
RE: Sequence-numbering groups

gmrose (10/23/2010)
Out of curiosity, how many records are you processing? And did you try out the script that I posted?
Wayne
Thank you (and all of the others) for your suggestions....
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 23, 2010 at 5:51 pm

#1241315
RE: Wierd one..

Oksana March (10/23/2010)
And could someone please explain what you mean by "parameter sniffing"? Thanks!
http://sqlinthewild.co.za/index.php/2007/11/27/parameter-sniffing/[/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

October 23, 2010 at 3:07 pm

#1241310
RE: Are the posted questions getting worse?

Tom.Thomson (10/22/2010)
WayneS (10/22/2010)
Alvin Ramard (10/22/2010)
I think I need to read some of Celko's responses so I can do a better job of expressing myself when I answer some of 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 23, 2010 at 5:38 am

#1241268
RE: CREATE LOGIN command on named instance

Chandu-212374 (10/23/2010)
Normally on a default instance of SQLServer, to create login from command prompt i use:
USE master
GO
CREATE LOGIN [domainname\uname] FROM WINDOWS WITH DEFAULT DATABASE=master.
But from command prompt I want 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 23, 2010 at 5:33 am

#1241267
RE: SPLIT TSQL Between two character

Craig Farrell (10/22/2010)
WayneS (10/21/2010)
Here is the latest version of the Delimited Split Function
DelimitedSplit8k... d'oh. My bad. Thank you Wayne. It's now (finally) stored in my 'favorites' folder.
You're...
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 23, 2010 at 5:17 am

#1241263
RE: t sql problems

CELKO (10/22/2010)
Shameless plug for my SQL Puzzles & Answers book
http://www.elsevierdirect.com/product.jsp?isbn=9780123735966
Joe,
I actually went to this site to check out what was in the book. The TOC gives a high-level 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

October 22, 2010 at 3:27 pm

#1241204
RE: Are the posted questions getting worse?

Alvin Ramard (10/22/2010)
Alvin Ramard (10/22/2010)
[rant]
I'm getting sick and tired of having to deal with people trying to use SSIS without taking the time to learn how to use it first!!!!!!!!
[/rant]
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 22, 2010 at 3:20 pm

#1241203
RE: updating columns across table

wardy (10/22/2010)
Hi, I am sure this is easy but being a newb this is confusing me. I have x2 tables that are joined by a primary key. 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 22, 2010 at 10:55 am

#1241063
RE: SUM According To Group By On Expression formula

Sacheen (10/21/2010)
Instead of handling this in report using expression, if you are not using this dataset anywhere in report then why don't you handle it on sql part only.
Assuming you're...
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 21, 2010 at 9:41 pm

#1240701
RE: MCITP without MCTS Certification

Simon-413722 (10/21/2010)
Hi,
I'm just wondering if you could register and take MCITP exam and skip MCTS?
No, MCTS is a prerequisite
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 21, 2010 at 9:38 pm

#1240700
RE: Are the posted questions getting worse?

Jeff Moden (10/21/2010)
Paul White NZ (10/19/2010)
Jeff Moden (10/19/2010)
I prefer your simplified row number checker. It doesn't slow down much and doesn't have problems with unbalanced sets that Hugo's 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

October 21, 2010 at 9:29 pm

#1240697
RE: sp_rename throwing errors when trying to rename index

Can you please post:
1. the line that is failing in your script.
2. the table and index CREATE statements when you script them out.
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 21, 2010 at 7:23 pm

#1240672
RE: SPLIT TSQL Between two character

Craig Farrell (10/21/2010)
Here's the DelimitedString8k function that's been heavily worked on round these parts. Modify to suit your needs. I didn't create it, didn't work on it, and...
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 21, 2010 at 6:51 pm

#1240670

Viewing 15 posts - 2,731 through 2,745 (of 5,588 total)