Viewing 15 posts - 1 through 15 (of 24 total)
Hi Jeff Moden,
Your Trigger looks working (Insert & Update). But Delete, I need TrnxUserId same like CrtBy and UpdBy. Not User in SQL Server
This is the Front-End...
March 28, 2022 at 1:32 am
Any chance you can convert that multiline scalar function to an inline table value function? Multi-line scalar functions can perform poorly, and your function has a WHILE
inside it,...
March 9, 2022 at 9:11 am
Thanks. It workable
January 16, 2022 at 9:18 pm
Thanks to all
Adelia,
Don't go yet. I asked you some questions about datatypes that you've not answered yet. If you let me know that the datatypes of the start...
November 5, 2021 at 6:16 am
Thanks to all
November 2, 2021 at 9:42 am
I got the answer. Yeahhh
September 14, 2021 at 2:26 pm
You have data. How about posting CREATE TABLE and INSERT scripts so we can see what you're working with? While you're at it, post the expected result... but for...
September 13, 2021 at 5:27 pm
It's perfect
August 31, 2021 at 11:48 am
It's working
August 30, 2021 at 7:58 am
Adelia, what are you're struggling with?
You've been given a function which gives you all the right numbers, all you need is to incorporate those numbers into a string of...
August 30, 2021 at 6:17 am
Calculate the minutes and seconds the same way you did the years, months and days - using DATEDIFF. Formatting of the type you describe is best done in the...
August 30, 2021 at 4:34 am
This should show you how:
Hi Sergiy,
Just created your Tally Generator. Consider this,
DECLARE @date1 datetime, @currentDate1 datetime
SET @date1 = '8/26/2019 06:23:45 PM'
Set @currentDate1...
August 26, 2021 at 1:50 pm
Viewing 15 posts - 1 through 15 (of 24 total)