Viewing 15 posts - 421 through 435 (of 59,041 total)
Install this TVF.
Then this SQL will do the job
select x.value value1, x.value+1000001 value2
from dbo.GENERATE_SERIES(-999999999,+999999999,1) x
;
Install this TVF.
Then...
July 18, 2024 at 4:33 am
After long hours, days and weeks the system back to healthy state. The biggest problem was bad developers code that had to be changed. That was killing the...
July 18, 2024 at 4:24 am
I guess our code coverage is 500% plus a post prod kicker...
DEV
QA
DEVREVIEW (DBA Review and regression checks)
STAGE (UAT)
PREPROD (UAT and full system checks on full size from nightly restores which...
July 18, 2024 at 4:19 am
2nd page bump to get post to appear
July 16, 2024 at 4:41 am
-- Create TableA CREATE TABLE TableA ( MainID INT, JoiningID INT );
-- Insert data into TableA INSERT INTO TableB (MainID, JoiningID) VALUES
(No column name)
...
Heh... you didn't try to run...
July 16, 2024 at 4:36 am
Attached is some sample data. I could get this code to work, by inserting one row where FY/YEAR is 2024 and all of FY/YEAR 2025.
The original tables data goes...
July 16, 2024 at 4:30 am
I'd rather go for a nice dinner and maybe some pool shooting at a good bar with big screens to watch the lions game than to get caught up in...
July 16, 2024 at 3:41 am
Hi, I' am currently in the process of designing the Data Warehouse spec for my company (Start up Business),
During discussions a number of the technical leads and C# developers...
July 13, 2024 at 7:40 pm
Jeff Moden wrote:With some luck, one of the sessions I submitted will be selected and I'll "make the trip" to Pittsburgh!
will you drive or fly Jeff 😀
Drive. Right now, it's...
July 13, 2024 at 3:02 pm
Hello Jeff, I came across your presentation while researching the evils of using GUIDs as PKs and to say it was very informative would be an understatement. Do you...
July 13, 2024 at 1:42 pm
disregard. i found it. I'll reply w/ what i end up with to close the loop
Did you ever find the solution? If so, would you be kind...
July 12, 2024 at 5:29 pm
Ah... be careful now. That's absolutely not possible.
Be carefuller - What happens when the number is not part of that plan?
All phone number in the UK start...
July 12, 2024 at 5:20 pm
Haha how do I do that?
In an attachment?
Haha... Just like you've done before...
https://www.sqlservercentral.com/forums/topic/hierachy-by-tsql#post-4093618
July 12, 2024 at 5:17 pm
Here you are courtesy of ChatGPT
Heh... Ok... since you brought it up, what prompt(s) did you use?
The key here is, again, the folks answering the questions shouldn't have to...
July 12, 2024 at 5:13 pm
I worked with one company that stored phone numbers as integers. Yes. Plural. They broke up the 10-character US phone numbers into separate AreaCode (first 3 digits), Exchange (Next...
July 12, 2024 at 2:29 pm
Viewing 15 posts - 421 through 435 (of 59,041 total)