insert into #temp1(myfield)

select myfield from #temp1

--edit

disregard this post. I posted after reading roughly 2/3 of the question. 😀

can you post the create table scripts and the insert you are trying to run?

Yeah you were close.

it should be

SELECT WORKER_NAME FROM WORKERS WHERE SKILL1 = 'REFEREE' or SKILL2 = 'REFEREE' etc.

What type of error? Are both columns text data type?

At first I couldn't understand the "relationship" because it was in the identity column. :hehe:

Once I actually ran your create script it was very clear what you are trying to...

It sounds like Powerpoint is not the reporting solution you should be using if you need dynamic data. Maybe you can look into using SSRS instead. that way you get...

I don't see how this would be possible. The backup operation is not like a sql statement. Think of it more like a sproc. It performs one function based on...

I must be missing something...would it not work if you just removed the loop and inserted the records?

if you can post the table structure and some sample data i will take a look at it.

close...

declare @NewRFQNumber int

select @NewRFQNumber = SCOPE_IDENTITY()

Just judging by the format of the code I will try this.

where delivery_date between @StartDate and @EndDate and

...

I don't know exactly what the requirements are but I will try...

where delivery_date between @StartDate and @EndDate and

...

Good point YSLGuru. I (once again) assume that a production environment would not use things like select * expecially in an insert. I certainly understand his point and agree whole...

Check out the scope_identity() function. You can insert the new header record. then you can retrieve the last identity value to use in your new children records. Hope that makes...

The problem lies in the where clause...

where delivery_date between @StartDate and @EndDate and

driver = e.emp_cd and

...