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 2 years, 6 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...

Schedules aren't executed, it's the jobs that are, the schedule just denotes the time(s) that job runs. If you can't see that the job was executed at that time then,...

One method would be to check if the current row isn't NULL and use LAG to check the prior row was NULL and if this is true then denote it...

Misunderstood. Apologies....

No, it's certainly...

In truth, I need to do my own testing on it as well. I...

So where do these linked integers come from? Why, for example, is 1 linked to 1, 2, and 3, but the numbers 8 to 14 only linked to...