Pretty simple, if you can select, you can update.

Generic code sample

UPDATE

A

SET

A.foo = B.bar

FROM

TableA A

JOIN

...

Thanks Everyone

That worked really well.

Greatly appreciate it

Andrew SQLDBA

Luis

This is what I have as a float value in the table: 1.19056542300058E+15

And this is what I have after performing the CROSS APPLY: 1.19057e+015

I would like to see them both...

Luis

Must all non-text datatypes be converted to varchar()? Things like datetime datatypes.

Thanks

Andrew SQLDBA

Thank You Luis

That is perfect, and so much cleaner than the code I had.

Greatly appreciate it.

Andrew SQLDBA

Thanks Lowell

After posting, I went back to the BOL, and read it. It was like that one sentence was glaring out at me. 🙂

Thanks again

Andrew

Need a lot more information than you have provided.

Andrew SQLDBA

You should have a Program group named "Configuration Tools" in each of your program groups for SQL Server.

Andrew SQLDBA

Not possible. You cannot restore an earlier version of any database, to a more recent. Besides, SQL 2005 and above does not know how to deal with DTS. Those versions...

I find it much easier, and far less time consuming just to take the logic and write new SSIS packages. There, you always find better ways of writing the code,...

Ok, so what does the event log state?

Open the SQL logs via text editor and see if there is something in there.

Andrew SQLDBA

A couple things here.

Why are you storing user stored procedures in a system database? You should never, ever be using a system database for user work or storage.

The service account...

Yes, you can install as many different version as you wish. I have them setup that way. I used a named instance for each also. I did not use the...

What is the service account that the Agent is using? Is that account valid? After I check that, and verified that I can login to Windows with that account, I...

Thanks Luis, that is exactly. I was close, but just could not get it correct.

Have a nice weekend

Andrew SQLDBA