After playing around with this a bit, yes it needs to be done separately. It can be combined on the CREATE TABLE, but not on the ALTER TABLE.

So:

ALTER TABLE systeem...

You've actually got two things going on:

1. The selection of the records to insert, and

2. The actual insertion of records into the table.

As everyone else has already covered, the use...

MissyDaisy (8/27/2010)

---

As for the way I ask questions, I was once kindly and gently trained by this forum to format their content to facilitate the possibility of quickly getting an...

take out this line of code...

Order By Substring(CONVERT(varchar(19),RegisterTimestamp,120),1,7) ,Sorce

Just one point of clarification: the issue isn't with DTS/SSIS. It's with the Jet driver, used to access Excel spreadsheets by those programs. The same problem will show up when...

Using OpenRowset/OpenDatasource, it can't be done.

However, you can accomplish the formatting by:

1. Use the Export wizard.

2. Use a SSIS package.

3. Use the sp_OA procedures to perform OLE Automation. This article...

This is getting into the realm where I'd have to start using Google/Bing to find the answer... so I'll leave that exercise to you. I know I've seen it out...

I think we can get around the parameter sniffing and make this work properly.

First, change this code:

Set @Today = GETDATE();

set @Today = @Today - 1

Set @Year = (select YR_NUMBER from...

I think the default needs parenthesis around the value:

DEFAULT (0), not DEFAULT 0

r.vanlaake-1086273 (8/27/2010)

---

Hi there,

I need a script to change a TINYINT (not null default 0) TO DECIMAL(6,3).

These are my results:

ALTER TABLE systeem ALTER COLUMN aantal_dagen_vooruit_in_te_plannen DECIMAL(6,3) NOT NULL DEFAULT 0

Incorrect syntax...

Start Menu | All Programs | Microsoft SQL Server 2005 | SQL Server Business Intelligence Development Studio.

Start a new reporting project, and you're in.

RiaRay (8/26/2010)

---

Hello,

I have got 3 tables in one schema. I am selecting a few columns from the 3 tables using join.Apart from that i am hard coding columns and displaying...

Jeff Moden (8/26/2010)

---

I'm waiting to hear back from the OP of what he wants to do if a couple of million row were to be returned because I'd like to...

Set up a named range in the second excel spreadsheet. Insert into the named range, not the tab (tabs end in $; named ranges don't).

Edit: you can also specify the...

Sergiy (8/26/2010)

---

Can you explain this sequence?

18271999 2010-08-03 07:49:00.000

18271988 2010-08-03 07:51:00.000

And what should happen after 08:05:00.000?

Should the next record be after 08:10:00.000?

Or should it be the first record of the next...