A good example to follow. It's in my 2010 goals.

Alvin Ramard (2/5/2010)

---

That's right. It only works on...

The WITH INDEX hint forces the optimizer to use the index you specified. This hint shouldn't be used, unless you already found out that the optimizer, for some reason, fails...

BTW, it looks like you are working with SQL Server 2005/2008: be sure to pick the right forum.

Why posting here? It's a very old thread, I suggest that you start a new one.

Check the recovery model for the database. Is it simple or full?

Set it to simple, then shrink the log files.

I see. You're trying to do something impossible.

Try this instead: create two temp tables (eg. #table1 and #table2), insert into each table the results from the two procedures and join...

The message you are getting means that Table1 has a different number of columns from the output of Query1.

If you just want to insert some columns, declare it explicitly:

INSERT #Table1...

Given that Query1 and Query2 give the same output columns, you coud do something like:

INSERT #table1 EXEC Query1

INSERT #table1 EXEC Query2

Now there's one!:-D

What about sqlcmd?

You could provide the script name through the -i argument.

If you are working with SQL Server 2000/7 there's OSQL that works quite the same way.

This remembers me when I attended High school and Slash (Guns and Roses guitarist) died something like once a...

Very strange thing, Lowell, this post is considered harmful by google Chrome. It says http://www.stormrage.com contains malware...

GilaMonster (2/2/2010)

---

I'm fast losing both patience and hope. The last month, it feels like I've been correcting almost as many replies as I have been answering questions

http://www.sqlservercentral.com/Forums/Topic856902-145-1.aspx#bm857286

http://www.sqlservercentral.com/Forums/Topic475163-146-1.aspx#bm856344

http://www.sqlservercentral.com/Forums/Topic855771-360-1.aspx#bm855992

Am I getting too...

What about:

INSERT INTO dbo.StandardSubject (AssessmentSubjectID, [Name], Description, AdoptionYear, IsActive, [RowVersion])

SELECT *

FROM (

SELECT AssessmentSubjectID = NULL,

[Name]...