You need to declare the namespaces and reference them in your SELECT.

Also pay attention to case sensitivity in XML.

EXEC sp_xml_preparedocument @docno OUTPUT, @doc,'<camt:Document xmlns:camt="urn:iso:std:iso:20022:tech:xsd:camt.053.001.02"/>'

select * from openxml(@docno,'/camt:Document/camt:BkToCstmrStmt/camt:Stmt',2) with ([camt:Id] varchar(100))...

Sean Lange (5/28/2013)

---

dwilliscp (5/28/2013)

---

If you have a record, where there are 12 columns, one for each of the last 12 months, and you want to use STDEVP, how would you...

Sorry, that's the problem with not having sample data to test with...

you probable want something more like this:

select point_range,count(*)

from (

select

jp.userid

, case...

I'll take the THANK YOU as enough... Beer is for lizards...:hehe:

...I'm thinking something like this:

declare @x xml = (select *

from sys.tables as tables

for xml auto,elements)

select @x,(select count(*) from @x.nodes('tables') [count](nd) for xml auto,elements,type)

from (values(1)) as [root](b)

for xml auto,elements

Which produces

<root>

...

...

I'm missing the point I am sure, so can you explain why you can't just count the nodes with a select?

Do you have any SSMS Addins?

facemann (5/24/2013)

---

My SSMS 2008 R2 has an irksome quirk. Every 10-15 minutes the query screen shifts down. I will be typing a line of code positioned in the...

You are grouping by userid, so of course you get one row per userid....

Try this:

select

x.point_range

, count(jp.userid) as countofusers

from StatusLevelPnt jp

inner join user ju on...

Yes, you can pass a NULL into a stored proc.

Try this:

create proc testNullParam @p1 varchar(10),@p2 varchar(10)=null,@p3 varchar(10)

as

select @p1 as p1, @p2 as p2, @p3 as p3

go

exec testNullParam @p1='test',@p2=null,@p3='test'

You get this:

+--------------------+

¦[highlight="#808080"]...

Tobar (5/23/2013)The one draw back with this method, I just noticed :-D, is that you must specify all the columns in the table. If you are only updating 5 columns...

GilaMonster (5/23/2013)

---

You...

Kingston Dhasian (5/23/2013)

---

You will have to drop the existing index and then create the index with the INCLUDED columns

The link below can help you with the syntax to create the...

the syntax

EXEC @myvariable = dbo.myproc;

will take the RETURN value from the stored proc and put it into @myvariable, which IIRC must be of Integer data type.

It looks like you are...

Thanks for a well presented, well thought out article, which has expanded my knowledge.