Thanks...I'll give that a go and see what happens.

Hi,

The SQL Server agent service account has permissions on the .xls and also I have used the UNC notation and that also failed withthe same error.

I'm using a stored procedure to do the insert and in this case when a customer places an order I want to capture the customerID and insert that into the...

Hi All,

Below is the solution I used to resolve my issue.

Thanks for all your help

DECLARE @Company_Codes VARCHAR(MAX)

--drop temp table

IF OBJECT_ID(N'TEMPDB.dbo.#temp',N'U') IS NOT NULL

BEGIN

DROP TABLE #temp

END

CREATE TABLE #temp (CODE...

Thanks guys!

I am not using dynamic sql I'm using static sql and unfortunately I quite baffled as to how to approach this in my code.

Thanks for your help, I will play...

It will be a set of rows as shown below which is a string, so in practise when HCB and RBC are selected it should pass through the query as

AND...

Here is the code as requested

Thanks

Declare @Period_End smalldatetime

, @Branch_Name_Code varchar (10)

, @Department_Group_Code varchar(10)

, @Data_Type_Code varchar(3)

, @Currency_Type varchar(4)

, @Company_Name_Code varchar (4)

SELECT

@Period_End AS Period_End

, Data_Type_Code

, Department_Group_Code

, Company_Name_Code

, Master

, Insured

, Number

, Claim_Title

, Date_of_Loss

, Currency_Type

, '' as Accounting_Currency

, Gross_PD

, Net_INC

FROM vw_Table_Summary

WHERE Period_End=@Period_End

AND Data_Type_Code=@Data_Type_Code

AND Branch_Name_Code=@Branch_Name_Code...

I'm getting compilation error when use your example code and the reason is due to 'DELETE top ( @BatchSize )', I'm using sql server 2000 and I believe this doesn't...

The recovery mode is set to SIMPLE

Thanks

I'm deleting a certain records in the table...also the link you provided doesn't work unfortunately

I used the dynamic sql as suggested and it works perfectly.

Thanks alot for your help 😉

I have found a solution using a cursor but if anyone knows any other solution then please let me know

declare @temp table

(ID int,

Name varchar (20)

)

insert into @temp

(id,

name

)

SELECT...

Thanks for your help Jon!