Here is an excellent article that tells you exactly how to do this:

http://vyaskn.tripod.com/hierarchies_in_sql_server_databases.htm

However, please note that this solution uses a loop. In SQL Server loops are only useful for small...

One small piece of advice. while loops, cursors and UDFs may perform poorly for large record counts because the query optimizer cannot treat them with set operations. If performance is a...

Hi Jon,

You just need to parse the string in your stored procedure. For example:

--Create a procedure and run it:

CREATE PROCEDURE proc_test

 @p1 varchar(60)

AS

declare @var1 varchar(30),...

"Handling the metadata was the really big challenge for our DW. 250 trials, each with 30-40 distinct tables, adding a new trial a week, I had to develop a dynamic...

Yes, this indeed is an excellent, detailed overview look at data warehousing.

However, as others have suggested here, the data warehousing concept would not exist except for its value to...

Very good, well orgainzed article with everything needed for simple XML queries.

But it seems to me that responsible developers should avoid the temptation to use new technologies simply because of their...

I just finished a year and a half stint with a large mortgage company and I have to tell you that the communication level there was the worst I have...

I just finished a year and a half stint with a large mortgage company and I have to tell you that the communication level there was the worst I have...

Though VB and VBA don't handle nulls, if you are using Access VBA the solution is pretty simple. Just prepend a 0 to the NULL and then check for 0...

I'm not sure I understand the context of your connection (ASP, ASP/Net, etc.), but here is a MS KB article that may help:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;254517