Considering this is a 12 year old thread, I'd suggest either starting a new one as things could easily have...

You're assuming an INSERT/UPDATE only ever effects one row; this is completely untrue. You are then trying to assign values to your scalar variables from CROSS JOINed queries. Take your...

• This reply was modified 1 year, 9 months ago by  Thom A.

If you want to...

As...

Honestly, the fact that ChatGPT makes the mistake of thinking that people age on 01 Jan, which is such a fundamental error, show that it can't be relied on when...

Secondly, the data was imported from excel in hh:mm format but it is coming up in sql as varchar.

I have tried casting it as int in sql to...

Why are you using a varcharto store the information? Can you have values that are 24 hours or longer? If not, a time(0) would seem more appropriate. If you can,...

Are FUNCTION1,FUNCTION2, etc, all user-defined scalar functions?

This is just the same solution as I use in Extract only the filename from a file path; get the right most characters of the string, using the location...

What is your reason for doing that? What functionality or performance benefit does the temporary provide over not using one...

SQLBits, but call for speakers closed months ago. That's the big one in the UK. Next is Relay. The call for speakers probably opens late spring. After that, Data...

For every else's sanity:

SELECT grppro.dbo.PLNT_TASKACT.TASKACT
FROM grppro.dbo.PLNT_PARAMETERS
     INNER JOIN grppro.dbo.SERIALA ON 1 = 1
     INNER JOIN grppro.dbo.PART ON 1 =...

• This reply was modified 1 year, 10 months ago by  Thom A. Reason: Mention CROSS JOIN

I suppose the question, then, is why do you keep deleting all the data and then inserting it (again?)? What is the need to delete all the rows and then...

If you are deleting all the data why not TRUNCATE the table instead? That would also reset the IDENTITY.

I hate to say it, but this has a terrible example. Your first trigger, Trigger_Insert makes the assumption that the INSERT only ever contains one row, which is simply not...