Viewing 15 posts - 5,806 through 5,820 (of 8,416 total)
This works too:
SELECT n1.value('.', 'VARCHAR(30)'),
n2.value('.', 'INTEGER'),
n3.value('.', 'BIT')
FROM @XML.nodes('./xfadata/changeDebitCard') Nodes (node)
CROSS
APPLY...
February 27, 2010 at 7:14 am
lmu92 (2/26/2010)
Would you mind providing a test scenario so we have sometihng to play with? (table def, some sample data and your current query)
I'll second that. I'm happy to...
February 27, 2010 at 6:59 am
Divya Agrawal (2/26/2010)
Is it possible to do this without using dynamic query?
It is, but it is difficult to get it right, and more importantly, to get it to stay that...
February 27, 2010 at 6:57 am
Good, I am genuinely pleased you took it all the right way. Thanks Lutz!
February 27, 2010 at 6:52 am
Jeff Moden (2/26/2010)
Heh... I've never actually met or heard of anyone who has actually done that.
Hello! Pleased to meet you.
Actually, I worked at a place which started at one...
February 27, 2010 at 6:49 am
GilaMonster (2/26/2010)
It's common, but it doesn't have to be int. As far as I know, any numeric data type will work
You can use decimal, int, numeric, smallint, bigint, or tinyint...
February 27, 2010 at 6:47 am
rajesh-210109 (2/24/2010)
If i change my column type from nvarchar(512) to nvarchar(max), will it degrade the performance?
It might do. While the physical storage won't change much (the Storage Engine pretty...
February 27, 2010 at 6:43 am
GilaMonster (2/26/2010)
Seriously, there is no good way of getting an ID value from the database, then later putting the rest of the row in.
There is, and it's called a Sequence...
February 27, 2010 at 6:34 am
Is the ID field on the Keyworld table a sequence number? Is it guaranteed to be contiguous? If so, simple determine the lowest (MIN) and highest (MAX) current...
February 27, 2010 at 6:28 am
Those TOP expressions really require an ORDER BY to make sense.
The width of your table is a problem, consider moving the LOB data off row.
As Jeff says, the thing to...
February 27, 2010 at 6:17 am
Two small observations:
1. You're passing a unique identifier to the procedure that isn't used
2. The clustered index you have defined is likely causing many page splits
Paul
February 27, 2010 at 6:10 am
Chris,
Turns out all that is needed to get rid of the index spool is to define the clustered index as UNIQUE. Given that information, a better plan is produced...
February 27, 2010 at 5:45 am
shawndidy (2/25/2010)
Tanks alot for going to great length and writing this PL/SQL script. I'm still mastering Pl?QL.
This was the statement that led me to believe you didn't know 😉
I have...
February 27, 2010 at 5:26 am
lmu92 (2/27/2010)
Didn't have to deal with those "special characters" in my concatenation scenarios (yet), so I wasn't aware of the side effects. Thanks for clarification. Learned...
February 27, 2010 at 5:23 am
Dave Ballantyne (2/27/2010)
February 27, 2010 at 5:21 am
Viewing 15 posts - 5,806 through 5,820 (of 8,416 total)