WayneS

Forum Replies Created

Viewing 15 posts - 5,206 through 5,220 (of 5,588 total)

RE: Are the posted questions getting worse?

Paul White (6/14/2009)
Jeff might want top steer clear of it too :w00t:
Good advice for Lynn also.
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

June 14, 2009 at 7:38 pm

#1009434
RE: DBA job not busy enough

Jeff Moden (6/14/2009)
Also, test the restoration of backups and maybe write the standard guidline for doing such a thing. Maybe even go whole hog and setup/test a disaster recovery...
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

June 14, 2009 at 7:23 pm

#1009428
RE: Exporting Table to multiple excel sheets based on a field in a table

This article http://www.sqlservercentral.com/articles/Integration+Services/61542/ dynamically creates tabs in an excel spreadsheet and exports data (from a select statement) into it. It is designed to run from within SSIS. Note that 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

June 14, 2009 at 7:07 pm

#1009425
RE: Append output from SQLCMD in batch file

Jeff Moden (6/14/2009)
Heh... another one. I didn't say it would give a "forever" log and didn't write the code that way. I wrote the code to give 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

June 14, 2009 at 6:59 pm

#1009423
RE: Append output from SQLCMD in batch file

Jeff Moden (6/14/2009)
You've added a line of code the OP didn't have in the original problem and that new line is the one responsible for the incorrect operation.
echo %date% %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

June 14, 2009 at 9:54 am

#1009317
RE: Are the posted questions getting worse?

GilaMonster (6/14/2009)
Encountering that kinda attitude either in posts, PMs or emails makes me stop and ask myself why the hell I'm doing the forum thing in the first place.
Gail, 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

June 14, 2009 at 9:50 am

#1009313
RE: Using a tool or script to automate table and relationship creation based on certain criteria

info (6/13/2009)
I need to make 100 or so tables. I have tables called PartStatsXXX and the tables to be made will all be called PartReviewXXX. Some PartStatsXXX tables have corresponding...
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

June 13, 2009 at 7:33 pm

#1009215
RE: Append output from SQLCMD in batch file

Okay, here's some code to demonstrate what I'm talking about.
Save this code as a batch file, and run it:
for %%a in ("%windir%\*.exe") do SQLCMD -S ServerName -d master -E -Q"set...
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

June 13, 2009 at 6:03 pm

#1009204
RE: cancel account

Everyone that keeps posting is just helping to keep "forumloser" around. I suggest that everyone refrain from posting anymore to any of the threads that he has posted to.
At this...
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

June 13, 2009 at 5:48 pm

#1009197
RE: How to send mails using sp_send_dbmail with more than one query result attachments?

You could try putting the two queries into a procedure, and then specifying to execute that procedure as the query. That may do the trick.
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

June 13, 2009 at 10:44 am

#1009102
RE: DB structure

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

June 12, 2009 at 11:47 pm

#1009013
RE: Append output from SQLCMD in batch file

Jeff Moden (6/12/2009)
Leave the first "-o" alone. Change all of the other "-o" to ">>".
Old DOS warrior trick. 😛
Ahem. It's not very often that someone gets to tell...
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

June 12, 2009 at 11:42 pm

#1009011
RE: Using a complex SP to provide data for a Crystal Report

RBarryYoung (6/12/2009)
You know, I've always wondered why the #Temp tables that we create in SSMS (or QA) don't get destroyed when the batch/request ends. Shouldn't they run out of...
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

June 12, 2009 at 8:41 pm

#1008978
RE: How can i split up the zipcode and city from my table?

Steve Kinnaman (6/11/2009)
Thank you Wayne. Thanks to you I even figured out how to retain the space in the swedish zip by adapting your script like this:
select ...
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

June 12, 2009 at 5:32 pm

#1008948
RE: Append output from SQLCMD in batch file

carissa.chris (6/12/2009)
I have a batch file that runs all the sql scripts in a specified folder. The output is written to output.txt. However, each time a sql script...
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

June 12, 2009 at 4:20 pm

#1008933

Viewing 15 posts - 5,206 through 5,220 (of 5,588 total)