Nicely done, Steve... Because of the nature of the CHAR datatype and the fact that the orginal table uses it instead of VARCHAR, you can really shorten the code...

steveb (5/28/2008)

an Identity column is required for replication, this would...

No UDF required... certainly, no CLR required... 😉

DECLARE @Varbinary VARBINARY(8000)

SET @Varbinary = 0x5468697320697320612074657374

SELECT @Varbinary

SELECT CAST(@VarBinary AS VARCHAR(8000))

The rest of the code should be pretty simple to figure out... create a table and use the Select I posted as part of an INSERT/SELECT

Yep, I agree... but newbies also have a responsibility... they need to leave their frustration and bad attitude at home. Walking into a forum with words like "I'm fed...

I've been guilty of that myself. Good reminder, John. 🙂

Doesn't matter... I have some fellow Americans that I can't understand sometimes... I do just like I would do with anyone else... I say "I heard you, but I couldn't...

Not sure why the dilema... error message says what's wrong. You've either not installed it when you installed SMS or it's simply not available on the machine that you're...

Heh... some of us consultants ain't so bad... 😀

... but I do understand what you mean.

Sarcasm forgiven... I know you just can't help it 😉

I absolutely agree that it will be mostly as static table and it will likely never be needed. But...

What kinds of functions?

... and how much the company wants to "keep". No one is indispensible.

Heh... no, the approach is not wrong... it's exactly what I suggested earlier. 😉

CrazyMan (5/28/2008)

I dont have a execution plan , but the table index structure is as below

IX_OQa_Binonclustered, stats no recompute located on PRIMARYBi

IX_OQa_Blo_Binonclustered, stats no recompute...

1030 columns... that's a bit wide. I'm thinking that I'd divide the columns into logical groups and do a little horizontal partitioning with some decent indexing. Might even...