In an effort...

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...

The 100 classes haven't been helping... I think I need the 200 classes now. :w00t:

Steve Jones - SSC Editor (10/27/2010)

---

I'll drop some topics out here for you. Here's a couple that I have saved up:

- Finding/changing the default backup location

- scheduling a trace

- duplicating...

Brandie, if I'm understand you correctly, you are saying to dynamically set the file name.

This part is fine... what I need is that columns associated with both the source SQL...

Brandie Tarvin (10/27/2010)

---

Look in the upper left hand sidebar. "Write For Us" has all the details. You'll have to...

Steve Jones - SSC Editor (10/27/2010)

---

I'll drop some topics out here for you. Here's a couple that I have saved up:

- Finding/changing the default backup location

- scheduling a trace

- duplicating...

Steve Jones - SSC Editor (10/27/2010)

---

BTW, speaking of technical stuff....

I wonder if any of you would be interested in writing to fill holes? I keep finding posts here, and elsewhere...

GSquared (10/27/2010)

---

WayneS (10/27/2010)

---

GSquared (10/27/2010)

---

WayneS (10/26/2010)

---

Gus,

Since you seem to know SSIS pretty well, I have a question for you. Is there a way to have a query that generates dynamic columns...

And how long after Friday do you think it will take for everything to be working...

Gianluca's solution is missing one minor, easily overlook thing. Easily fixed with four lines of code:

-- at the top of the code

DECLARE @OldDateFirst tinyint;

SET @OldDateFirst = @@DateFirst;

SET DATEFIRST 7;

-- put...

It sounds to me that what you want is a NULL. If so, just leave it undefined.

Or, if the value is being passed in:

declare @to_date datetime;

set @to_date= NullIF(' ', '...

GSquared (10/27/2010)

---

WayneS (10/26/2010)

---

Gus,

Since you seem to know SSIS pretty well, I have a question for you. Is there a way to have a query that generates dynamic columns exported to...

Does this help you out?

declare @str varchar(8000);

set @str = 'qothobnslfdnoweavnivmnqpwf';

;WITH

TENS (N) AS (SELECT 0 UNION ALL SELECT 0 UNION ALL SELECT 0 UNION ALL

...

Cross-posted. Please post all responses here.