Viewing 15 posts - 91 through 105 (of 105 total)
wait a minute, Revenant, that query is not quite returning the correct result. It returns only one name per ssn and yet there are two names sharing each of...
January 19, 2012 at 11:42 pm
I have the same *general* problem with a slight twist. In KlineandKing's scenario the name needed to be listed only once for the sum(grade).
In my case there are duplicate...
January 19, 2012 at 8:16 pm
Bingo. Thanks for that. That led me to some useful links eg http://www.sql-server-performance.com/2007/temp-tables-vs-variables/
January 19, 2012 at 1:07 am
Dan, I'm studying this solution. Please tell me where the tables are being created with syntax 'DECLARE @InEvent Table' and 'INSERT into @InEvent'. This is neither a concrete table...
January 18, 2012 at 11:34 pm
Sorry I missed that! Time to download a Denali trial.
January 18, 2012 at 5:43 pm
Paul,
you mean to eliminate need for CAST() use CONCAT to force the comma and salesorderid to be treated as a string?
I tried but got error
Msg 195, Level 15,...
January 18, 2012 at 3:34 pm
That is really great to read relevant documentation. Integer has precendence over varchar. But, I had tried to convert the comma to an int using the CAST function...
January 18, 2012 at 11:32 am
Thank you venugopal.rr and Paul. I was thrown by the reference to ','. So, because the salesorderid is being output as XML, it must be cast as varchar...
January 18, 2012 at 1:26 am
Would either of you mind helping me with this some more? I am still practicing the FOR XML PATH technique and I want to apply it to a nearly...
January 17, 2012 at 10:15 pm
WayneS, that article was dead on, spot on. Thanks.
January 16, 2012 at 7:44 pm
Thanks to both of you. I'm reading up on FOR XML clause, PATH mode, and STUFF function right now to be sure I know how to manipulate returned sets, and...
January 16, 2012 at 5:50 pm
SQL Kiwi, I added my create and insert script so that someone else who comes to forum may be able to duplicate solution that I posted, if they were inclined...
January 16, 2012 at 12:03 pm
OK. I will do that.
CREATE TABLE [dbo].[ShoeColor](
[shoeID] [int] NOT NULL,
[shoe] [varchar](30) NOT NULL,
[varchar](30) NOT NULL)
INSERT ShoeColor
(ShoeID, Shoe, Color)
VALUES
(1, 't-strap', 'blue'),
...
January 16, 2012 at 1:43 am
Note*, I believe the consensus is that cursors and while statements are not preferred. A non cursor based solution would be ideal, for concatenating multiple rows of colors into...
January 15, 2012 at 7:53 pm
Viewing 15 posts - 91 through 105 (of 105 total)