Forum Replies Created

Viewing 15 posts - 61 through 75 (of 90 total)

  • RE: Function that returns table - user specific

    Thanks - yes please - if could point me in the right direction.

    July 23, 2007 at 5:03 am

    #721485

  • RE: SELECT *

    Thanks both of you.

    Jeremy - yes I know, I have a procedure which goes thru each subsequent view (very clumsily) and use sp_RefreshView

     

    but then if I wasn't using SELECT *...

    June 29, 2007 at 3:00 am

    #716100

  • RE: Update table

    Yes thats perfect! Its annoying the query builder didn't get me to there.

     

     

    THanks

    June 12, 2007 at 5:44 am

    #712226

  • RE: Trigger

    Excellent replies . Thankyou

    June 6, 2007 at 7:44 am

    #711113

  • RE: Trigger

    OK Thanks - I think I have the update part OK.

     

    But the insert bit -

     

    Another consideration is newly inserted records.  If you want to act on those records then the...

    June 6, 2007 at 7:15 am

    #711099

  • RE: Trigger

    Cheers James very helpful - just one think what is PK?

    i.pk = cn.pk?

     

    Thats the primary key for the record? and that join only brings out those in i and joins...

    June 6, 2007 at 2:24 am

    #711039

  • RE: Generate script for data

    Thanks here too!!

    April 25, 2007 at 7:28 am

    #702372

  • RE: Generate script for data

    Thanks Mr Junkie - thats perfect. Thanks Adrian fro helping clarify the problem.

    April 25, 2007 at 7:04 am

    #702359

  • RE: Generate script for data

    Almost -

    I want a script to generate the table as I have it here - data too.

     

    That script will then be used on the other dbs in other locations. (Once...

    April 25, 2007 at 6:19 am

    #702341

  • RE: Generate script for data

    Thanks for the answer -

     

    What I am trying to do is basically populate a lookup table data on multiple dbs in differant locations. (With data I have in a...

    April 25, 2007 at 5:26 am

    #702334

  • RE: Syntax update derived tables

    Thanks - that worked - so I just need to move my criteria outside of the derived table.
     
    Can I not get differant results by moving the criteria (I mean generally...

    April 12, 2007 at 9:42 am

    #700138

  • RE: Trigger update on the record added or updated.

    Its OK - The list of records inserted or updated is in the inserted table. So FRom here I can do the rest.
     
     
    Thanks

    April 4, 2007 at 7:01 am

    #698522

  • RE: Trigger update on the record added or updated.

    Basically I need the ID of the record(s) that was just inserted or updated (Trigger is for both).
     
    Is SELECT * FROM Inserted ,how to get the records just added?
     
    Similarly how...

    April 4, 2007 at 6:29 am

    #698507

  • RE: Delete all data

    Thanks both of you - I found this which seems to do the job -

     

    CREATE PROCEDURE procDeleteAll
     
    AS
     
    DECLARE @sql nvarchar(4000)

    SET @sql = ''

     

    March 30, 2007 at 3:15 am

    #697821

  • RE: sp to get parameters from tables records.

    Thankyou very much - that works perfectly.

    March 22, 2007 at 6:13 am

    #696335

Viewing 15 posts - 61 through 75 (of 90 total)