Forum Replies Created

Viewing 15 posts - 556 through 570 (of 859 total)

  • RE: checking 2 sql columns and displaying result in 1 column

    what query are you using to generate the table of data (the id risk rating...)

    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 13, 2012 at 3:15 pm

    #1473545

  • RE: checking 2 sql columns and displaying result in 1 column

    not really can you put the output you would like to see? something like this:

    cat ...

    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 13, 2012 at 3:06 pm

    #1473541

  • RE: checking 2 sql columns and displaying result in 1 column

    ewhitaker (4/13/2012)

    small edit..mistyped something

    --------------------new sql statement--------------

    select 'a' + convert(nvarchar, risk_rating) as cat,

    count(distinct orderfindings.prnt_id) as stat

    from orderheader, orderaudits, orderfindings, orderagencies

    where orderheader.id = orderaudits.orderheader_id and (orderaudits.ID = orderfindings.prnt_id or orderaudits.ID = orderagencies.prnt_id...

    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 13, 2012 at 2:52 pm

    #1473536

  • RE: fetching date from 1 sp to another

    hbtkp (4/13/2012)

    ok.

    just tell me logic

    how can i get if this dates r missing in field

    you need to add the missing dates to the data source. if the dates are...

    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 13, 2012 at 2:43 pm

    #1473525

  • RE: Today's Random Word!

    SQLRNNR (4/13/2012)

    TROLL

    urgal

    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 13, 2012 at 2:39 pm

    #1473516

  • RE: Are the posted questions getting worse?

    SQLRNNR (4/13/2012)

    L' Eomot Inversé (4/13/2012)

    Jeff Moden (4/13/2012)

    capn.hector (4/13/2012)

    ok on topic: http://www.sqlservercentral.com/Forums/Topic1283271-392-1.aspx how do you long time posters keep going when you run into people like this. (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 13, 2012 at 2:38 pm

    #1473514

  • RE: Msg 257, Level 16, State 3, Procedure procReceiveDeadLock_Graph, Line 28 Implicit conversion from data type xml to nvarchar(max) is not allowed. Use the CONVERT function to run this query.

    Lynn Pettis (4/13/2012)

    You can performance tune a proc but can't trouble shoot this error? Pretend it is an interview question and show us what you would do to solve...

    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 13, 2012 at 2:31 pm

    #1473509

  • RE: checking 2 sql columns and displaying result in 1 column

    here it is posted here

    CREATE TABLE orderheader

    (id int)

    CREATE TABLE orderaudits

    (id int,

    OrderHeader_ID int,

    Risk_Rating int,

    Investor_Name nvarchar(50))

    CREATE TABLE orderfindings

    (id int,

    Prnt_ID int,

    Finding_nbr char(10)

    )

    CREATE TABLE orderagencies

    (id int,

    Prnt_ID int,

    Agency_nbr char(10)

    )

    insert into orderheader

    values (1)

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

    insert into orderaudits

    values (1,1,1,...

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

    #1473451

  • RE: Performance and tuning

    also from the specific times there was probably a query in the company some one tuned from 20 min to 2 seconds and the interviewer knows exactly what was done...

    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 13, 2012 at 12:53 pm

    #1473429

  • RE: fetching date from 1 sp to another

    hbtkp (4/13/2012)

    OK,

    BASICALLY PITEM AND PITEM4 Calling function fitem and fitem4

    now this two function item has data for some fromdate and to date and values

    item4 has fromdate,todate and vales,but for all...

    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 13, 2012 at 12:01 pm

    #1473401

  • RE: Update State

    jitendra.padhiyar (4/13/2012)

    Yes, I am asking question. I have not observe it before but i attended an interview and inverviewer asked me this question " What is update state?"

    So i want...

    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 13, 2012 at 11:58 am

    #1473396

  • RE: fetching date from 1 sp to another

    hbtkp (4/13/2012)

    now get me solution

    Wow. um no. considering i still dont have all the info i requested in a nice readable format and now you seem to be...

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

    #1473388

  • RE: Finding Multiple Start and End Dates

    i was looking at this and seeing your code just made me realize how much i need to learn to think about problems better.

    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 13, 2012 at 11:47 am

    #1473384

  • RE: how can i insert in udf

    hbtkp (4/13/2012)

    i dont need to change field, i have filed

    CREATE FUNCTION item1(@Data [varbinary](max))

    RETURNS TABLE (

    item2 varchar,

    item3 int)

    now i need 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 13, 2012 at 11:36 am

    #1473376

  • RE: fetching date from 1 sp to another

    hbtkp (4/13/2012)

    i think i will lost my job , i am on dead line

    i m trying to help u as much as possible.

    there is nothing in sp, sp calling...

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

    #1473375

Viewing 15 posts - 556 through 570 (of 859 total)