If you're running the .bat file as a Operating system (CmdExec) step, have you tried running it as a SQL Server agent proxy using credentials for a user that has...

You're welcome.  You could also do:

Create TRIGGER [dbo].[tinsert]

ON [dbo].[TBL_LiveData]

AFTER UPDATE

As

DECLARE 
@Prozessstart integer = 0 -- An alternative method of setting a variable.
,@liveDataValue integer ;

SELECT @liveDataValue = value...

The basic syntax to set a variable in T-SQL is

SET @Prozessstart = 0

Your example is missing the SET in the first two instances where you set your...

I  was trying to be a bit circumspect to avoid giving away the answer so it's fair enough...

• This reply was modified 3 years, 2 months ago by  Neil Burton. Reason: Edited for clarity

I agree.  There's an implication in the question that caught me out.

My internet died last night and I've had to come to the office because it's still not back!

We were supposed to be back in the office from Monday but with the advice from the government changing from "go back to the office everybody" to " go back...

BWWWWWWAAAAA-HAAAAAA-HAAAAAA!!!!

That made my whole week!  Thanks for the...

My father in-law made scrapple, and...

So you are just trying to make sure you don't load the same file twice. Maybe if you create another table of all the files you have loaded, insert...

I think you need to add the file "key" -- to identity the unique file being loaded -- to the data file to distinguish between rows.  That doesn't violate...

It's not the "duplicates" within a file that...

I think you've got what I mean and that kind of query would be my first choice.  But here's the rub, there will be rows in the main table like...

Ok, own up, which one of us was it?

So we have this third party shipping system that is...well...user hostile at best. To add insult to injury for the users the system has been suffering increased performance...

• This reply was modified 3 years, 10 months ago by  Neil Burton.