Mike

Yes, that may show a list of SigIDs for all certificates that have one (or more).  Use LEFT JOIN if you want to include certificates that don't have any signatures...

MR

Create a table called CertsSigs.  This will contain one row for every combination of certificate and signature.  If you need a list of all certificates and their signatures, you can...

Then I think you probably need to create one task for each sheet you want to export to.  I haven't tried it, but it shouldn't be too difficult to test.

John

If your sysadmin isn't there, then I think you're stuck.  Unless you can log in as someone with sysadmin rights, that is.

John

If you don't have ADMINISTER BULK OPERATIONS permission then you can't grant it to yourself.  You will need to ask somebody who is authorised to grant it (for example a...

Yes.  In the properties of your Transform Data task, you can specify the name of the sheet in the Destination tab.

John

Check out the REPLACE function in Books Online.  You can replace '"' (double quotes) with '' (an empty string).

John

If I'm guessing correctly, you're looking for rows where a row in #tab3 doesn't have a matching value of b1 in #tab2.  (I think... it's very confusing that you don't...

Jay

First of all, get rid of those quoted identifiers: they're not necessary in this instance and they make your query difficult to read.

If you obtain the list of applicants from...

John

I don't advise putting a clustered index on a varchar column, especially if it means inserts will be made in the middle of the index - this will cause page...

Papillon

Come on, you must be able to work out the answers to at least some of those!  Let us know what you think the answers might be, and we'll comment. ...

John

Depending on why you want to remove the records, another thing that might work for you is this.  Create a flag column in your table called IsActive, with a default...

Carl

If I'm understanding you correctly, this is what you do:

(1) Create a stored procedure in the master database called sp_MyWork (the sp_ prefix is important).

(2) Run the stored procedure against...

If you can "see" one server from the other, the easiest way to move a DTS job is to open it, go to Save As and choose the new server...

Charbel

I'm not sure what you mean by the first three characters of the key, since in your sample data, all Key values are three characters long.  If the following doesn't...