WayneS

Forum Replies Created

Viewing 15 posts - 3,046 through 3,060 (of 5,588 total)

RE: how to display multiple records in 1 column seperated by (,)?

I agree with Luke that Shaiju CK's implementation isn't that good. However, a PIVOT won't work unless there are the same # of names.
So, here's a working solution:
DECLARE @tYourTableName 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

October 2, 2010 at 3:17 am

#1230672
RE: Insert statement syntax for data using xml file

CREATE PROCEDURE dbo.LoadXMLData (@xmlData XML) AS ...
then use @xmlData.nodes()... to get the data 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 2, 2010 at 3:01 am

#1230671
RE: Import Excel Spreadsheet

Clkgtrs1 (10/1/2010)
Hey Thank you for the help but when I right click the database I don't have the option to import data into my database. I'm running SQL Server Management...
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 2, 2010 at 2:59 am

#1230669
RE: Can Wives Shorten Work Hours?

Craig Farrell (9/29/2010)
... I've gotten a list of questions that I always ask the employer. One of the top 3 is "What's your average employee's work schedule like, including...
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 2, 2010 at 2:48 am

#1230668
RE: Set the CSV columns width

I'm assuming that you're then using Excel to open the CSV, and want all of the column's auto-sized?
Setting the width in a CSV file defeats the nature of 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

October 2, 2010 at 2:44 am

#1230667
RE: I need some help with a test, please.

Jeff Moden (9/30/2010)
WayneS (9/26/2010)
Jeff - just saw this thread after returning from my vacation. If needed, I can run this on a Vista Ultimate 64-bit laptop, on 2005 / 2008...
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 2, 2010 at 2:35 am

#1230665
RE: Are the posted questions getting worse?

Trey Staker (10/1/2010)
Alvin Ramard (10/1/2010)
Jason,
After looking at that thread you just posted in, I think it's time to write up a best practice for SSIS configuration and deployment.
I'm getting tired...
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 2, 2010 at 2:19 am

#1230663
RE: Are the posted questions getting worse?

The Dixie Flatline (10/1/2010)
Is anyone else having trouble posting this morning?
Steve, I have an answer for the OP in this thread and it won't post my reply.
I've been having sporadic...
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 1, 2010 at 8:41 am

#1230251
RE: Triggers and Transactions

Great question; I really enjoyed working through it. 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 1, 2010 at 8:30 am

#1230230
RE: Are the posted questions getting worse?

Craig Farrell (9/30/2010)
CirquedeSQLeil (9/30/2010)
Grant Fritchey (9/30/2010)
CirquedeSQLeil (9/30/2010)
WayneS (9/30/2010)
CirquedeSQLeil (9/30/2010)
GilaMonster (9/30/2010)
The problem is what he's mapping out in the project plan is actual elapsed time, not time spent on his project....
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

September 30, 2010 at 7:22 pm

#1229985
RE: SQL Server Error Log - A significant part of sql server memory has been paged out...

Sachin Vaidya (9/30/2010)
Derrick Smith (9/30/2010)
96gb ram and you're maxing it out?
With a 96gig box, I'd limit the buffer cache to probably 80-82gb (the sql max memory setting).
Where did I mentioned...
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

September 30, 2010 at 6:42 pm

#1229977
RE: Are the posted questions getting worse?

CirquedeSQLeil (9/30/2010)
GilaMonster (9/30/2010)
The problem is what he's mapping out in the project plan is actual elapsed time, not time spent on his project. Since neither developer is full time (both...
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

September 30, 2010 at 5:10 pm

#1229963
RE: SQL Server 2008 - 2008 R2 Reports compatibility

vvignesh86 (9/30/2010)
Could you please tell me where I would be able to find this option in BIDS?
Thanks,
Vignesh
http://social.msdn.microsoft.com/Forums/en-US/sqlkjreportingservices/thread/4d561071-342f-4dc8-a361-a71d0cc1d93d
I don't actually have R2, so I can't tell you any more than 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

September 30, 2010 at 4:17 pm

#1229960
RE: CTE vs. Table Variable

Yes. Note that you can use a CTE with an INSERT, UPDATE or DELETE statement in addition to the SELECT statement.
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

September 30, 2010 at 3:28 pm

#1229951
RE: SQL Server 2008 - 2008 R2 Reports compatibility

R2 has a mode (in BIDS) where you can select which version you're developing for. If you use the "R1" version, then sure.
Edit: added (in BIDS)
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

September 30, 2010 at 2:55 pm

#1229934

Viewing 15 posts - 3,046 through 3,060 (of 5,588 total)