Viewing 15 posts - 451 through 465 (of 59,066 total)
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
"On the plus side, storing telephone number as int uses less storage than a varchar. Ok you won't need to use any numeric functions on it, but you probably...
July 12, 2024 at 2:27 pm
If the original input string is necessarily an NVARCHAR(anything), then DelimitedSplit8K is probably the wrong tool to use because it will slaughter certain NVARCHAR characters in the conversion to VARCHAR.
Where...
July 11, 2024 at 5:47 am
Ok... good.
1. What is populating the [D_ID]? A SEQUENCE?
You have nullable columns and, because you have PAGE compression turned on, almost all of the columns (even the supposed fixed size...
July 11, 2024 at 5:39 am
And yet it's still absolutely stupid about certain "simple" things... In the example below, this is NOT the right way to solve the given problem. Even the note...
July 10, 2024 at 7:02 am
Viewing 15 posts - 451 through 465 (of 59,066 total)