Forum Replies Created

Viewing 15 posts - 571 through 585 (of 859 total)

  • RE: Today's Random Word!

    crookj (4/13/2012)

    WOTD - masticate

    choke the..... oh wait

    chew

    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:32 am

    #1473372

  • RE: Are the posted questions getting worse?

    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 thread there are more out 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 13, 2012 at 11:31 am

    #1473369

  • RE: how can i insert in udf

    a udf is a user defined function. by deffinition to change or update a FUNCTION you have to update or change the code for the function. im starting...

    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:29 am

    #1473367

  • RE: fetching date from 1 sp to another

    hbtkp (4/13/2012)

    it snot my design,this is how my database is working

    i m just employee ,i dotn have right to change anything

    so plz help

    ok so help us help you work within...

    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:27 am

    #1473364

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

    we do a similar process, we backup the database, zip it to condense it a little (we dont use backup compression) copy the zip file over the network, unzip 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 13, 2012 at 10:53 am

    #1473352

  • RE: how can i insert in udf

    ALTER FUNCTION udf... ??

    can you post your UDF code and DDL (Create table scripts) and sample data (INSERT Statements) so we can see what gets passed to the udf what...

    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 10:48 am

    #1473349

  • RE: Multiple self joins with Count function goes wrong

    Sean Lange (4/13/2012)

    Wow your first post and you posted all the ddl and sample data perfectly!!! Excellent!!! I wish everyone who posted paid as much attention.

    Now for your issue. 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 13, 2012 at 10:36 am

    #1473341

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

    can you post your DDL (create table scripts) and Sample data as text in the thread. that will help every one help 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 13, 2012 at 10:22 am

    #1473338

  • RE: how to sum up instances only 3 of the 4 values that can occur in a given column

    vinu512 (4/12/2012)

    You are right capn.

    I tried the Sum(TotalCount), but somehow it was not returning what I wanted. Maybe something wrong I had written in the code. That's when I added...

    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 9:21 am

    #1473305

  • RE: Recursive CTE for Item supersession question

    F.L (4/12/2012)

    Hello,

    Hijacking this thread since OP seems to be satisfied with the solution provided. (I hope that is OK)

    I´m trying to use CTE to find the very top parent within...

    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 9:16 am

    #1473302

  • RE: fetching date from 1 sp to another

    you have been asked and asked. if you cant read the link in my signature for how we like to see the sample data and table scripts after being...

    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 9:07 am

    #1473299

  • RE: Query

    can you post the create table statements (DDL) and sample data so we know what we are working on. with out the table structure and sample data we 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 9:05 am

    #1473297

  • RE: Are the posted questions getting worse?

    Revenant (4/12/2012)

    SQLRNNR (4/12/2012)

    Koen Verbeeck (4/12/2012)

    GilaMonster (4/12/2012)

    I'm getting very frustrated (and very saddened) by the (apparently) increasing number of people who seem to feel that writing T-SQL is about throwing 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 12, 2012 at 4:25 pm

    #1472986

  • RE: SQL Server question

    rudy komacsar - Doctor "X" (4/12/2012)

    how about this for your restore:

    alter database your_database_name set single_user with rollback immediate

    go

    alter database your_database_name set restricted_user

    go

    restore database your_database_name

    go

    alter database your_database_name set multi_user

    go

    its what 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 12, 2012 at 3:51 pm

    #1472978

  • RE: GROUP BY and HAVING problem

    sgmunson (4/12/2012)

    The gremlins are everywhere....

    Sadly, the problem is fixed because somebody fat-fingered a table name in existing code and after OBFUSCATING it for publication here, I could no longer tell...

    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 12, 2012 at 2:07 pm

    #1472935

Viewing 15 posts - 571 through 585 (of 859 total)