Viewing 15 posts - 6,526 through 6,540 (of 8,761 total)
Fundamental error here, ELSE is the last / unmatched clause, not a part of the higher case flow hierarchy, suggest you remove all but the last else statements within each...
November 25, 2014 at 1:02 pm
Gazareth (11/25/2014)
SQLRNNR (11/24/2014)
Eirikur Eiriksson (11/24/2014)
SQLRNNR (11/24/2014)
Jeff Moden (11/24/2014)
Eirikur Eiriksson (11/24/2014)
November 25, 2014 at 11:26 am
swoozie (11/25/2014)
It organizes perfectly except on the 5th table that I Need to...
November 25, 2014 at 7:18 am
Ed Wagner (11/25/2014)
Eirikur Eiriksson (11/24/2014)
Jeff Moden (11/24/2014)
Evil Kraig F (11/24/2014)
Jeff Moden (11/24/2014)
Eirikur Eiriksson (11/24/2014)
November 25, 2014 at 6:33 am
vignesh.ms (11/25/2014)
3. In query 1, will the sql server look for matching rows even after it found 1 row?
No, the column has a unique constraint
4. Will query 2 really gains...
November 25, 2014 at 12:55 am
SQLRNNR (11/24/2014)
Jeff Moden (11/24/2014)
Eirikur Eiriksson (11/24/2014)
November 24, 2014 at 4:55 pm
Jeff Moden (11/24/2014)
Evil Kraig F (11/24/2014)
Jeff Moden (11/24/2014)
Eirikur Eiriksson (11/24/2014)
November 24, 2014 at 4:52 pm
Jeff Moden (11/24/2014)
Eirikur Eiriksson (11/24/2014)
November 24, 2014 at 4:35 pm
Just a quick question to "the thread", am I missing something or is XML getting more popular? Just noticed that this topic on the XML forum has proportionally many times...
November 24, 2014 at 3:03 pm
Quick questions, can you post an example of the XML and how big are the files?
😎
November 24, 2014 at 2:58 pm
Quick suggestion as this isn't as complex as it seems at first, import the file's content into a staging table, one line per row and group/parse it from there.
😎
USE tempdb;
GO
SET...
November 24, 2014 at 2:45 pm
Quick note (for completeness), the inner query returns an XML, the value() method is invoked on that XML
😎
(inner query returning XML).value() <--the value method on the XML data type.
November 24, 2014 at 1:13 pm
gravitysucks (11/24/2014)
create proc proc1 (@param1 int)
as
begin try
declare @param2 int
begin transaction
exec proc2 @param2
commit transaction
end try
begin catch
if @@trancount > 0
rollback transaction
end catch
i haven't had an opportunity to do this before....
November 24, 2014 at 1:00 pm
Good catch with the node value Arthur, don't think it merits a dynamic sql though as one can easily encode the value with a simple FOR XML statement.
😎
/* Simple encoding...
November 24, 2014 at 12:38 pm
Viewing 15 posts - 6,526 through 6,540 (of 8,761 total)