At a first glance it looks like it's not required to do it row by row...

Beside the sample data I already asked for please provide the beginning of the procedure...

How about some (fake) sample dta to play with?

You don't have to use dynamic SQL. However, if there are many nodes under col1Data you should compare the performance of the following solution to the dynamic SQL version... Thinking...

One of my preferred sites: http://rusanu.com/articles/

Actually, this won't give the expected result... The MAX() function is applied to each field separately. See the following...

Aspet Golestanian Namagerdi (4/13/2010)

---

I have created some Reports which are being sent in PDF format,through email to client.How can I configure these reports,so the clients will not be able to...

gregory.anderson (4/14/2010)

---

Can you give me a quick example of a set-based solution (I'll google at the same time) to see how that would be done, and if it will work...

Identical solutions, posted at the very same time. Must be the best solution then... 😀

Side note: '' = 44sec. That's the closest I've seen so far for posting identical solutions...

Is it possible in...

Something like this?

DECLARE @tbl TABLE (ID INT, SurveyDate DATETIME, FY INT )

INSERT INTO @tbl

SELECT 100 ,'8/25/2009', 2009 UNION ALL

SELECT 200 ,'8/26/2009', 2009 UNION ALL

SELECT 300 ,'8/29/2009', 2009 UNION ALL

SELECT...

There are several ways to do it. One would be to join to a calendar table that would include a column where weekdays can be identified.

An example of a calendar...

Please be a little more specific what you mean by "database performance is slow". AFAIK, a database itself cannot be slow: if there is no activity at all (neither insert...

I'm not sure if that's exactly what you're looking for... But at least it should give you something to start with.

The tricky part to get different node names is to...

CirquedeSQLeil (4/12/2010)

---

Paul White NZ (4/10/2010)

---

I would like to express my sincere thanks to the following people, for their help in producing this article:

Amanda Lawrence

Jeff Moden MVP

Chris Morris

Lutz Müller

Jason Brimhall[/url]

Thank you...

SELECT cols

FROM YourTable

where YourColumn like '%[0-9]%'

will return only rows with numbers.

SELECT cols

FROM YourTable

where YourColumn like '%[^0-9]%'

will return only rows at least one...