Forum Replies Created

Viewing 15 posts - 8,266 through 8,280 (of 26,490 total)

  • RE: Query join

    mrivero1961 (3/28/2013)

    Lynn Pettis (3/28/2013)

    Start with something like this:

    select

    idDGIG,

    count(idDGIG) as Number

    FROM (

    SELECT

    LEFT (idDGIG, 2) AS...

    March 28, 2013 at 4:08 pm

    #1601899

  • RE: Query join

    Start with something like this:

    select

    idDGIG,

    count(idDGIG) as Number

    FROM (

    SELECT

    LEFT (idDGIG, 2) AS idDGIG,

    ...

    March 28, 2013 at 3:37 pm

    #1601885

  • RE: How to show Carriage Return Char(13) in XML as real CR instead of tag.

    Be sure to display the output to text, not grid:

    DECLARE @TABLE TABLE (ID INT IDENTITY(1,1),

    ...

    March 28, 2013 at 3:26 pm

    #1601882

  • RE: Query join

    Here is your join (slightly modified by me):

    FROM

    TABLE_LONG CA

    INNER JOIN TABLE_SHORT A

    ON CA.DATE_START =...

    March 28, 2013 at 3:20 pm

    #1601880

  • RE: Search table field with LIKE clause

    kk1173 (3/28/2013)

    Thanks for all the suggestions.

    Changing the date condition did not help improve the performance.

    Here are the DDL and index details of the table

    Table Case1

    ------------

    CaseID varchar(15)

    ,Emp_ID varchar(15)

    ,Segment varchar(10)

    ,dischargedt date

    ,discharge_entered_dt...

    March 28, 2013 at 2:22 pm

    #1601856

  • RE: Are the posted questions getting worse?

    SQLRNNR (3/28/2013)

    Lynn Pettis (3/28/2013)

    jcrawf02 (3/28/2013)

    Lynn Pettis (3/28/2013)

    SQLRNNR (3/28/2013)

    jasona.work (3/28/2013)

    Anyone thinking of going to see the popcorn movie that is "GIJoe: Retaliation"?

    I'm debating between waiting until tomorrow, or going to see...

    March 28, 2013 at 2:09 pm

    #1601846

  • RE: DBCC SHRINKFILE print out issues

    As Jeff indicated in his post, this is a bad idea. Changing from FULL recovery model to SIMPLE recovery model breaks your log chain. Changing back requires a...

    March 28, 2013 at 1:09 pm

    #1601812

  • RE: DBCC SHRINKFILE print out issues

    Angelindiego (3/28/2013)

    I want to run a script that builds out a message to execute shrinking log files. The issue that I am seeing is that when it is printed out...

    March 28, 2013 at 1:06 pm

    #1601811

  • RE: How to store a SQL statement in a table?

    Code-1029433 (3/28/2013)

    I'm needing to store a SQL statement in a VARCHAR(MAX) column in a database table, however I'm having trouble getting statemen to insert. What is the best aproach to...

    March 28, 2013 at 12:51 pm

    #1601806

  • RE: Search table field with LIKE clause

    Brandie Tarvin (3/28/2013)

    Sean Lange (3/28/2013)

    kk1173 (3/28/2013)

    discharged_entered is a date field.

    Then forget all the convert nonsense. Just compare it to a datetime.

    c.discharge_entered_dt >= DATEADD(DAY, -14, getdate())

    Sean, This won't necessarily work for...

    March 28, 2013 at 12:46 pm

    #1601802

  • RE: Search table field with LIKE clause

    Would help to see the DDL for the table(s) including indexes. Also, if you are using SQL Server 2008, a proper filtered index may be of benefit here.

    March 28, 2013 at 12:37 pm

    #1601794

  • RE: Search table field with LIKE clause

    ...

    WHERE c.dischargedt is not null and c.discharge_entered_dt >= dateadd(dd, -14, getdate())

    March 28, 2013 at 12:36 pm

    #1601792

  • RE: Are the posted questions getting worse?

    jcrawf02 (3/28/2013)

    Lynn Pettis (3/28/2013)

    SQLRNNR (3/28/2013)

    jasona.work (3/28/2013)

    Anyone thinking of going to see the popcorn movie that is "GIJoe: Retaliation"?

    I'm debating between waiting until tomorrow, or going to see it tonight on...

    March 28, 2013 at 12:34 pm

    #1601789

  • RE: Reorganze index and Statistics

    EL_oh_EL (3/28/2013)

    Thanks but bulk logged wont work for us. Also, we are use log shipping to another datacenter.

    Mind if we ask why it wouldn't work?

    March 28, 2013 at 10:54 am

    #1601750

  • RE: Are the posted questions getting worse?

    SQLRNNR (3/28/2013)

    jasona.work (3/28/2013)

    Anyone thinking of going to see the popcorn movie that is "GIJoe: Retaliation"?

    I'm debating between waiting until tomorrow, or going to see it tonight on my own, then...

    March 28, 2013 at 10:33 am

    #1601743

Viewing 15 posts - 8,266 through 8,280 (of 26,490 total)