Yeah! nothing like vacations

Aha! I think I know who that is

Well if you could move your "important" DB to one server then the "per server" bit will not matter  

Yeah and not only that Have you check his(their) writting style hasn't(haven't) changed much either

It really does not means that much to me ... but Hey Thanks anyways

And Dettaching (in my opinion) is something different from set it offline like:

Alter database dbname SET OFFLINE WITH ROLLBACK IMMEDIATE, NO_WAIT

That, is what I call to set it offline...

Well, I would guess the Application is missing some info or the session variables are lost! Definitely not a SQL problem

Cheers!

For this thing I have used Mathlab. I am pretty sure that you will get a decent thorugh put with minimal effort with it but be ready to shell out...

ISO 8601 is referred to Datetime "representation"  in the query language. When the data (datetime) is saved it goes in to two 4-byte integers!

FROM BOL:

Values with the datetime data type are...

You are Welcome

for something that dynamic I'll create the query client side. Ah and change the "union" for "union all"

Aren't you supposed to be on vacation?

Happy to Help

I just hope the table is small enough

1. Looks ok to me

2.

select

   Fund_Number

   , Coalesce( min( case when Role_Description = 'AP_Cash_Acct' then Account_Number end),'') as Role1_Acct

   , Coalesce( min( case when Role_Description = 'Due_Other_Funds_Acct' then...