I must say I'm quite disappointed I could not solve this problem in a simple way.

Maybe It's something beyond my skills.

Anyway this is the best I could put together:

IF OBJECT_ID('Tempdb..#TmpTbl')...

Thanks Gail.

It's hard to understand that kind of things without living in English-speaking countries...

Alvin Ramard (7/12/2010)

---

Another thing that made me wonder about the OP was the way he/she communicates. Start a sentence with "like I went to the view i created" and...

I think yesterday it was Emperor Paulpatine's birthday.

Happy birthday, Paul!

Don't forget to create the Tally table from the article code if you're using the split function!

Good luck with your query!

I'm not sure I understand all your requirements.

Why ID = 101 has 3 combinations? There are 4 fruits there...

Anyway this is what I could come up with. It could be...

Alvin Ramard (7/9/2010)

---

Did you mean a Christmas song? I could probably write one,...

If your column is varchar try this:

DECLARE @test-2 TABLE (

DataSize varchar(10)

)

INSERT INTO @test-2 VALUES (1025)

INSERT INTO @test-2 VALUES (2568)

INSERT INTO @test-2 VALUES (12)

SELECT

'DataSize' =

...

If your column is of type int you can try this:

DECLARE @test-2 TABLE (

DataSize int

)

INSERT INTO @test-2 VALUES (1025)

INSERT INTO @test-2 VALUES (2568)

INSERT INTO @test-2 VALUES (12)

SELECT

'DataSize' =

...

Take a look at the article linked in my signature and find out what information is needed to get a quick answer on the forums.

Can you please post table definition...

Try this:

'DataSize' =

CASE WHEN CAST(DataSize AS int) >= 1024

...

FYI, I ended up using CONTEXT_INFO to store the name of last procedure called.

Thanks for the tip

Thanks Gail. It's not exactly what I was looking for, but you gave me a great idea!

For logging purposes every stored procedure in my db starts with a line like...

It's a connectivity issue then.

Check you network and firewall settings.

Can you connect from the DTS host to the SQL2008 server using SSMS or OSQL?