way to go on posting the table and data! it made it really easy to try and help!

here's two examples; in one i figured you jsut wanted the ID, and...

the typical "it depends";

I'd take into consideration whether there is a possibility that the blobs would be one-to-many for the main record. even if "today", you are only capturing...

you'll need to change your encrypted column to a varbinary. I believe the rule is if you are doing a 19 char field, the size for the varbinary is twice...

i contributed that script a while ago, and clearly it's only for SQL 2000;

here's someone elses script that I saved in my snippets that does INCLUDE columns;it does PRINT statements...

if they are doing the setup, figure out which tables you will be using, and get them to add synonyms for those tables as well...it really makes your sqls cleaner:

IF...

there's a thread on the new updated codeing somewhere, but i happened to keep the list handy in my snippets:

note that there's a space between the bracket and "code" so...

here's the syntax and example of adding a linked server for an access database, the login for it, viewing the list of tables, selecting from one, and finally updating one...

the table sysservers has all the linked servers that have been added;

select * from sysservers

with that info, you could do an

IF NOT EXISTS(SELECT NAME FROM SYSSERVERS WHERE SRVNAME='LINKEDSERVERNAME')

BEGIN

--..code...

OK I'll ask the obvious:

if SMO is available, why would you create a separate instance, eating up resources, instead of just adding a database to the existing installation you already...

I believe it has to do with how the linked server was set up...the default is "no security context", which is not what you want.

go to your linked server properties;...

in this specific case, this error:

Exception message: Column 'TFTAgentName' does not belong to table .

seems to be pretty straight forward;

I would guess that a SQL statement that is loading specific...

nice solution ashokdasari

, i didn't realize the OP might still want the data in Hours and Minutes.

the trick is you've got to take the minutes, i.e. "25", turn them into a decimal and divide by 60 so you get the part of an hour

create table #Example(TimeTaken...

Thanks Gail; This query is a rollup of a bunch of financial data based on it's attributes, so there's no WHERE statement in it....just a bunch of GROUP BY stuff...

for me, the biggest advantage for switching to compatibility 90 is the row_number() function; I've solved a couple of important SQL's with that function easier than if I had to...