Forum Replies Created
Viewing 15 posts - 3,031 through 3,045 (of 5,588 total)
-
RE: Sub query to return data recursively?
SELECT EmployeeID,DataYear,
YearlyWage,
FiveYearWage = (SELECT SUM(YearlyWage)
...
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 (10/4/2010)
I'm not sure I got the order of operation there correct. Do you check that it's the correct DB before or after dropping it?I'd do it after. That...
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?
Alvin Ramard (10/4/2010)
GilaMonster (10/4/2010)
For your monday evening entertainment: http://www.sqlservercentral.com/Forums/Topic997896-357-1.aspxThere are days I just don't want to know...
I had to reply to that one.
I replied with http://lmgtfy.com/?q=How+to+use+Internet+Search+Engine
I prefer to use 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 -
RE: New User, just wanted to say hi
Welcome!
Yes, reading BOL and using search engines are powerful tools to have in your arsenal. The only thing I'd add to your excellent post is that when you have exhausted...
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: I need some help with a test, please.
WayneS (10/2/2010)
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 /...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 Wives Shorten Work Hours?
Craig Farrell (10/4/2010)
WayneS (10/2/2010)
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...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: Simple Recovery model
http://msdn.microsoft.com/en-us/library/ms189275.aspx
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?
BrainDonor (10/4/2010)
Paul White NZ (10/2/2010)
Local news: Lots of changes on 1 October. GST went up, income tax came down, and Internet bandwidth increased to 15Mbps from 10Mbps. 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 -
RE: How would you create this stored procedure
That depends... do your requirements specify sometimes doing some of this, and at other times not doing it? If so, then it would be 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: How would you create this stored procedure
blacklabellover2003 (10/3/2010)
Hi all,I've got sections of code I'd like to transfrom into a single stored procedure. At the moment, we run each of the five sections separately, the first...
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: Dynamically create tables from csv files looping through folder
How about:
1. Use an Execute SQL Task to run a bulk insert to read the first line (column headers) into a #temp table (1 column).
2. Prepare a variable 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 -
RE: how to display multiple records in 1 column seperated by (,)?
Glad to be of assistance! 😀
Seriously, I do like Luke's suggestion of using grouping and the JOIN function within SSRS. The solution I posted might reduce network traffic and server...
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?
Paul White NZ (10/2/2010)
WayneS (10/2/2010)
Congrats! Where are you moving to?Just locally, 5km or so. The new place is on the hillside overlooking the Tasman Sea and Kapiti Island.
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: Stored procedure help
You know, the people that help out here are all un-paid volunteers, so please HELP US HELP YOU. Providing the DDL scripts (CREATE TABLE, CREATE INDEX, etc.) for the 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: Are the posted questions getting worse?
Paul White NZ (10/2/2010)
Local news: Lots of changes on 1 October. GST went up, income tax came down, and Internet bandwidth increased to 15Mbps from 10Mbps. And I'm...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 - 3,031 through 3,045 (of 5,588 total)