Hi Lutz,

This is what I get

(2 row(s) affected)

Msg 245, Level 16, State 1, Line 9

Conversion failed when...

Sure Lutz,

I had to comment the order by as it throwed an error like this

(2 row(s) affected)

Msg...

Please assume that nothing can be done as these columns are loaded from some SSIS packages. Thanks.

hi Lutz,

I got the result like this. The List is not sorted .....i have attached the screen shot as well.

idnew_list

147,48,49,92,93,94,95,96,108,107, 47,48,49,92,93,94,95,96,108,107, 47,48,49,92,93,94,95,96,108,107, 47,48,49,92,93,94,95,96,108,107, 47,48,49,92,93,94,95,96,108,107,...

Sure... Here you go ....

;with tmp(Source_ID, DependsOn, DependingSources) as

( select CAST(Source_ID AS INT),

CAST(LEFT(DependingSources, CHARINDEX(',',DependingSources+',')-1) AS...

Hello Friends,

My task is almost over. But I am struck @ final step. I was able to get the desired output with a Recursive CTE function.

But the challenge...

Thanks Gila and SSC. I will keep you posted.

That is true Gila. How can I achieve find these combinations that there is a loop in place. Thanks.

Yes, this is a kind of challenge in T-SQL coding assigned to me.

Thanks for all your replies but I was looking for the code that would find out all the rows that have data other than characters (this includes numbers and special...

You're Welcome Jim !

Praveen,

Post the answer please so we can also know it ...

Jim-720070 (6/28/2011)

---

Hi shyamhr,

So the Dev and Prod servers have different versions of Excel installed?

Also this smells of permissions issues between the user that created the package on Dev and the...

Can you please be more specific on the logic that you want to implement with this case statement ...

taybre (6/21/2011)

---

In you SSIS package, execute a t-sql task before your data push to excel

OR

execute the code the last SP...