Forum Replies Created

Viewing 15 posts - 496 through 510 (of 859 total)

  • RE: if------then ----else in select statement

    riya_dave (4/18/2012)

    declare @P1 nvarchar(32)

    declare @mtd2 float

    declare c1 CURSOR FOR

    select account, MTD from #temp2

    open c1

    FETCH NEXT FROM c1

    INTO @P1,@mtd2

    WHILE @@FETCH_STATUS = 0

    begin

    if(@mtd2 IS NULL )

    BEGIN

    declare @IRR2 float

    EXEC pdashboard

    select...

    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 18, 2012 at 3:08 pm

    #1475751

  • RE: a very COMPLEX aggregation query

    polkadot (4/18/2012)

    There's my attachment. Bingo. Thanks Carpal.

    Lyn, I've already provided the DDL, which is what I think you're asking me to do. If I could create a query that...

    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 18, 2012 at 1:48 pm

    #1475686

  • RE: Are SQL views efficient?

    ill also say that if the tables in the view have indexes specially designed for the view it can be very fast.

    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 18, 2012 at 1:35 pm

    #1475669

  • RE: if it is possible to do insert store proc for this table2 like this?

    this should get you close

    ;WITH CTE(n) AS (SELECT 0 UNION ALL select TOP 500 ROW_NUMBER () OVER (ORDER BY (SELECT NULL)) FROM sys.objects a, sys.objects b)

    SELECT B.N + 1, syst,...

    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 18, 2012 at 1:29 pm

    #1475662

  • RE: Send mail Functionality

    Lynn Pettis (4/18/2012)

    Have you setup database mail for SQL Server Agent? IIRC, this is a separate step from just setting up database mail. Sorry if I'm not sure,...

    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 18, 2012 at 1:08 pm

    #1475624

  • RE: Reporting Solution

    SQLKnowItAll (4/18/2012)

    I don't like the open source idea... BTW, open source <> free.

    I would design a solution with 1 or 2 reporting servers that get the data replicated to them...

    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 18, 2012 at 12:59 pm

    #1475615

  • RE: outer join

    ok you have your join backwards. if you have the tables set like so in your query: table1 view1. now a left join will give you...

    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 18, 2012 at 11:48 am

    #1475561

  • RE: Today's Random Word!

    Lynn Pettis (4/18/2012)

    Childish

    man-boy-ish

    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 18, 2012 at 11:41 am

    #1475552

  • RE: Are the posted questions getting worse?

    Lynn Pettis (4/18/2012)

    SQLRNNR (4/18/2012)

    Lynn Pettis (4/18/2012)

    Here is a our first challenge. No one should post again until we get what has been requested.

    that kind of blatant hijacking needs to...

    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 18, 2012 at 11:41 am

    #1475551

  • RE: if------then ----else in select statement

    riya_dave (4/18/2012)

    where should i put fetch_next in body

    This will help you with the code http://remidian.com/mssql/t-sql/cursors-in-tsql.html however if you post the full code of your SP and the table definitions (DDL)...

    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 18, 2012 at 11:35 am

    #1475546

  • RE: Are the posted questions getting worse?

    Lynn Pettis (4/18/2012)

    The Dixie Flatline (4/18/2012)

    GilaMonster (4/17/2012)

    The "Mr I don't have a clue" thread is starting to resemble a pile-on. Maybe better to just ignore him or at most one...

    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 18, 2012 at 9:32 am

    #1475420

  • RE: if------then ----else in select statement

    EDIT: nothing constructive said and thinking about it after the post its better not to post it

    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 18, 2012 at 9:19 am

    #1475407

  • RE: Today's Random Word!

    EL Jerry (4/18/2012)

    Daniel Bowlin (4/18/2012)

    Brandie Tarvin (4/18/2012)

    Tootsie

    Roll

    Sushi.

    (I think I'm hungry)

    "El" Jerry.

    Sake

    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 18, 2012 at 7:55 am

    #1475348

  • RE: Are the posted questions getting worse?

    ON TOPIC: http://www.sqlservercentral.com/Forums/Topic1285488-392-1.aspx

    The OP needs some help on weird date time conversions when trying to get DDL and Sample data together. Looks like a local setting on his SQL...

    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 18, 2012 at 7:53 am

    #1475347

  • RE: creating DDL having datetime field

    im not sure whats going on but i thank you for taking the time to read how to post to the forumn and working up the DDL and Sample data....

    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 18, 2012 at 7:51 am

    #1475346

Viewing 15 posts - 496 through 510 (of 859 total)