Forum Replies Created

Viewing 15 posts - 16 through 30 (of 42 total)

  • RE: How do you write this PL/SQL statment in Transact?

    I'm probably just missing the glaringly obvious but is this equivalent?

    UPDATE Table1

    Set field1 = field2

    go

    ILIT

    Steve Hendricks

    MCSD, MCDBA

    AFS Consulting Group

    shendricks@afsconsulting.com

    (949) 588-9800 x15

  • RE: Table/Column Naming Conventions (Opinions Wanted)

    quote:


    I always use singles, not plurals, for table names: tbl_employee, tbl_employee_history.


    The advice I received was...

  • RE: Generate Next Key from Stored Procedure

    I don't know if this is a by-product of submitting a simplified schema or not but the UniqueField column is defined as being NOT NULL but doesn't have a default...

  • RE: SQL Worm - Are we lazy

    My two cents...

    I just wanted to amplify (vent, rant, rave, etc.) on what has already been said about third party support restrictions.

    We work with a mid-market accounting package...

  • RE: Remote ODBC Setup

    It's not clear on what exactly you are trying to accomplish but you may want to look at creatingh a DMO based application.

    BOL has details on the COM (ActiveX) interface....

  • RE: Query vs SP

    In your stored procedure definition you have listed the parameters as being of type VARCHAR. Since you have not supplied the optional size (e.g., VARCHAR(10)), it is defaulting to...

  • RE: DBA Cert advice needed.

    I much prefer a book to a class. The Microsoft Training Guides are a good place to start but they seem to lack the depth necessary to pass the...

  • RE: Merge - Trigger Script

    And the answer is...

    There was a set of replication triggers defined from a previous attempt to configure replication. They should have been dropped when the other replication objects were...

  • RE: Owner of replication target tables

    From within the EM wizard, on the dialog where you define the articles, there is a button where you can define the defaults (Lower left hand side). One of...

  • RE: Merge Replication - Can't Remove

    I found out that there is a system sproc that can clean things up on either the publisher or the subscriber end of the configuration.

    sp_removedbreplication 'DBName'

    This resolved my immediate issue......

  • RE: St procedure without exception

    You might want to consider using the INFORMATION_SCHEMA to reference the database objects. These names are not subject to change.

    HTH

    Steve Hendricks

    MCSD, MCDBA

    AFS Consulting Group

    shendricks@afsconsulting.com

    (949) 588-9800 x15

  • RE: How do I amend this trigger ?

    MKumari,

    Your solution assumes that only one record has been inserted/updated.

    create trigger TR_InsertUpdate1 on dbo.tblAddress

    for insert, update

    as

    begin

    update dbo.tblAddress

    set education = 'True'

    from dbo.tblAddress a

    join inserted i on i.Primary...

  • RE: LEFT OUTER JOIN PROBLEM

    Does the DISTINCT keyword solve the problem?

    SELECT DISTINCT

    Customers.Cust_Name,

    CASE WHEN Accounts.Account_No IS NOT NULL

    THEN Accounts.Account_No

    ELSE 'NO ACCOUNT' END

    FROM Customers

    LEFT OUTER JOIN Accounts

    ON Customers.Cust_Name = Accounts.Cust_Name

    AND Customers.Location = Accounts.Location

    AND (Customers.Acc_Type...

  • RE: Left Join performance issue

    joepin,

    I'm coming late to the party so forgive me if I'm covering old material...

    It looks like you are blurring the line between the join and the where clauses. The...

  • RE: ascending/Descending other than Order By clause?

    A table is an UN-ordered set of data. Even with a clustered index, the data is NOT guaranteed to be returned in order. It often will come back...

Viewing 15 posts - 16 through 30 (of 42 total)