Well, my thinking was that you could query the field to see if the highest date in any of the tables is higher than the last time you did a...

When I interviewed for the job I have now (Database Administrator) back in Jan. 2000, I didn't have my SQL certification yet (I do now). The CTO did comment that...

You can't. That would create a circular preference. Step 1 wouldn't be able to run unless step 6 failed, but step 6 won't run unless steps 1 through 5 are...

I agree. I think triggers is the way to go. I don't see why it would create a lot of overhead if you use the triggers wisely. In my important...

I didn't read the article, so I'm not sure that what you mean by parameterized list is what I think of when I hear parameterized list.

A parameterized list to me means...

In this particular instance, that is the way that I would do it, but I was answering his question about subqueries.

I've found that when someone posts a very simple bit...

You can use VBScript or JScript.

None of our stuff was as complicated as yours. It was mostly simple string manipulation.

For something that simple, I would say no.

If you re-use the query several times within the same sp, I would set it equal to a variable and just re-use the variable.

If...

When I started at my current company in 2000, one of the developers here liked to do that. We import a lot of data from other people's databases and it...

What version of Access?

Access 2000 & newer (maybe older too, not sure) has an upsizing wizard that will automatically convert your Access database into either an existing or new SQL...

There are a couple of ways you can do it.

1. Use a DTS package to export the data to a text file. To get the report output correct, you may...

Make sure that you have also unchecked the "enable identity insert" checkbox or it will try to insert Null into the identity field that you are ignoring.

Use your workflow precedents to tell the package what to do if the step fails and/or suceeds.

If you have multiple branches and want to make sure that the DTS package...

No, your cursor name can not be variable.

If you are going to declare a cursor with the same name, you have to first deallocate it.

At the end of the cursor...

I process a lot of data that belongs to other companies. Much of this data has to first be acquired from various ftp sites.

So, I want to ftp in information...