Viewing 15 posts - 1,666 through 1,680 (of 5,502 total)
Greg Edwards-268690 (4/20/2011)
Brandie Tarvin (4/20/2011)
LutzM (4/20/2011)
bitbucket-25253 (4/19/2011)
opc.three
The SSMS Tools Pack rocks! and so do RAR files
Care to share the link for the Tools Pack?
Is there anything wrong with...
April 20, 2011 at 12:01 pm
I'm a little bit confused...
You need "the per row value not an aggregated value", but you're using SUM(i.QTY).
Additionally, i.QTY is included in the GROUP BY clause.
Would it help if you'd...
April 20, 2011 at 11:47 am
bitbucket-25253 (4/19/2011)
opc.three
The SSMS Tools Pack rocks! and so do RAR files
Care to share the link for the Tools Pack?
Is there anything wrong with the link I posted originally?...
April 20, 2011 at 10:37 am
Brandie Tarvin (4/19/2011)
April 19, 2011 at 2:15 pm
duplicate post. please continue here.
April 18, 2011 at 1:23 pm
duplicate post. please continue here.
April 18, 2011 at 1:23 pm
You cannot have two ORDER BY statements in a single UNION query.
select Top 1
from News
where GeneralSport=1 and Type_ID=1
order by News_ID
UNION
select Top 1 *
from News
where GeneralSport=1 and Type_ID=1
order by News_ID...
April 17, 2011 at 3:28 am
Since it's a typed xml document you need to use a namespace declaration.
Instead of using OpenXml, I'd recommend using XQuery instead:
DECLARE @xml XML
SELECT @xml='
<OTA_HotelDescriptiveContentNotifRQ xmlns="http://www.opentravel.org/OTA/2005/12" EchoToken="E384570476" TimeStamp="2011-03-14T18:50:45.014+01:00" Target="Production" Version="2005" PrimaryLangID="en">
<HotelDescriptiveContents...
April 15, 2011 at 3:02 pm
Change the
SELECT * FROM @temptable
ORDER BY OnCall_start
section to return the columns you need by explicitly naming the columns instead of *.
Furthermore, you should reduce the...
April 15, 2011 at 2:33 pm
Tom.Thomson (4/15/2011)
LutzM (4/14/2011)
April 15, 2011 at 10:28 am
Craig Farrell (4/14/2011)
LutzM (4/14/2011)
April 14, 2011 at 2:47 pm
Nachdem ich den Artikel und die Kommentare bzgl. der Grammatikfehler gelesen habe, habe ich mich entschieden, ab sofort nur noch in einer Sprache zu schreiben, bei der meine grammatikalische Fehlerquote...
April 14, 2011 at 12:16 pm
Please ask your tutor if the update should be done using the extracted data or the XML structure. It will influence the solution.
As a side note: most of us already...
April 13, 2011 at 5:05 pm
You could either use a subquery to get the max effective date per code and join it back to the original table or you could use the ROW_NUMBER approach.
April 13, 2011 at 4:51 pm
You'd need to UNPIVOT your data followed by a PIVOT (either traditional using CrossTab or the PIVOT operator).
April 13, 2011 at 4:47 pm
Viewing 15 posts - 1,666 through 1,680 (of 5,502 total)