Anchelin

You need to substitute the actual names of the columns in tablename (why do you have that enclosed in quotes in your script?) otherwise it will look for columns named...

Mike

No worries.  That kind of linking table is called a junction table, and it's the kind of database design aspect that would have taken me ages to think up on...

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...