WayneS

Forum Replies Created

Viewing 15 posts - 4,951 through 4,965 (of 5,588 total)

RE: Are the posted questions getting worse?

Jack Corbett (10/19/2009)
WayneS (10/19/2009)
... banging head on desk ...
The developer's head right! 😉
Oh how I wish he were local... then it would be his head 😀
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, 2009 at 9:34 pm

#1067932
RE: Are the posted questions getting worse?

Hey Jeff... can you FedEx me your biggest, baddest pork chop launcher? I think I'm in dire need of it.....
Just had a "developer" send me some code.
SP "a" has 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 19, 2009 at 7:25 pm

#1067892
RE: The Future of Bits

Both.
As mentioned, there will be many more that deal with things at the object level. But, someone has to move those bits around for those to do 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

October 16, 2009 at 6:14 am

#1066820
RE: Can I move the log shipping monitor?

You might check this link out - but be forewarned - it doesn't look like it's been tested.
Since you're talking about a new server, you also could restore the system...
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 15, 2009 at 5:58 am

#1066193
RE: Are the posted questions getting worse?

GSquared (10/14/2009)
Some days, neither of those matters to me, and I'll spend hours on an intriguing problem. If the problem means I get to fire up some extra brain...
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 14, 2009 at 6:13 pm

#1066058
RE: Transfer Logins from SQL Server 2005 to SQL Server 2008 different server

I used this for copying from SQL 2008 -> 2008. It should work 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 13, 2009 at 6:08 pm

#1065454
RE: Need to get one row per customer for multiple columns of data

You know, the people that help out here are all un-paid volunteers. Providing the DDL scripts (CREATE TABLE, CREATE INDEX, etc.) for the tables affected, and INSERT statements to put...
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 13, 2009 at 6:06 pm

#1065453
RE: Are the posted questions getting worse?

GSquared (10/12/2009)
I could be mistaken, but he seems to believe that there's only one right way to do things. That's a significant part of what I've taken away from...
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 13, 2009 at 5:34 pm

#1065451
RE: help me

abair34 (10/9/2009)
CREATE PROCEDURE dbo.help_friend_with_homework (@NumberOfRecords INT)
AS
BEGIN
SET NOCOUNT ON
IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'CHEATTABLE')
CREATE TABLE CHEATTABLE (id INT, name varchar(50));
WITH i_copied_this_from_the_internet_CTE AS
( SELECT row_number() OVER (ORDER...
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 9, 2009 at 5:57 pm

#1064392
RE: Return multiple rows into one row (comma seperated) using COALESCE

Well, with 100+ points accumulated, you're not that new. But I'm glad that you will now be able to help us in the future... it really makes it sooooo...
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 9, 2009 at 5:47 pm

#1064390
RE: Are the posted questions getting worse?

Jeff Moden (10/8/2009)
Heh... I know it's a couple/three months old now but I've not seen it before.
Thanks for bringing this to us Jeff, I hadn't seen that reply. (And since...
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 9, 2009 at 2:52 am

#1063928
RE: Mutliple Values in a Variable

Regarding Mark's solution, what would (IMHO) be better is if your application already had this table defined. Those codes are coming from someplace, just connect the ClassCode to the ClassType...
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 9, 2009 at 2:26 am

#1063917
RE: TRUNCATE vs DELETE

Damian, I also thought it was on the easy side. But, I was also (pleasantly) surprised at the high number of folks that got this right (69% at the time...
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 9, 2009 at 2:15 am

#1063910
RE: Return multiple rows into one row (comma seperated) using COALESCE

You know, the people that help out here are all un-paid volunteers. Providing the DDL scripts (CREATE TABLE, CREATE INDEX, etc.) for the tables affected, and INSERT statements to put...
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 8, 2009 at 8:58 pm

#1063835
RE: declare cursor select from another database table

setlan1983 (10/8/2009)
Btw, why need put double dot before "Table1"? Why not single dot?...
But if I want archive the following:
1. "SELECT Sum(SalesAmt) AS TotalSales, COUNT(*) AS TotalTrans FROM DB_A.Sales WHERE TransDT...
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 8, 2009 at 8:35 pm

#1063833

Viewing 15 posts - 4,951 through 4,965 (of 5,588 total)