Raj

OK.  It looks as if your database design here is not ideal.  There is no primary key constraint on the table.  Is there a column (or combination of columns) that...

Anchelin

Perhaps you ought to include a "USE DBName" statement at the beginning of @Query2.  If that doesn't work, please post the result of this query:

USE DBName

SELECT COLUMN_NAME

FROM INFORMATION_SCHEMA.COLUMNS

WHERE...

So you have several temp tables, all with the same structure, but each named according to a user in the database?  My advice would be to normalise your design so...

Raj

Please will you post the table DDL so that we can see what constraints you have on the data (primary keys and so on).

Thanks

John

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