Forum Replies Created

Viewing 15 posts - 1 through 15 (of 22 total)

  • RE: Cursor not declared Error

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

  • RE: T-SQL and The Excel Solver

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

  • RE: Issue: Insert duplicate records in table

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

  • RE: Challenge: check my cost figures; SQL Server 2x Oracle??

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

  • RE: Count if condition

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

  • RE: Origin of 1st, 2nd, 3rd normal forms specifications....

    Billsalkin:

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

    That one goes into my collection.

  • RE: Do I need to count the listbox items and refer to the chosen one???!!!

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

  • RE: dynamically write column names

    Try this:

    SET

    NOCOUNT ON

    DROP

    table Questions

    go

    CREATE

    Table Questions

    (

    qnId

  • RE: Distinct

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

  • RE: dynamically write column names

    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

  • RE: The Enterprise Library for .NET Framework 2.0

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

  • RE: Foriegn Key constraint across DB

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

  • RE: How to get the Cursor Location in a while loop ?

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

  • RE: saving @@error

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

  • RE: How to build a matrix from 3 tables?

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

Viewing 15 posts - 1 through 15 (of 22 total)