you probably have it open in Access to look at the data at thesame time you are trying to access it via code:

It is already opened exclusively by another...

I don't think you need a trigger for htis....you need a tracking table to determine whether an email should be, or has already been sent.

if the table you have to...

when you create a foreign key, you can add the extra commands ON UPDATE CASCADE ON DELETE CASCADE, and then changes to teh parent will automatically propigate to the foreign...

doh i should have thought of that...edited.

I took some spanish in school, but living in South Florida, I get to struggle with it a bit, just enough to try and...

ok, now as best as i can figure, you wanted to update one specific row, where QuestionID='1773', with the sum of all the Answer_Int for a group of specific questions.

i've...

I don't know your table structure...i just wanted to demonstrate that you can have an update that comes from a sub query as well as other values....use this as a...

quisiera saber como poder hacer que se guarde el log de mis dts en una tabla especifica , o como hago para que mis dts guarden el log de la...

the number one tool to export SQL queries and tables to disk would be BCP; you can decide what the delimiters would be, ie commas or tab delimited, or even...

The format of your current update from is a lot like what i've seen in Oracle and PLSQL;

SQL server supports a different format that, at least for me, seems more...

you guys missed his previous post...I;m thinking this is a shared hosting server, and not anything on his own LAN or that he has Admin access to at the OS...

the interview question was a test of your basic knowledge on how to query for data.

you failed.

If you can't answer it, it would show that you have no experience...

when the old SQL 7 was upgraded, non-system databases were left at compatibility 70.

since you clearly have a need to use functions, I'd change their compatibility to 80 and be...

to do that, you need a case statement for each possible value:

[font="Courier New"]

SELECT

  SUM(CASE WHEN idstatus = 1 THEN 1 ELSE 0 END) AS STATUS1,

  SUM(CASE WHEN idstatus = 2...

jb, was my guesstimate right? were all the databases on that server at compatibility 70, but master at 80 due to an upgrade?

you are all set on that server?

yep when using a varchar for LIKE statemnts, the spaces are significant. a varchar contaning spaces at the end maintains the spaces; it's when you look for equal to a...