Viewing 15 posts - 121 through 135 (of 140 total)
In the SP, are you constructing the SQL dynamically and then executing it? Also, are you constructing the procedure call from your asp page dynamically as well? as if you...
May 24, 2012 at 1:45 am
Ok, I was thinking more along the lines of a generic relational table structure rather than a specific structure. If you look at the output of the XMLTable function then...
May 3, 2012 at 8:10 am
Shredding millions of blobs of xml to a flat table structure will take a lot of resources which ever way you do it and if this is something that you...
May 2, 2012 at 3:57 am
If you would like a generic function to flatten the Xml down to a table regardless of the schema of the Xml, then I would look at using something this...
May 2, 2012 at 2:19 am
wdjong (4/4/2012)
I'm sorry if this has been addressed already. I haven't been able to find it.
Please consider the following XML.
I need help to get to the next level.
Each Purchase Order...
April 5, 2012 at 1:47 am
I'm glad it helps and if you get stuck again then please post back on this thread and i'll be happy (or indeed others i'm sure) to try and help...
February 23, 2012 at 9:54 am
dilipd006 (2/23/2012)
thank you very much...exactly this one i wanted.One more question
Isn't cross apply is slow...travesing so many tags
CROSS APPLY itself works well in my opinion and I've seen the...
February 23, 2012 at 6:06 am
I think i understand your query, and have come up with the following:
INSERT INTO [dbo].[#Table1]
(
ID1,
ID2,
ID3
)
SELECT
@ID1,
w.y.value('(.)[1]','tinyint'),
V.y.value('(ProductTypeID)[1]','tinyint') AS ID3
FROM @x.nodes('/Products/ProductType')...
February 23, 2012 at 5:09 am
You could use a CTE to achieve something similar to what you have posted. Here is something I created a few moments ago which uses two CTE's to generate...
February 23, 2012 at 1:52 am
iamidress (2/21/2012)
Use Case statmentSELECT EmpName As EName
case when BasicPay>5000 then 'OVER else 'lOW' end AS Result
FROM EmpSalary
Its also not working
Incorrect syntax near the keyword 'case'.
Just a comma and an...
February 22, 2012 at 1:32 am
Really good question! thanks...
February 13, 2012 at 7:03 am
Hugo Kornelis (2/10/2012)
February 10, 2012 at 5:14 am
I've personally never used this technique so not sure how good they are or how they perform, but if you have schemas for the XML documents then an XML view...
January 12, 2012 at 7:41 am
As Lutz has mentioned, if you are going down the service broker road, I believe you'll need to look at setting up routes to facilitate messaging between servers:
Check this as...
January 5, 2012 at 2:40 pm
Sounds like the template on your machine has been modified.
This link should help:
January 5, 2012 at 2:23 pm
Viewing 15 posts - 121 through 135 (of 140 total)