select col1, count(CASE col2=1 THEN 1 ELSE NULL END)/count(col2) as rate, count(A) as total

from Test

group by col1,col2

Just to begin:

SUBSTRING( P.CUST_BANK_ID , 1 , 3) = CM.CITY_CODE

causes full table scan. Follow normalization rules and don't store rubbish in tables.

AND CUST_BANK_ID IS NOT NULL AND RTRIM(CUST_BANK_ID) !=...

Did you try BOL?

No, I mean tables, not only table variables.

Joe, just in case you did not hear about it,

the name for array in SQL is "table".

You don't need to create arrays, they are already there. Just use...

What's a problem?

Drop related FK's first.

GROUP BY ...., WRnotes

Create new table and set up trigger to transfer inserted/data from old table to new one. Do select from new table.

If you store rubbish, you'll get rubbish back. No other...

Why?

One table with list of servers, databases, SP names and probably list of parameters will do it all.

Cursor through this table, build the query from names stored there and EXEC...

EXEC RemoteServer.Database.dbo.StoredProcedure @Parameter1, @parameter2

You must catch an error in the very next statement after attemting insert.

What stops you from answering your own question?

Why not just try?

Believe me, there is no bomb inside, it will not blow if you cut the wrong wire.

case when MIN(Type) = MAX(Type) then MIN(Type) else Min(type) + '/' + MAX(Type) end

Create scalar UDF taking varchar value as an  argument and returning integer value.

Then update your table once using this function.

Don't be afraid to use loop inside of this UDF. Even...

declare @m money

set @m =100

select replace(STR(@m*100), space(1), '0')