You know, the people that help out here are all un-paid volunteers, so please HELP US HELP YOU. Providing the DDL scripts (CREATE TABLE, CREATE INDEX, etc.) for the tables...

Jeff Moden (10/28/2010)

---

Brandie Tarvin (10/28/2010)

---

FYI: Aside from Demo-titis, Grant had a pretty good presentation. Wish I could go to PASS and see the full 90 minute one.

Now I'm obsessing about...

Yes - it's the Local system account. And I'm not being a smart-a**. There is an account called this. It is probably a suitable account to use, unless you need...

Craig - I see you came through on your threat of a ST avatar! Seems appropriate, especially in the thread with Joes latest rant.

Yes indeed. Some are bashing Joe while others are trying to help the OP - and...

mbender,

I see one thing in the TVF - you're calling another function to get the first day of the month. I don't know how you're doing that, but this is...

Joe,

Your online persona has a negative attitude, is obnoxious, and is borderline crass. Just chill it.

Better yet, let the others out here help out. We can work with these people,...

Roy Ernest (10/28/2010)

---

Ouch... Steve, this guy might be good but he is going to scare away OPs. Better have a talk with...

SELECT CONVERT(CHAR(10), CONVERT(datetime, DateColumn), 120);

Michael Valentine Jones (10/28/2010)

---

If anyone is wondering where 22801 came from:

Make Date function (like in VB)

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=22339

Although I would have assumed that anyone would realize without explanation that 22801/12 = 1900...

If it's possible to do, what really needs to be done is to...

dtopicdragovic (10/28/2010)

---

Hi,

I am trying to execute this statement and I suppose there is a problem in apostrophes, but I don't know how to make it work.

Exec ('SELECT DISTINCT ' +...

The code that creates the dynamic tables is run through an Execute SQL Task, connected to the SQL db:

CREATE PROCEDURE dbo.MyProc(

@SY varchar(10)

)

As

declare @SY_0 varchar(10)

declare @SY_1 varchar(10)

declare @SY_2...

Precisely. Something like this:

declare @SearchRange varchar(8);

set @SearchRange = 'N2100';

declare @SearchPrefix varchar(8),

...

Brandie Tarvin (10/28/2010)

---

Are you using PIVOT or COALESCE in your code to generate the column names?

I ask because the closest thing I've got to what you're doing sets a variable...