Viewing 15 posts - 46 through 60 (of 4,949 total)
Couple of initial questions, why do you INSERT
the rows from your parameter @ezy_SMSNotificationItemDetailsType
into a user defined table variable @SMSDetailTable
? Why not just use the contents of @ezy_SMSNotificationItemDetailsType
? Why...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 21, 2022 at 1:15 pm
Correction, SSRS for VS2022 is available. There is no VS 2022 release (yet) for SSIS and SSAS; you need to continue to use VS 2019 (which Thom~ Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 19, 2022 at 2:55 pm
SSDT apparently now available for VS 2022...
https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt?view=sql-server-ver15
SSDT was available since the launch of VS 2022; the SSAS, SSIS and SSRS extensions are not. Since 2016 (iirc) SSDT...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 15, 2022 at 10:57 am
Is Gail now going by they / them? I only ask because I didn't hear about it and I don't want to misgender Gail.
This is just a habit of...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 14, 2022 at 5:12 pm
Out of interest, has anyone heard or seen from Gail in awhile? I haven't seen them about in ages. I noticed that their website has been down a little while...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 14, 2022 at 11:12 am
But where did you get confused in the article? I assume you want a dynamic pivot, which the articles do explain.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 13, 2022 at 8:58 am
Good day
sidlfc08,
I would like to do the same condition ( transposing date column to rows )
Can you please share with me your query statement to solve your initial question.
I...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 13, 2022 at 8:27 am
You've not set the connectionstring property to be an expression, you've set it to be literally the value Provider=Microsoft.ACE.OLEDB.12.0;Data Source=@[User::IntegrationFile].xlsx;Extended Properties="EXCEL 12.0 XML;HDR=YES";
, and your file path to be literally...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 8, 2022 at 8:00 am
I would like to split Event column based on data type as shown in Data type column.
That sentence honestly makes no sense and doesn't explain anything. To repeat myself:
Explain...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
March 29, 2022 at 7:47 am
Images of data aren't going to help us help you. Post the data as DDL and DML statements. Also explain the problem, what are you expected results here? What have...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
March 28, 2022 at 2:13 pm
Yep, start
Shifting gears a bit... the following message started showing up on my machine some time ago (seems like at least a week) on every post thread and ONLY...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
March 25, 2022 at 11:52 am
Honestly, I'd suggest doing this in the presentation layer. In, for example, you are in SSRS you could use an expression like this:
=StrConv(Fields!YourColumn.Value, vbProperCase)
C# has the string...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
March 24, 2022 at 4:16 pm
Looks like an SQL question. Suggest you post in the appropriate forum, trim down your request, provide some sample input and output data that someone can just run to...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
March 17, 2022 at 4:13 pm
Did you have to post this four times...? I thought 3 times in the same sub-forum was bad enough, but 4 times? Now I don't know if you want a...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
March 17, 2022 at 10:52 am
Assist with what? You've posted this in the SSIS forum, so are you looking to pivot the data using SSIS? Where did you get stuck? Posting the topic 3 times...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
March 17, 2022 at 9:04 am
Viewing 15 posts - 46 through 60 (of 4,949 total)