One, please, always, despite this being a technical question, talk to someone in legal at your organization after you decide on a path forward.

Two, I've been studying this for...

.

Heh... mine has started off with a bit of a "well that sucks" factor.  Whole new time-keeping system where they want me to categorize virtually every aspect of...

• This reply was modified 4 years ago by Neil Burton.

It's a big year for us next year because we're moving into AWS.  The initial migration will be like-for-like to maintain consistency but there's going to be the opportunity to...

One of my domain passwords expired yesterday so I asked the service desk to reset it for me.  I then spent half an hour trying to create a password that...

When you say the PDWEDT column is numeric, how exactly is it stored?  Your code returns '2021-11-28 hh:mm:ss.nnn' as  last Sunday with the precise time dependent on when the code was...

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 4 years, 4 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...