Hi bharathi

Please would you post your solution? It would finish this thread nicely and also, possibly, provide useful learning material for others.

Cheers

ChrisM

Hi Joey

It's good practice to print the string you're going to execute. Try this, there are a couple of minor changes:

[font="Courier New"]DECLARE @LinkedNameServer VARCHAR(500)

DECLARE @Schema VARCHAR(100)

SET @Schema = 'Schema'

DECLARE @TableName...

Hi David

With six node levels and a remote possibility that it could increase, your best bet is almost certainly a recursive CTE as described in the following article:

http://www.sqlservercentral.com/articles/T-SQL/2926/

Is there a logical maximum?

Hi David, many thanks for posting this. The next question would be...how many levels deep can this hierarchy go? If it's fixed at say 2 or 3, then the solution...

Hi David, there are established methods for achieving this. Some sample data would help tremendously. Here's a start though I'm guessing somewhat, please can you correct the data to fit...

Hello

This is also untested but should be pretty close to what you're looking for - if it isn't, please post DDL of your table and some sample data.

[font="Courier New"]SELECT d1.RIV_RCN_ID,...

Nah that's the target 😛

Interesting point. I'd guess that most of us use a tally table with a million numbers in it. Having found that reducing the rowcount (or maximum number, in other words)...

Firstly, as mentioned earlier, a table alias ('tempTable') is only required if the...

Hi Garadin, use this:

http://extras.sqlservercentral.com/prettifier/prettifier.aspx

Cheers

ChrisM

Hi Mr Baseball

If I'm teaching you to sucks eggs then I humbly apologise now...best practice in this scenario is to use a "staging table" as the target for your import,...

Here's another way - I'm sure it won't be the last.

DROP table #test

create table #test (

[Date] int,

[Time] int)

INSERT INTO #test

SELECT 20081003,70004

UNION

SELECT 20080326,210053

UNION

SELECT 20081003,20003

UNION

SELECT 20081002,200002

SELECT CONVERT(DATETIME, STUFF(STUFF(CAST([Date] AS...

Yeah I see your point now. It's easy enough to create a short numbers table on the fly

SELECT CAST(CAST(d1.Number AS VARCHAR(2)) + CAST(d2.Number AS VARCHAR(2)) AS INT) AS number

FROM...

Had to try it, guys...

[font="Courier New"]DECLARE @StringIn VARCHAR(200), @StringOut VARCHAR(200)

SET @StringIn = 'The Quick Brown Fox Jumps Over The Lazy Dog.'

SET @StringOut = ''

SELECT @StringOut = @StringOut + CHAR(CASE WHEN...