WayneS

Forum Replies Created

Viewing 15 posts - 1,696 through 1,710 (of 5,588 total)

RE: Reset Row_Number() against column

Sean Lange (3/15/2011)
Wayne it was your signature I was thinking of as I was adding my reply. Applies 100% in this case.
😀
(You didn't think of my article for explaining it?...
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

March 15, 2011 at 10:28 am

#1298968
RE: T-SQL Help

Well, just expanding upon your cte, we can get the other columns that you're looking for:
(Note that I shifted over to using a table variable instead of the temp 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

March 15, 2011 at 9:44 am

#1298936
RE: Creating a bcp format file

1. I don't think that you need to use the double-quotes around the 3-part db.schema.object unless it contains a space or quotation mark; then you would also need to use...
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

March 15, 2011 at 9:30 am

#1298922
RE: T-SQL Help

Matt,
Based on the sample data that you provided (BTW - THANK YOU!!!), can you show us what the expected output is?
(Question - is the data really INT? You're putting character...
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

March 15, 2011 at 9:13 am

#1298905
RE: Reset Row_Number() against column

This article should help you out - both with understanding, and coding: SQL Server Ranking Functions[/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

March 15, 2011 at 9:08 am

#1298902
RE: Columns to Row?

Hmm. It's the end users that keep you in a job... 😀
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

March 15, 2011 at 7:25 am

#1298831
RE: How to find the which JOB and JOB-STEP is running for particular Stored Procedure

Craig Farrell (3/14/2011)
The above will work if it's in the command of the jobstep. If it's buried in SSIS, you're SoL. You can try a trace to track...
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

March 14, 2011 at 11:42 am

#1298488
RE: calculating dates

timotech (3/14/2011)
Hi all, please how can i ensure that i get accurate dates for example, if i enter '28 feb 2011' for @BeginDate, and i count one year back, 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

March 14, 2011 at 11:07 am

#1298461
RE: Columns to Row?

drew.allen (3/14/2011)
jason-772533 (3/14/2011)
Hi Drew, Therein lies a small problem. I'm using a 2000 server, so can't use ROW_NUMBER as it's 2005 syntax!
There is a separate forum for SQL...
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

March 14, 2011 at 11:02 am

#1298456
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (3/14/2011)
I'll look one over as well, Craig
Steve, I thought you looked over all of them anyway? 😉
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

March 14, 2011 at 9:36 am

#1298405
RE: SQL Server 2005 High Availability Cluster Questions

mattboston (3/14/2011)
I currently have a single SQL Server 2005 Standard 64-bit server running on Windows Server 2003 Enterprise. To plan for redundancy I'm looking at using the Microsoft Failover...
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

March 14, 2011 at 9:34 am

#1298402
RE: Fixed Length Flat File

NP 😎
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

March 14, 2011 at 9:14 am

#1298391
RE: How to do SUM on Columns from subquery aggregate functions

mar311 (3/14/2011)
Thanks for the feedback. What I'm ultimately looking for is to create new columns for the "Grand Totals" and then pull the single value from that column via SP...
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

March 14, 2011 at 8:54 am

#1298371
RE: INSERT OUTPUT INTO (With an extra column) and SELECT statement

The only way you're going to be able to do this is if you add the comID column to TableA, insert into that, and use the INSERTED.comID to insert into...
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

March 14, 2011 at 8:41 am

#1298362
RE: INSERT OUTPUT INTO (With an extra column) and SELECT statement

Let's see if I understand this correctly. If we take the information from your last post, and only do the inserts for TableC, you then want to insert all 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

March 14, 2011 at 8:18 am

#1298344

Viewing 15 posts - 1,696 through 1,710 (of 5,588 total)