Most often this error crops up when you are referencing a variable and you do not prefix it with the "@".  Cursors are "variables" whose naming convention does NOT call...

Lots of very helpful advice here which, unfortunately, answered the wrong question.

The question is how to duplicate complex functionality that is in a "legacy" application.

The "legacy" application is Excel's...

I fail to understand why a primary key is ever a "workaround"!

The assertion that Oracle is cheaper works for a "green field" enterprise where there is no pre-existing investment in the MS architecture at both the server and the user levels....

Agree re closing paren. Looks like something replaced it with a smiley face emoticon! Pretty dumb "feature" in a technically oriented forum

Billsalkin:

I certainly not excuse that atrocious, delicious pun! Ciddify, indeed!

That one goes into my collection.

More specifically, you need to make the field for the submitter id into a Dropdown List (ddl) instead of a textbox.  You bind the target table's (the one you are...

Try this:

SET

NOCOUNT ON

DROP

table Questions

go

CREATE

Table Questions

(

qnId

All of the above assumes that you have no related tables with foreign keys referencing one or more of the duplicates.

If everything in a row is duplicated in one or more...

Your requirement is not very clear.  Given what I can guess about it, looks like you want to use dynamic SQL and the EXEC command.

Here is an example:

SET

Excellent article, easy read. 

I am not a dot NET developer, but am trying mightily to come up to speed on it.  I have been involved in relational databases since...

I had a project with a similar requirement.  We used replication to reference the common database into each of the client databases.  Then FK constraints could be set up in...

This requirement seems to be a self-fulfilling prophecy.

(1) Users usually want a progress bar because the query in question has a history/experience of being long-running.

(2)  Original design may have used...

Perhaps this is obvious to most, but I noted Gino is a newbie and might not appreciate that @@error is very transient, in that its value does not persist beyond...

I haven't examined the SQL 2005 PIVOT operator.  However, the approach herein should work in 2000 and 2005.  Everything is in a single, rolled back transaction so as not to cause...