Viewing 15 posts - 1 through 15 (of 229 total)
I found this example very useful.
I do have a question regarding the efficiency of using recursion. Even though is get rids of explicit loops, does it result in...
January 10, 2019 at 3:27 pm
The sum of quantities encompasses all the UnitNo's of a customer in one single Total Qty for each customer, not separate sums for each individual UnitNo.
I would expect the...
April 16, 2018 at 2:05 pm
The CustomerTotal is the "to-date" value, i.e. the current sum of all quantities in all units up till the current transaction.
If an existing customer acquires a second UnitNo,...
April 13, 2018 at 12:53 pm
Finally out that meeting.
Works like a cham.
Thanks a million.
It's been quite a while since I used SQL Server Central - there used to be...
April 11, 2018 at 4:29 pm
Thank you for your prompt reply.
I just got harpooned in a staff meeting, so I will try it later tonight.
Regards
April 11, 2018 at 2:23 pm
Isn't using undocumented procedures simply asking for trouble ?
November 30, 2016 at 11:43 am
I definitely have to bone up on the WITH CHECK option.
Thank you for bringing this up Steve.
Learn something new every day.
September 15, 2016 at 8:48 am
tripleAxe (9/15/2016)
September 15, 2016 at 7:56 am
Eirikur Eiriksson (9/15/2016)
Here is a simple test harness which you can use
Again, another example of multiple senior contributors moving the goal posts farther away to better explore the subject, even...
September 15, 2016 at 7:53 am
Thank you for taking the time of finding the links.
Will definitely look them up.
Regards
September 14, 2016 at 2:34 pm
J Livingston SQL (9/14/2016)
j-1064772 (9/14/2016)
Clear explanation, thank you all.Still not in the mindset of a million rows ... My DB's are considerably more modest.
"Still not in the mindset of a...
September 14, 2016 at 2:26 pm
Clear explanation, thank you all.
Still not in the mindset of a million rows ... My DB's are considerably more modest.
September 14, 2016 at 1:25 pm
tripleAxe (9/14/2016)
How about this.....
SELECT 'AZ' [STATE], SUM(AZ) [VAL] FROM EXAMPLE
UNION ALL
SELECT 'NY' [STATE], SUM(NY) [VAL] FROM EXAMPLE
UNION ALL
SELECT 'PA' [STATE], SUM(PA) [VAL] FROM EXAMPLE
Yes, this was my question from the...
September 14, 2016 at 12:20 pm
Got surprised by that one. Not particularly intuitive.
Not that I would have committed it to production code, I would have found out by testing it.
By the way, this one...
September 9, 2016 at 11:56 am
RonKyle (6/1/2015)
While a programmer, I never heard that GOTO was bad. Why is that so bad?
A bit of ancient history.
The problem with the GOTO was magnified by the style...
September 9, 2016 at 10:39 am
Viewing 15 posts - 1 through 15 (of 229 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy