October 11, 2007 at 6:18 am
I have an xml like following
I want to write an sql query which returns only if the IsGroup value is 1
( )
please help me.
October 11, 2007 at 6:19 am
Please post your XML. It is not visible.
Prasad Bhogadi
www.inforaise.com
October 11, 2007 at 6:23 am
Place your XML within "[cod e]" and "[/cod e]" tags and remove the space from the word code.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgOctober 11, 2007 at 6:47 am
[RPC]
[RP][N]DataStyle[/N][V]TimeSeries[/V][/RP]
[RP][N]Application[/N][V]61[/V][/RP]
[RP][N]Site[/N][V]1[/V][/RP]
[RP][N]Network[/N][V]1[/V][/RP]
[RP][N]IsGroup[/N][V]0[/V][/RP]
[/RPC]
[RPC]
[RP][N]DataStyle[/N][V]TimeSeries[/V][/RP]
[RP][N]Application[/N][V]61[/V][/RP]
[RP][N]Site[/N][V]10[/V][/RP]
[RP][N]Network[/N][V]10[/V][/RP]
[RP][N]IsGroup[/N][V]1[/V][/RP]
[/RPC]
[RPC]
[RP][N]DataStyle[/N][V]Series[/V][/RP]
[RP][N]Application[/N][V]68[/V][/RP]
[RP][N]Site[/N][V]10[/V][/RP]
[RP][N]Network[/N][V]10[/V][/RP]
[RP][N]IsGroup[/N][V]1[/V][/RP]
[/RPC]
[RPC]
[RP][N]DataStyle[/N][V]TimeSeries[/V][/RP]
[RP][N]Application[/N][V]32[/V][/RP]
[RP][N]Site[/N][V]1[/V][/RP]
[RP][N]Network[/N][V]1[/V][/RP]
[RP][N]IsGroup[/N][V]0[/V][/RP]
[/RPC]
I want to write an sql query which returns only if the IsGroup value is 1
([N]IsGroup[/N][V]0[/V])
please help me.
October 11, 2007 at 6:55 am
Hmmmm. I guess you can't post XML here...
STEVE :exclamation: !!!!!
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgOctober 11, 2007 at 6:55 am
Still not there.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply