WayneS

Forum Replies Created

Viewing 15 posts - 2,686 through 2,700 (of 5,588 total)

RE: How to have an Excel destination have dynamic column names?

Brandie Tarvin (10/28/2010)
WayneS (10/27/2010)
Brandie, if I'm understand you correctly, you are saying to dynamically set the file name.
Nope. That's a different, separate thing. You can dynamically create the file, 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 28, 2010 at 7:30 am

#1243530
RE: Naming Excel Worksheets Issues

Can you post the MSDN link so that we know what you're talking about? Seriously, pretend that you know anything about your problem, read the question you posted, and try...
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 28, 2010 at 12:33 am

#1243358
RE: Conversion of Base64 MD5 checksum to hexadecimal value

diamondgm (10/28/2010)
Now all that's left for you is to clean up the blood 😀
Agreed... I left a mess behind! :w00t:
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 28, 2010 at 12:30 am

#1243357
RE: Are the posted questions getting worse?

Jeff Moden (10/28/2010)
Ok... first one is done. I liked Paul's idea of "Phil McCracken" as the author. Please see attached just for a preview. Steve, I'll post...
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 28, 2010 at 12:18 am

#1243353
RE: New Topic Insert querry for 3 Months Tour Data

ankit.uneedme (10/27/2010)
I am Building a "CAB Booking Application" in that i have done few things:
1> Firstly i have created the Cab tour on particular Date.
2> Secondly i have plotted its...
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 27, 2010 at 11:57 pm

#1243344
RE: Conversion of Base64 MD5 checksum to hexadecimal value

christine.lawrie (10/27/2010)
I've got the Base64 -> varbinary sorted... you wouldn't know about the -> Hex conversion would you?
I've been butting my head against this for about a week now, there's...
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 27, 2010 at 11:13 pm

#1243339
RE: How to know the service account being used in Reporting Server?

smile_netz (10/27/2010)
Hi,
How do I know which account has been used for the reporting server?
Does the Windows Service Identity screen tells me this?
And what does it mean when it just says...
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 27, 2010 at 11:06 pm

#1243334
RE: Which table is used last

Jeff Moden (10/27/2010)
I may be misreading the requirements but can't you just determine when one of the indexes on the table was last used which would also indicate when 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

October 27, 2010 at 11:03 pm

#1243332
RE: ServicePack Updates on Cluster

Akkare (10/27/2010)
Hi
I need help for the below
Have 2 node sql cluster.what is the procedure to apply service packs and other updates on sql.
Kindly explain detail.
Passive node first. Reboot passive...
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 27, 2010 at 10:56 pm

#1243330
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (10/27/2010)
OK, sign up for articles. Please just pick one, then another when you finish.
If you have ideas, feel free to post them, but try 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

October 27, 2010 at 10:48 pm

#1243328
RE: Are the posted questions getting worse?

Paul White NZ (10/27/2010)
I don't get the SQL Spackle reference...
http://en.wikipedia.org/wiki/Spackling_paste
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 27, 2010 at 10:46 pm

#1243327
RE: Scheduling a trace

You mean like http://www.sqlservercentral.com/scripts/66808/?
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 27, 2010 at 10:41 pm

#1243325
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (10/27/2010)
BTW, SSC usually has a blogger at the blogger table during the PASS Summit. Usually it's me, someone that can take notes during keynotes 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 27, 2010 at 10:24 pm

#1243320
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (10/27/2010)
Ahhhhhhhhhh, overwhelmed already.
I'll try to look through here and do a short post in a bit capping off who might have what.
In an effort...
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 27, 2010 at 4:26 pm

#1243231
RE: get the first Sunday and last Saturday

SwePeso (10/27/2010)
Keep it simple and avoid any reference to SET DATEFIRST!
DECLARE@Year SMALLINT = 2011
;WITH cteCalendar(FirstOfMonth, LastOfMonth)
AS (
SELECTDATEADD(MONTH, 12 * @Year + number - 22801, 6) AS FirstOfMonth,
DATEADD(MONTH, 12 * @Year...
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 27, 2010 at 4:08 pm

#1243228

Viewing 15 posts - 2,686 through 2,700 (of 5,588 total)