Viewing 15 posts - 1 through 15 (of 1,208 total)
You're welcome. You could also do:
Create TRIGGER [dbo].[tinsert]ON [dbo].[TBL_LiveData]AFTER UPDATEAsDECLARE @Prozessstart integer = 0 -- An alternative method of setting a variable.,@liveDataValue integer ;SELECT @liveDataValue = value...
October 13, 2021 at 1:37 pm
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...
October 13, 2021 at 1:17 pm
What's tricky here? The "ensure"The comments don't really explain what you mean.
What's tricky here? The "ensure"
The comments don't really explain what you mean.
I was trying to be a bit circumspect to avoid giving away the answer so it's fair enough...
September 6, 2021 at 6:43 am
tricky as based on the way it was phrased there are 2 right answers
I agree. There's an implication in the question that caught me out.
September 3, 2021 at 9:12 am
My internet died last night and I've had to come to the office because it's still not back!
July 23, 2021 at 7:52 am
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...
July 22, 2021 at 2:19 pm
YES!"Nice to have: 2k years experience with DBCC TIMEWARP()."And then sit back and see how many people actually respond. @=)
"Nice to have: 2k years experience with DBCC TIMEWARP()."
And then sit back and see how many people actually respond. @=)
That made my whole week! Thanks for the...
July 6, 2021 at 6:21 am
Spam is one thing but don't let anyone convince you to try scrapple. It's not "the same thing" it's not even "similar" 🙂
My father in-law made scrapple, and...
March 9, 2021 at 7:36 am
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...
March 5, 2021 at 3:47 pm
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...
March 5, 2021 at 3:44 pm
Why are you worried about getting duplicates?If you make sure the same file isn't loaded twice then would that solve your problem?
Why are you worried about getting duplicates?
If you make sure the same file isn't loaded twice then would that solve your problem?
It's not the "duplicates" within a file that...
March 5, 2021 at 3:13 pm
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...
March 5, 2021 at 2:45 pm
Ok, own up, which one of us was it?
January 15, 2021 at 10:10 am
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...
January 15, 2021 at 7:38 am
You can use sp_update_jobstep. Are you sure you can't do it in SSMS? If you open the properties tab of the step in question you can edit the Step...
December 24, 2020 at 7:26 am