WayneS

Forum Replies Created

Viewing 15 posts - 3,016 through 3,030 (of 5,588 total)

RE: Excel Worksheets

Utilize an Execute SQL Task (connected to an Excel Connection), and run a "CREATE TABLE " statement. If the xls file doesn't already exist, it will be created. It will...
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 5, 2010 at 7:26 pm

#1232184
RE: How to delete database on production server

Lordy... I sure hope nobody actually tries to run any of the recent code postings on this thread. While it's been fun, I think you'll really should go back 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 5, 2010 at 5:59 pm

#1232172
RE: Sub query to return data recursively?

loki1049 (10/5/2010)
WayneS (10/4/2010)
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

October 5, 2010 at 5:55 pm

#1232171
RE: Are the posted questions getting worse?

WayneS (10/4/2010)
Alvin Ramard (10/1/2010)
Ok, time for me to put what's left of my reputation on the line. I predict that the Thread will hit 20,000 on Thursday, Oct 7th,...
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 5, 2010 at 5:48 pm

#1232168
RE: Are the posted questions getting worse?

This is too good not to pass on
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 5, 2010 at 4:24 pm

#1232136
RE: User::Variable not being updated in an SSIS Package

Jim Covington (10/5/2010)
I need to get access to a package variable to use in the steps of my ssis package.
I have created the Variables as type String and a scope...
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 5, 2010 at 4:21 pm

#1232133
RE: Are the posted questions getting worse?

GilaMonster (10/5/2010)
And just when I thought the project I'm on couldn't get any worse..
We're officially in UAT, though both the front-end dev and I are still developing. Had a meeting...
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 5, 2010 at 12:16 pm

#1231967
RE: Are the posted questions getting worse?

GilaMonster (10/5/2010)
Brandie Tarvin (10/5/2010)
WayneS (10/4/2010)
CirquedeSQLeil (10/4/2010)
I just realized who our drop database OP was. Doh
Hmm. This made me go look at previous posts. Quite interesting...
What did I miss?
This:
GilaMonster (10/4/2010)
For...
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 5, 2010 at 12:11 pm

#1231964
RE: How to delete database on production server

Lynn Pettis (10/4/2010)
As alluded to above in one of the posts, BEFORE dropping the database be SURE you take a FULL BACKUP of the database. This way you can...
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 4, 2010 at 8:22 pm

#1231425
RE: Are the posted questions getting worse?

Alvin Ramard (10/1/2010)
Ok, time for me to put what's left of my reputation on the line. I predict that the Thread will hit 20,000 on Thursday, Oct 7th, 2010.
...
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 4, 2010 at 7:55 pm

#1231416
RE: Are the posted questions getting worse?

CirquedeSQLeil (10/4/2010)
Alvin Ramard (10/4/2010)
Paul White NZ (10/4/2010)
jcrawf02 (10/4/2010)
Paul White NZ (10/2/2010)
Maybe, but you wouldn't have envied me and Justin carrying a sofa and six-burner BBQ up the stairs this morning....
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 4, 2010 at 7:45 pm

#1231414
RE: Are the posted questions getting worse?

CirquedeSQLeil (10/4/2010)
I just realized who our drop database OP was. Doh
Hmm. This made me go look at previous posts. Quite interesting...
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 4, 2010 at 6:47 pm

#1231397
RE: Are the posted questions getting worse?

WayneS (10/4/2010)
Chad Crawford (10/4/2010)
GilaMonster (10/4/2010)
Chad Crawford (10/4/2010)
Has anyone ever picked up the DVD from PASS Summit? Does it have all 150+ sessions recorded, or is it just...
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 4, 2010 at 6:39 pm

#1231394
RE: SQL 2008 SP2 installation

apat (10/4/2010)
This is a QA sever. Can other developers use the server to query database while the SP2 installation is in progress?
Do I need to restard SQL Server or reboot...
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 4, 2010 at 6:10 pm

#1231384
RE: Are the posted questions getting worse?

Chad Crawford (10/4/2010)
GilaMonster (10/4/2010)
Chad Crawford (10/4/2010)
Has anyone ever picked up the DVD from PASS Summit? Does it have all 150+ sessions recorded, or is it just one...
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 4, 2010 at 6:06 pm

#1231382

Viewing 15 posts - 3,016 through 3,030 (of 5,588 total)