Bingo - this one works just as I expected it to....

Thanks for the reply Drew.

The data set I have given is artificial - so that we can attack the core quickly. Trust me, I have 'heavily' simplified the

structure of the...

Ouch .... I thought it was apparent.... but I should have been clearer about what I am expecting.

I am expecting just the combinations that are missing from the #foo table.

So...

Nice ... I like squeezing the last drop of juice from my machine too 🙂

Thanks Jeff...

I modified the code...

For those interested, it reads thus:

Select

batchID As BatchID

, Min(Case When paramName = 'outfolder' Then paramValue Else NULL End) As OutFileLocation

, Min(Case When paramName = 'outfile' Then...

I must be feeling the friday effect .... for those interested , here is the fix:

select batchID, [outfolder], [outfile]

from (Select batchID, paramName, paramValue From #foo) tmp

Pivot

(Max(paramvalue)

for paramName in (outfolder, outfile)

)...

You want to do this via script only?

I normally do this via DTS menu in SQL 2005....

Thanks GSquared ... This works as well..

Ok. I just found out that removing the unused columns removes the nulls too.

So I think I am back in business.

But why would those unused columns have any impact on...

Thanks Lynn, this works splendid...

I want to avoid the IN clause as I have heard it is not efficient.

The table above is a heavily simplified version of a table that has hundreds of thousands...

I think you should check out xp_cmdshell. You can then create your own exe to read the registery and call it from the shell.

I am at work so cannot spend too much time on this....

Something along the following lines should work:

declare @input varchar(30)

declare @output varchar(900)

set @input = 'ThisIsNotGood.ButWillCheckItOut'

select @output = case

When ascii(substring(@input,...

It should be.

I think you can use STUFF() function for that.

Use that at index of each character that is an uppercase.

PS:

The only reason I feel lazy to write the script...

Awesome.

Thanks a ton 🙂