Got it!
Select @x.value('(//connectionsetti ngs/add[@key="IgnoreFai lure"])[1]/@value', 'varchar(MAX)')
~Gina_M~
GinaMarano
Last Activity: Dec 16 '09, 08:35 PM
Joined: Nov 5 '09
Location:
-
A simple way might be to get the parameters names that are used to login then append the login info to the URL. For example
&login=myus ername&pass word=mypassword
There ways to do it with credentials but I would need more info.Leave a comment:
-
How to query untyped xml data
I have a varchar/text field that contains untyped xml. I don't want to use schema. How would one query this:
...Code:<configuration> <connectionsettings> <add key="appKey" value="355" /> <add key="SessionURL" value="http://xxxxxx" /> <add key="UpdateOrderURL" value="http://yyyyyyy" /> <add key="IgnoreFailure"Last edited by Niheel; Sep 29 '10, 09:55 PM. -
Thanks much for the responses.
I will give the pivot a try. The union example probably works as well but I was looking for something more generic.
Also, maybe using FOR XML might give me something easily readable.
SELECT top 1 *
FROM orders
FOR XML RAW('orders'), ELEMENTS
works pretty good. I was just trying to get something in a readable format to quickly send in an email...Leave a comment:
-
trick for displaying result? SQL Server 2005
I run many queries per day. The results are usually 1 row with many, many columns. Is there a trick/free tool to display this row as 1 column instead?
example:
col 1 col 2 col 3 col 4 ....
data1 data2 data2 data4....
to
col1: data1
col2: data2
col3: data3
col4: data4
for adhock queries.
Thanks
~Gina_M~
No activity results to display
Leave a comment: