Viewing 15 posts - 31 through 45 (of 4,949 total)
Yeah....I agree. I didn't think we could get the resource issue fixed for running the CTE solution. It's in Starburst, not SQL Server. But, thank you. This would be...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 6, 2022 at 8:07 am
For the sample DDL I gave you above, the only other field I would add would be:
branch: varchar(2000)
What DDL? What about the DML? You havem't given any. DDL is...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 6, 2022 at 8:05 am
Are you able to provide us with some sample data for your expected results in DDL and DML statements? That'll help us help you.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 5, 2022 at 8:07 am
No telling how Microsoft jumps on things like this, but you're probably correct.
Unfortunately very true. Considering VS 2022 actually came out in 2021, I wouldn't put it past them...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 5, 2022 at 8:05 am
Yep. You need the latest version to work on the latest version. Forwards compatibility is generally not a thing.
Well, SSDT for Visual Studio 2022 is out as well, so...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 4, 2022 at 2:55 pm
Why are you trying to install SSDT 2017? That won't work with SQL Server 2019.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 4, 2022 at 2:34 pm
Hi
Main requirement is to show data in Pivot & display Grand Totals of columns. Columns will be dynamic.
Display the results
Thanks
So as mentioned, why not pivot your data in the...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 29, 2022 at 11:08 am
Hi
It does not show results. It gives message 2 rows affected. I have written execute(@query) also
Thanks
Of course it won't, the data was inserted into a table, not returned to...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 29, 2022 at 9:12 am
Try this
SET @query
= N'select * into #FinalResult from
(select Name, ' + @cols
+ N' from (select name,quantity,itemname...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 29, 2022 at 8:08 am
Presumably, then, dtkey
is a foreign key to a Calendar table, so why not JOIN
to said calendar table and then do WHERE CalendarTableDateColumn > ?
?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 27, 2022 at 1:08 pm
I don't see how the above has any relevance to SQL Server. it feels more like you've posted your homework question into the topic, if i am honest.
What is it...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 26, 2022 at 4:14 pm
Okay, this is VERY weird. My last post, when I hit submit, errored out with "Are you sure you want to do that?"
And when I hit submit again, it...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 26, 2022 at 1:12 pm
Honestly, I would create your entire statement on the fly and use conditional aggregation, not the restrictive PIVOT
operator, then you'll find this much easier. Also the syntax SELECT @Variable...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 26, 2022 at 10:53 am
from or T0
OR
is a reserved keyword, if your table is really called or
then you need to delimit identify it (or better yet, rename it to something...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 26, 2022 at 9:18 am
For question 2, you likely want a windowed AVG with an ORDER BY clause in the PARTITION BY. Without sample data, or expected results, it's difficult to know.
For question one,...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 26, 2022 at 9:11 am
Viewing 15 posts - 31 through 45 (of 4,949 total)