Probably not the answer you want to hear but my suggestion would be to use a development language that was intended to create a UI instead of a DBMS that...

Instead of trying to change the query you can change the procedure declaration. Something like

create procedure MyProc

(

@First int = -1,

@Second = -1,

@Third = -1

)

as begin

select * from employee where empid...

It sounds like one of the servers language is something other than english and you are trying use @@Datefirst to return the first day consistently across all servers.

You will likely...

if you are going to pull them from a spreadsheet you should look at the concatenation function. you could use this to create your insert statement before you bring it...

look up @@DATEFIRST on BOL.

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()