Viewing 15 posts - 1,231 through 1,245 (of 13,855 total)
The following method is likely to be faster and easier to read than PIVOT:
(Note that column names must be unique)
SELECT PKGId = ct.PC_Pkg_Id
...
August 22, 2022 at 4:28 pm
Try using exactly the same query as your source, but with none of the CONVERTs, and see what happens.
August 22, 2022 at 2:49 pm
Sounds like you need to pay for a software licence.
August 18, 2022 at 12:41 pm
So you are flipping the ones to zeros and vice versa?
DECLARE @SomeTable TABLE
(
SomeId INT IDENTITY(1, 1) NOT NULL
,Sex TINYINT NOT...
August 16, 2022 at 10:36 am
Thank you Jeff.
It was just an example code from a book I'm reading intended to exemplify the use of WHILE in TSQL.
Alejandro
You'll find very few cases in T-SQL where...
August 16, 2022 at 7:00 am
Did you follow the instructions here when attempting the library install?
August 15, 2022 at 2:52 pm
Is there any chance that you can post a properly formatted version inside a code block. It is unreadable as it stands.
August 15, 2022 at 1:29 pm
Is this really the exact error: "pip is configured for with location that require TLS/SSL SSL module in python is not available" ?
It does not make grammatical sense.
August 15, 2022 at 1:26 pm
Why not download the developer edition and install it on your own machine? Then add the sample databases (AdventureWorks, Contoso) and you have a good starting point.
Keep an eye...
August 15, 2022 at 10:22 am
In my question i gave example already, pls read fully.
You have not provided source data. Please read Eirikur's post fully.
August 15, 2022 at 8:35 am
With > 50,000 points, I should not need to tell you this, but please provide your test data in consumable format, not as an image.
Note also the correct spelling of...
August 13, 2022 at 4:39 pm
Just played around with this & couldn't find a way to solve it. As already suggested, you could
Select All / Copy with headers / Paste to Excel
if you really dislike...
August 13, 2022 at 4:35 pm
Frederico and I have both suggested solutions. Have you decided that they are not applicable in your case? If so, please explain why.
August 12, 2022 at 1:11 pm
Can you demonstrate this issue by providing some consumable test data?
August 11, 2022 at 2:17 pm
Hello and welcome to the forum.
As this is purely a SQL Server forum, you may find that you would get more help by posting in a MySQL forum instead.
August 11, 2022 at 9:52 am
Viewing 15 posts - 1,231 through 1,245 (of 13,855 total)