Forum Replies Created

Viewing 15 posts - 526 through 540 (of 859 total)

  • RE: using t-sql to roll-up aggregated info.

    hxkresl (4/17/2012)

    stuck on an error in the SELECT statement

    Msg 207, Level 16, State 1, Line 32

    Invalid column name 'Portfolio'.

    WITH Maxticket AS (SELECT AD.ID, AD.OrgName,

    ...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 17, 2012 at 1:21 pm

    #1474988

  • RE: using t-sql to roll-up aggregated info.

    ok so we put the renaming of the column into the first CTE as follows:

    WITH Maxticket AS (SELECT AD.ID, AD.OrgName,

    ...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 17, 2012 at 11:33 am

    #1474925

  • RE: how can i insert in udf

    Lynn Pettis (4/17/2012)

    hbtkp (4/17/2012)

    ok. i already posted my formula for cumulative.

    i hv another prov

    i have delcare variable

    declare @abd datetime

    now i need to get 1 date from function

    like

    select @abd = fromdate...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 17, 2012 at 11:18 am

    #1474914

  • RE: use print statement in stored procedure

    zojan (4/17/2012)

    If you want log steps of the SP_ you can use loging into log_table.

    You can lo step (which is executed), Getdate(),...

    you can add sp_name column to log more...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 17, 2012 at 8:26 am

    #1474754

  • RE: using t-sql to roll-up aggregated info.

    hxkresl (4/16/2012)

    It's really helpful capn.Hector. Thanks for mentoring.

    I have one last thing to do.

    The report must have one additional level to it's hierarchy that doesn't even exist in the...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 17, 2012 at 7:09 am

    #1474703

  • RE: Problem with CTE

    Cadavre (4/17/2012)

    This is quicker: -

    SELECT DATEADD(DD,N,GETDATE())

    FROM (SELECT N

    FROM (VALUES(0),(10),(20),(30),(40),(50),(60),

    ...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 17, 2012 at 6:43 am

    #1474674

  • RE: use print statement in stored procedure

    i have always used SELECT 'String you want to display here' and not had a problem with multiple outputs in a stored procedure.

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 16, 2012 at 7:14 pm

    #1474489

  • RE: Problem with CTE

    i got it to work by using the following:

    WITH fechas (fecha) AS (

    SELECT GETDATE() AS fecha UNION ALL

    SELECT DATEADD(day,10, fecha) from fechas )

    select TOP 12 fecha from fechas -- instead...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 16, 2012 at 7:12 pm

    #1474488

  • RE: using t-sql to roll-up aggregated info.

    it would be adding a variation of your case statement you have in the cte to the final query, not using another cte. i can post the answer in...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 16, 2012 at 7:07 pm

    #1474487

  • RE: Copy a database, then test its restore...

    jitendra.padhiyar (4/16/2012)

    Hi Hector,

    Is import/Export good solution?

    I mean we will first export db to excel file and than copy that excel file to remote server where we can import that db.

    Thanks,

    i...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 16, 2012 at 4:05 pm

    #1474455

  • RE: Windows Updates on SQL Servers

    it has been discussed before but in case its hidden some where.

    depending on how mission critical the box is we install patches the next time we have to reboot after...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 16, 2012 at 3:56 pm

    #1474450

  • RE: db_send_mail to txt.att.net recipient shows up on phone from weird 10 digit phone number

    i hate to be the bearer of bad news but because its AT&T you have to live with the quirks. AT&T does this with every email (as far as...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 16, 2012 at 3:51 pm

    #1474447

  • RE: how to integrate a solution into existing query

    see the original thread i have posted an answer there.

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 16, 2012 at 3:41 pm

    #1474443

  • RE: using t-sql to roll-up aggregated info.

    ; WITH Maxticket AS (SELECT AD.ID, AD.OrgName, AD.ProjName, AD.Ticket#, ROW_NUMBER() OVER (PARTITION BY AD.Ticket# ORDER BY Revision_num DESC) AS revision

    ...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 16, 2012 at 3:40 pm

    #1474442

  • RE: Today's Random Word!

    Ray K (4/16/2012)

    Revenant (4/14/2012)

    capn.hector (4/13/2012)

    SQLRNNR (4/13/2012)

    TROLL

    urgal

    Xbox

    360

    degrees

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 16, 2012 at 3:20 pm

    #1474433

Viewing 15 posts - 526 through 540 (of 859 total)