Forum Replies Created

Viewing 15 posts - 226 through 240 (of 254 total)

  • RE: Updating a table with only one occurence of row from another table

    SELECT
       DISTINCT [Unique ID],
       SUM([Line Amount])
    FROM
       <tablename>
    GROUP BY
       [Unique ID]
     
     

    ******************
    Dinakar Nethi
    Life is short. Enjoy it.
    ******************

    April 21, 2005 at 11:57 am

    #554174

  • RE: Problem inserting a record where the string field contains an apostrophe in the value

    If you use parameterized queries in asp.net you wouldnt have to do anything.

    ******************
    Dinakar Nethi
    Life is short. Enjoy it.
    ******************

    April 20, 2005 at 10:52 pm

    #553968

  • RE: Returning errors to Access from a stored procedure

    Is the data that is going into the variables in the same format mm/dd/yyyy ?

    ******************
    Dinakar Nethi
    Life is short. Enjoy it.
    ******************

    April 19, 2005 at 9:32 pm

    #553628

  • RE: Returning errors to Access from a stored procedure

    Does the stored proc run from Query Analyzer with hardcoded values for the parameters ?

    ******************
    Dinakar Nethi
    Life is short. Enjoy it.
    ******************

    April 19, 2005 at 5:16 pm

    #553614

  • RE: SELECT ALL FIELDS , best method ??

    If all you want to do is get the count you might as well do a
     
    DECLARE @count INT
    SELECT
      @count = COUNT(*)
    FROM
      [vwDups]
    IF @count > 0...

    ******************
    Dinakar Nethi
    Life is short. Enjoy it.
    ******************

    April 19, 2005 at 5:13 pm

    #553613

  • RE: Return identity inserted

    Sorry I meant IDENT_CURRENT
     
     

    ******************
    Dinakar Nethi
    Life is short. Enjoy it.
    ******************

    April 19, 2005 at 2:01 pm

    #553580

  • RE: how to see "my forums"

    May be you'all can use the Community Server forums that the ASP.NET site is using.

    ******************
    Dinakar Nethi
    Life is short. Enjoy it.
    ******************

    April 19, 2005 at 1:48 pm

    #553576

  • RE: Return identity inserted

    Even SCOPE_IDENTITY when looked up in BOL has enough information about @@IDENTITY, IDENT_INDENT and SCOPE_IDENTITY() and which one of them is better.

    ******************
    Dinakar Nethi
    Life is short. Enjoy it.
    ******************

    April 19, 2005 at 1:43 pm

    #553574

  • RE: a trigger question

    you can do : 

    Birthday = Sqldatetime.Null ' or even dbnull.value might work

    And you would need to import the sqltypes namespace for this.

    ******************
    Dinakar Nethi
    Life is short. Enjoy it.
    ******************

    April 19, 2005 at 12:06 pm

    #553520

  • RE: difference between two resultsets

    >>not in on 8 M records?????????????????????????
     
    I agree.  I didnt look at the number of records being returned.. I was only thinking...

    ******************
    Dinakar Nethi
    Life is short. Enjoy it.
    ******************

    April 19, 2005 at 12:02 pm

    #553518

  • RE: Changing color of comments in Query Analyzer

    You are right..it applies to the entire Editor and not just for the selected part. I did play around with all the options and I doubt if you can do...

    ******************
    Dinakar Nethi
    Life is short. Enjoy it.
    ******************

    April 19, 2005 at 11:59 am

    #553516

  • RE: Up The Wall

    red = string. as soon as you type a single quote anything typed after that becomes red until you close the single quote which marks the end of the string.

    ******************
    Dinakar Nethi
    Life is short. Enjoy it.
    ******************

    April 19, 2005 at 11:50 am

    #553513

  • RE: difference between two resultsets

    Perhaps something like this :
     
    Select e3a4.<PKCOlumn> --count(*)

    From dw_dsa.dbo.e3bdjr_a4bidm e3a4

    Left Join dw_dsa.dbo.JobCostDimLookupTbl jcdl on e3a4.Job = jcdl.JOB

    Left Join dw_sd.dbo.Job j on e3a4.Job = j.jobcode

    Left Join dw_sd.dbo.CostCode cc on (e3a4.Job =...

    ******************
    Dinakar Nethi
    Life is short. Enjoy it.
    ******************

    April 19, 2005 at 11:47 am

    #553512

  • RE: how to see "my forums"

    Yes I saw that after posting here and playing around the site ( I am a little new around here as you can guess by my posts) but it doesnt...

    ******************
    Dinakar Nethi
    Life is short. Enjoy it.
    ******************

    April 19, 2005 at 11:22 am

    #553506

  • RE: difference between two resultsets

    you can prbly use a LEFT OUTER JOIN or a RIGHT OUTER JOIN dpending on how you look at it..to get the nonmatching columns .. check out the Books On...

    ******************
    Dinakar Nethi
    Life is short. Enjoy it.
    ******************

    April 19, 2005 at 11:18 am

    #553504

Viewing 15 posts - 226 through 240 (of 254 total)