pommguest99 (4/7/2008)

---

Yes, comparing data b/w Filefit(table1) and from a temp table which holds join data & that would be myTempTable(Vraiid & FlCA)

Tables - Filefit, myTemptable(which happens to be a join...

That means that there is at least one row in the spreadsheet where ID_PK is blank. If you can't see on like that, likely it's at the bottom of...

Try making the appostrophe a double-apostrophe.

Also, test the thing for SQL injection, just for your own sanity/safety.

Try using "1=1; select * from sys.all_objects --" as the string you send it....

Take a look at sys.foreign_keys. It's a system view, and it probably has what you're looking for.

Not sure what you mean by comparing two tables for similarities and differences. Do you mean compare the data in two tables, or the column names, or something else?

Depending on how you use them, temp tables can cause performance problems.

For example, if you create a temp table in a proc after you have already run DML commands in...

It looks like there's an extra single-quote at:

''+@id

I copy-and-pasted your code into Management Studio, removed that single-quote and it didn't give a syntax error when I ran it.

Are you in a position where you can add a "timestamp" column to the table you want to track changes on? (Look up Timestamp in Books Online. It...

Are you saying that the column name...

Open Books Online, copy and paste the address into the URL field. Should get you there.

Is this something you'll need to do repeatedly, or is it a one-time situation?

If it's a one-time situation, using the Import Wizard from Management Studio should work.

If it's a repeatable...

Without specifics on the table, I can't give you a complete solution, but I can recommend that you look into using a Numbers table instead of brute force.

(In case you...

Ah. That should go in the body of the proc. After "as". Not as part of the input/output parameters.

Yeah, Lynn's solution is better. One less table lookup per column-variable pair.

If I'm understanding you correctly, you'll need to use dynamic SQL for that.

You build the query as a variable, then execute it with sp_executeSQL.

For example:

declare @sql varchar(max), @Col varchar(128), @Table...