Forum Replies Created

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

  • RE: sql executive time question

    I don't know your database, but I'm curious about the inline SQL. Since you are not summarizing anything and appear to just be limiting records, have you tried rewriting...

  • RE: using COALESCE to contcatenate strings

    It's not the coalesce statement doing that. It's the structure of the SQL statement

    The issue is setting a variable equal to itself plus a...

  • RE: using COALESCE to contcatenate strings

    I believe the concatenation limitation comes from the definition of the varchar field in the column.  I could definitely be wrong about that.

    The example you show here is concatenating the values...

  • RE: using COALESCE to contcatenate strings

    Coalesce does exactly what you describe.  It returns the first non null value encountered and a null value if there is not a non-null value found in the parameter string.

    The...

  • RE: Accessing SQL 2005 Express from QA

    To my knowledge, Query Analyzer for SQL Server 2000 will not connect to a SQL 2005 database.  I could be wrong, but I'm pretty sure it can't.

  • RE: HOW TO DELETE RECORDS

    First...why can't you use temp_tables or identify functions?  They are the natural solution.  Create a temp table with the same structure, pass a distinct listing of the records to the...

  • RE: Risk in the stored procedure below

    Two risks that I see:

    One is no transaction so if a timeout or other issue happens you could end up with duplicates.

     

    Two, yes to my knowledge you could end up...

  • RE: Reuse of Stored Procedure

    The CASE statement is used with the SELECT command.  Just add Select in front of the CASE and you'll be all set.  Or rewrite it to use the IF command.

  • RE: Novice needing better performance from query

    Happy New Year!  Excellent!

    Always glad to help.  There are always so many options and variations that finding a solution can be much...

  • RE: Reuse of Stored Procedure

    if you embed it into a function you'll just use it very much like a field name...such as:

    [owner of function].[functionname(parameters)] as Alias

    example might be:

    dbo.fnProcess('Eng') as Process

  • RE: Novice needing better performance from query

    Have you thought of getting the cartons with an inline query instead?  I've seen this improve my queries from time to time.  Frank K might have some info on if...

  • RE: Another user trying get around a TEMP table

    I was offering an option for the trouble of getting yesterday's records.  I didn't see anything referring to a large table or performance.

     

    If DATEDIFF rules out indexes, does DATEADD?

  • RE: Another user trying get around a TEMP table

    Use the DATEDIFF function instead of all the DATEADDS.  Without modifying your code too much try this: (i removed the inner distinct as recommend earlier)

    select distinct b.shipment, MAX(b.scandate)

    from

         (select...

  • RE: Novice needing better performance from query

    I would suggest you rewrite your SQL into ANSI accepted standards.  Using commas instead of explicitly using JOIN and since you are using commas you don't use the ON clause. ...

  • RE: Help with SQl Query - to retrieve data in multiple rows

    You can join a table to itself, but you really want to join to versions of the table.  I believe the following:

    select * from (

    (select LDGR_BAL_AM as TRADE1 FROM DEVL8SGA.A_SGA_GRP_PSTN_SNP

    WHERE...

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