Forum Replies Created

Viewing 15 posts - 631 through 645 (of 859 total)

  • RE: Scheduling a job via T-SQL.

    richard.noordam (4/10/2012)

    yes this is option two. :-). I think I'm looking for the 'minimal' approach here. or basically, the least # of times i have to run 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 10, 2012 at 2:34 pm

    #1471513

  • RE: Rollback the inserts

    gmamata7 (4/10/2012)

    Hi Using the below script to insert database into a table.

    But the data inserted is wrong and I want to rollback.

    But it looks like, it's already been committed.

    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 10, 2012 at 2:28 pm

    #1471512

  • RE: How to compare rows in source and destination tables dynamically in SQL Server

    when you load the data into your staging table does the data then match the table in your database you will be loading the data into? if so 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 10, 2012 at 2:22 pm

    #1471506

  • RE: Scheduling a job via T-SQL.

    what about a calender table. add the dates to run to the calendar table and have a job that runs each day check the table if the current date...

    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 10, 2012 at 2:06 pm

    #1471498

  • RE: Help with Group by months and Ordering.

    Lynn Pettis (4/10/2012)

    ColdCoffee (4/10/2012)

    Lynn/Capt.Hector , correct me if i am wrong, we dont need DATEADD+DATEDIFF in the GROUPBY/ORDER BY; just DATEDIFF would do.

    Why i say this, SQL needs to just...

    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 10, 2012 at 1:04 pm

    #1471454

  • RE: Help with Group by months and Ordering.

    damn beat me to the convert for the date type

    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 10, 2012 at 12:03 pm

    #1471403

  • RE: Help with Group by months and Ordering.

    some thing like this may work.

    SELECT DATEADD(MONTH,0,DATEDIFF(MONTH,0,[datefield])), COUNT(*)

    FROM table

    group by DATEADD(MONTH,0,DATEDIFF(MONTH,0,[datefield]))

    if you would like tested code can you post the DDL (Create table scripts) and some sample data (Hard coded...

    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 10, 2012 at 11:43 am

    #1471387

  • RE: How can I Get The Oldest 3 Records for each student

    well lynn you beat me to it. had almost the exact same code.

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

    #1470799

  • RE: How can I Get The Oldest 3 Records for each student

    Can you post the DDL (create table script) and hard coded inserts for us so we can be sure on the data and table structure. if you need help...

    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 9, 2012 at 11:40 am

    #1470788

  • RE: Primary key

    jitendra.padhiyar (4/9/2012)

    Thanks Vinu for suggestion, i tried it but it did not work when I save the changes.. its give me an error..

    "Saving changes is not permitted. The changes 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 9, 2012 at 10:48 am

    #1470755

  • RE: max/min grouping

    abecker 5532 (4/7/2012)

    Thank you so much for your reply. I can't test your query now, but I don't think it will work because lastD is not unique? idD is not...

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

    #1470398

  • RE: Cursor help

    Jeff Moden (4/6/2012)

    capn.hector (4/6/2012)

    Jeff Moden (4/6/2012)

    capn.hector (4/5/2012)

    Jeff Moden (4/5/2012)

    Considering that you input data is only a half of what your output data is, your going to have to describe how...

    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 6, 2012 at 5:22 pm

    #1470343

  • RE: a looping subquery whose result set is used by parent? do I use a CTE?

    thats one way but an inefficient way. all the cte's will be compiled into a single query by the optimizer but may not achieve the optimal plan if 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 6, 2012 at 5:07 pm

    #1470341

  • RE: Cursor help

    Jeff Moden (4/6/2012)

    capn.hector (4/5/2012)

    Jeff Moden (4/5/2012)

    Considering that you input data is only a half of what your output data is, your going to have to describe how the data describes...

    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 6, 2012 at 4:33 pm

    #1470332

  • RE: Question about tempdb data files filling up

    benjamin.reyes (4/6/2012)

    That's not a very good way to handle you tempdb files, but in this example sql server will still run, as long as there's someplace to expand the tempdb.

    Where...

    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 6, 2012 at 4:14 pm

    #1470327

Viewing 15 posts - 631 through 645 (of 859 total)