4 byte is 4 bytes. Won't make any difference there.

Now the annoyance you'll have is that you'll have to constantly cast it back to smalldatetime for any of the...

Steve Jones - SSC Editor (6/7/2011)

---

My apologies. The question has been corrected with a count(*) instead of a SELECT *. I am sure that I saw 50 results in testing...

I know.

Question corrected.

Thanks for feedback.

Time for a work...

Did you guys actually read the question recently??? It says count(*).

Don't care actually. 2000 has been out of support for YEARS.

You're moving to sql 2008 so make it work for 2008.

Sorry if this is bad news but it's not...

There are 0 exceptions to that rule. If you want order by you MUST use order by.

Then go in your proc or sql query, find which column is duplicated and fix it.

What's unclear about the error message??

Are you using a system proc?

If so you can go in master or msdb and see the source code in both system.

You could also just run them on both servers...

dmoldovan (6/7/2011)

---

cfradenburg (6/7/2011)

---

wware (6/7/2011)

---

cfradenburg (6/7/2011)

---

I see your post regarding 1 batch vs. 3 batches, but I don't see an answer about why SSMS suggests a syntax problem with the "50"...

In the resultset you use the same column name twice.

Happens with sp_who2 if you want an exemple.

The only workaround is to delete or rename the extra column.

Might want to edit this one too ;-).

P.S. 4 billion GB of ram would be nice :w00t:... maybe some day!

ELSE @BoD END between FromDate and ToDate

Here's one...

INSERT EXEC failed because the stored procedure altered the schema of the target table.

Damn copy / paste!

Ya but how much WITH the vats, maybe this is where you're getting a better deal.

If not you just need to contact sales again and expose the problem.

I know mysql has a scripting function that creates a sql server script to create the tables and insert the data.

The realy question is there how do you refactor the...