OK, so your Treepath column contains a delimited list that you need to split into its individual components? You need a function to do that for you. If...

I think I answered the first problem in the 18th message in this thread.

As for calculating the size of the result set, build a table of all the possible data...

Problem? I inferred from your previous post that it was resolved. Please let us know what the outstanding issues are.

John

I'm glad you've made some progress. Your SET @par2 and SET @filter statements will fail if the respective temp tables contain more than one row, however.

John

This is where dynamic SQL starts to get ugly and is one of the reasons why you should try to avoid it. I think you would have to loop...

There's a stored procedure sp_delete_backuphistory that you can use to purge old backup records from the msdb database.

John

Resender (12/10/2010)

---

OK so the function I found (DelimitedSplit8K)

returns me the delimited varchar as a table where each record is the next value

turns into

ID ColumnName

1 MachineId

2 RegisterId

3 UtcTime

4 Value

I...

Resender (12/9/2010)

---

Problem with this is that I need to have MachineRegistration.INFORMATION_SCHEMA.COLUMNS

I could off course put that in a variable and execute the variable.

Then the problem would be to then calculate...

Wrong way round. You can restore a SQL Server 2000 database to SQL Server 2005, but as far as I know, you can't restore a SQL Server 2005 database...

It means you can't use the new features in SQL Server 2005 on any of those databases. This includes keywords such as ROW_NUMBER, and the dynamic management views.

John

Are you talking about splitting the string, or reassembling it...

Resender (12/9/2010)

---

OK,

I believe set-based query to split my columns was already in my stored procedure

SET @truncatedChar = REPLACE(@SelectedColumns,',','')

SET @occurenceChar = (LEN(@SelectedColumns) - LEN(@truncatedChar))

...

WHILE (@counter < @occurenceChar...

Shouldn't be any reason to do any looping. The splitting of the string can be done with...

Oh. Maybe it's been taken down for maintenance. If you do a Google search for it, you can look at the cached version.

John

Ah yes, so they are. Please have a read of this...

http://www.sommarskog.se/dynamic_sql.html

... and decide whether you're still happy with this way of coding. If you are, then what...