Viewing 15 posts - 3,211 through 3,225 (of 59,067 total)
First, really nice job on providing "Readily Consumable Data" AND it actually works without error! 😀
With respect to the output you posted, are you looking to pivot ONLY those rows...
July 3, 2022 at 5:59 pm
Not to worry, Carlton. They don't delete questions on this site except for SPAM. Thanks for the feedback.
The "pivoting" thing is actually pretty easy. In the old days, it was...
July 3, 2022 at 5:48 pm
None of the data between the two graphics matches each other nor does the test data. You need to be more clear and explain things like the other 4 statuses...
July 2, 2022 at 11:31 pm
Like I said, I've never had to do such a thing as that requested but... I believe that the user of a schema can create objects and that's about it. ...
July 2, 2022 at 4:06 am
If you want to play with something more substantial, here's a 10 million row table to play with, complete with expected indexes. Don't let the 10 million rows scare anyone. ...
July 2, 2022 at 3:28 am
Not sure how you figure the total for Jan, Feb, Mar 2022 is 11. There are 4 in Jan, 5 in Feb, and 4 in Mar. 4+5=9 + 4 =...
July 1, 2022 at 10:27 pm
Post removed: Ed B. is correct. I made the mistake of counting distinct counts per month and then adding those counts... I needed to treat each 3 month unit as...
July 1, 2022 at 7:39 pm
that i will read, but can i get a rough idea.
...
pls give me one example ( a rough one) for the above need.
It's a funny thing... I've been working...
July 1, 2022 at 5:41 pm
It's nice to see articles on the basics of SQL server without it being a simple regurgitation of whats in the MS documentation and this is a nice one. Thanks...
July 1, 2022 at 5:10 pm
Just a tweak to Drew's awesome rendition...
Drew uses the MONTH() function. I believe (I've not tested it) that will limit his good code to being used against only 1 year...
June 30, 2022 at 9:00 pm
If you'd like a tested coded answer, please read and heed the first link in my signature line below.
June 30, 2022 at 7:57 pm
If the files are to be used with "near enough" version of SQL Server, then using XML, JSON, CSV, or TSV is just nuts. The absolute fastest way to do...
June 30, 2022 at 5:10 pm
So, enquiring minds want to know, how'd it go on the interview?
June 30, 2022 at 3:50 pm
Perhaps you need to right click on the SSMS icon and select "Execute as Administrator".
June 29, 2022 at 10:00 pm
I'm really curious about this request. What is the intended use of the computed "Multiplier" column?
If the answer is to determine which day is (for example) "3 business days away", ...
June 29, 2022 at 5:03 pm
Viewing 15 posts - 3,211 through 3,225 (of 59,067 total)