INSERT INTO TableA

SELECT * FROM TableB

This will do it, but with a derived table, you'll have to either define a temp table or table variable to hold the results, or have the derived table definition...

This should get you started. You'll need to place your derived table query in place of the @DerivedTable variable in the FROM clause.

DECLARE @DerivedTable TABLE (Loca int, Item# int,...

nunYoBidnez (10/12/2007)

---

Hi Adrian, watch that Engineer stuff, I are one.:D I can understand that, you are right. She did ask. I am just suggesting we meter the response. Tough love...

I'll add the book to my list; however, I will have to disagree with pretty much everything else you've stated. The motivation/self-help industry is a multi-billion dollar industry here...

nunYoBidnez (10/10/2007)

---

Forget those books they are a waste of time and effort! Here is a book that includes everything you will ever need to know.

The Little Prince by Antoine de...

It couldn't hurt to read it again. Also try 'The Magic of Thinking Big', 'Thinking For a Change', Proverbs, 'Enthusiasm Makes the Difference', '360 Degree Leader', 'The Sucess System...

Einstein also said that you cannot solve a problem at the same level of thinking you were at when you created the problem.

For instance, this is why the...

This should be an easy change to rollback if needed as Steve has suggested. This could also be easily tested on a test system if you have that available....

Sure thing:

Browser - IE 7.0.5730.11

OS - XP Pro SP2 (we keep our security pretty much up to date)

MS Office 2003

Matt Miller (10/9/2007)

---

Are you looking for a blank record between groups? Are you trying to create a report object (as in a SSRS report) of some sort? Views...

I think there's more here than meets the eye. Can you post a complete result set for what you are after? If you are truely after the results...

Also, keep in mined that these changes will not take effect until you stop/start SQL Server.

Here you go, thanks Steve.....

How much memory do you have in your machine? What is the Min/Max memory set at in sp_configure? If you monitor Target and Total SQL Server memory in...