Forum Replies Created

Viewing 15 posts - 241 through 255 (of 859 total)

  • RE: Passing conditional where clause ?

    to actually be helpful im going to point you to another link. again from sommarskog.se

    http://www.sommarskog.se/dyn-search-2008.html

    it addresses variable search conditions in a very well thought out manner.

    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]

    July 26, 2012 at 1:31 pm

    #1518149

  • RE: Are the posted questions getting worse?

    Lynn Pettis (7/26/2012)

    Brandie Tarvin (7/26/2012)

    WayneS (7/26/2012)

    You'll might find this interesting: http://www.sqlperformance.com/2012/07/t-sql-queries/split-strings

    Very interesting indeed. Poor Jeff. Poor Tally Tables.

    Did you take a close look at how Jeff's split routine was modified?...

    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]

    July 26, 2012 at 1:14 pm

    #1518146

  • RE: Update Query for same table in 2 different column

    im getting a little confused, can you post DDL Sample Data and the expected output based on that sample data?? it would really help to have both the input...

    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]

    July 26, 2012 at 12:49 pm

    #1518135

  • RE: Is there an joiner much like the 8kSplitter?

    anthony.green (7/26/2012)

    Thanks Gents, been one of them days and nothing gone right so far, so my heads not in the game.

    Gone with John's responce as its the simpler to impliment,...

    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]

    July 26, 2012 at 10:56 am

    #1518066

  • RE: "Restore" data for 1 customer in a multi-customer database

    at my shop we have nightly backups of our database restored to the same server under a different name. if something happens from the time of the last backup...

    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]

    July 26, 2012 at 10:52 am

    #1518061

  • RE: Passing conditional where clause ?

    vchandm23 (7/25/2012)

    CREATE PROCEDURE [dbo].[myProc]

    @whereSql nvarchar(256)

    AS

    EXEC('SELECT [fields] FROM WHERE ' + @whereSql)

    GO

    From stackOverflow website. This is what i was looking for. I am sharing this here...

    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]

    July 26, 2012 at 8:12 am

    #1517962

  • RE: Query Help- Cursor change into FOR WHILE LOOP, TEMP TABLE

    morepainot (7/26/2012)

    ...The reason for the WHILE LOOP is because with CURSOR it is much slower than with WHILE LOOP. ...

    I would love to see the tests on that statement. ...

    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]

    July 26, 2012 at 7:51 am

    #1517946

  • RE: Remove one column from SQL select statement

    SQLCrazyCertified (7/24/2012)

    capn.hector (7/24/2012)

    it depends on how the user selects the columns they want. i would do any actual dynamic query creation with a stored procedure API level and validate...

    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]

    July 24, 2012 at 7:09 pm

    #1517137

  • RE: Allow read-only user to execute a user funcition

    n.heyen (7/24/2012)

    Thank you Cap'n Hector,

    I was sort of afraid that was the answer. I can create a db user and grant permissions. That works, I was just hoping there was...

    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]

    July 24, 2012 at 4:04 pm

    #1517105

  • RE: Update statement appending text to a column?

    For my own curiosity what is this part of the code doing:

    select @random = convert(int,(((1) - @currLen) * RandomValue + @currLen))

    from dbo.vwRandom;

    Im guessing vwRandom is a view but the question...

    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]

    July 24, 2012 at 3:53 pm

    #1517099

  • RE: Allow read-only user to execute a user funcition

    in order to grant permissions to an object the server user must exist as a user in the database (unless when trying the same thing i missed something). 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]

    July 24, 2012 at 3:34 pm

    #1517094

  • RE: Remove one column from SQL select statement

    it depends on how the user selects the columns they want. i would do any actual dynamic query creation with a stored procedure API level and validate any input...

    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]

    July 24, 2012 at 2:05 pm

    #1517067

  • RE: Detecting SQL Logins that have been unused for X amount of days?

    bill.schoonmaker (7/24/2012)

    I did a bit of digging and found this script, located here - http://sequelserver.blogspot.com/2011/06/lists-user-login-attempts-to-sql-server.html

    DECLARE @TSQL NVARCHAR(2000)

    DECLARE @lC INT

    CREATE TABLE #TempLog (

    ...

    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]

    July 24, 2012 at 11:57 am

    #1516994

  • RE: Today's Random Word!

    Cliff Jones (7/24/2012)

    Ray K (7/24/2012)

    Ichiro

    (says the happy Yankee fan this morning!)

    Suzuki!

    Honda

    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]

    July 24, 2012 at 9:40 am

    #1516901

  • RE: How to grant view definition access only on Views & Functions in SQL Server 2K8R2

    The grant command is what you are looking for

    http://msdn.microsoft.com/en-us/library/ms187965.aspx

    i may look at a custom database role so you do not have to grant every thing to multiple users. only...

    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]

    July 23, 2012 at 2:07 pm

    #1516462

Viewing 15 posts - 241 through 255 (of 859 total)