Mando_eg (2/20/2010)

---

Helo,

I have 2 questions about SP:

1- How can I make the SP's parameter receive an array value to work on each value in it ?

2- How can I call...

Paul White (2/20/2010)

---

...

I often hear the objection about not wanting to use CLR just for one thing 🙁

The trouble is, until you add one, the next one will always be...

That's probably true (I trust...

If you don't use CLR on a regular base or you'd like to see an alternative and still extremely fast way to split a string please have a look at...

Here's an example with a subset of your data:

DECLARE @xml XML

SET @xml='

<inserted

u_user_id="{2f0a2500-1c1d-456d-83f2-ca48dbed642d}"

u_user_type="1">

<u_x005F_xmlextension>

<VanillaUser xmlns="http://snowvalley.com/VanillaUser.xsd" />

</u_x005F_xmlextension>

</inserted>'

SELECT

c.value('@u_user_id[1]', 'varchar(50)') AS u_user_id,

c.value('@u_user_type[1]', 'varchar(50)') AS u_user_type,

c.query('u_x005F_xmlextension') AS u_x005F_xmlextension

FROM @xml.nodes('inserted') T(c)

For details please search this...

A CTE (at least as it is used in this case) is nothing but a different kind of writing subqueries.

Note: I used the same alias for the subqueries as I...

Please note that posters on this forum usually will use English laguage for posting, even if it's second or third language.

You'll limit the number of people able to help you...

... and based on your interesting link I used "Grid...

I thought you were all set based on Jeffs recommendation so I didn't continue to follow that thread... Sorry about that.

Regarding a requirement from one of your previous posts:

dataczar (2/16/2010)

---

...

Claims...

I would use a split string function (for a sample please have a look at the Tally table link referenced in my signature) to get the data in a relational...

Just want to confirm: Are you using SQL Server 2008? (since posted in the 2K8 forum)

If so: did you look into geospatial data type?

You might not like...

You could add "ORDER BY MIN(Serial)" to your SELECT clause.

Would query sys.sysusers (2K5+) give you the answer you're looking for?

Alvin Ramard (2/16/2010)

---

Yes.

Raise your right foot. .......