Forum Replies Created

Viewing 15 posts - 541 through 555 (of 1,228 total)

  • RE: Restart Counting with Row_Number()

    Heh Paul that's too funny!

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    January 26, 2012 at 1:38 am

    #1438606

  • RE: Restart Counting with Row_Number()

    Much better sample set, thanks:

    ;WITH GroupedData AS (

    SELECT mid, datum, id_status,

    GroupID = ROW_NUMBER() OVER (PARTITION BY mid ORDER BY datum, id_status) -

    DENSE_RANK() OVER (PARTITION BY mid, id_status ORDER BY...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    January 26, 2012 at 12:46 am

    #1438594

  • RE: Restart Counting with Row_Number()

    ;WITH phs_termine AS (

    SELECT mid = 47,datum = '2006-07-13',id_termine_status = 9 UNION ALL

    SELECT 47,'2006-07-19',1 UNION ALL

    SELECT 47,'2006-09-18',1 UNION ALL

    SELECT 47,'2006-09-19',1 UNION ALL

    SELECT 47,'2006-09-21',1 UNION ALL...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    January 26, 2012 at 12:34 am

    #1438591

  • RE: cte delete operation

    kirkdm01 (1/24/2012)

    I have a cte that loops through the records creates a list and i pass a parameter of @ParamterID in a select statement ...

    Check that your rCTE works before...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    January 24, 2012 at 5:25 am

    #1437594

  • RE: alternative to cte

    kirkdm01 (1/24/2012)

    how do you create an index on ParentPostID im new to SQL so im just learning. What do i do

    What's your working environment, Kirk? Are you on your own/do...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    January 24, 2012 at 4:07 am

    #1437574

  • RE: need help with a script

    -- use a more appropriate value for the size of @log_file_path:

    SET @log_file_full_path [NVARCHAR(255)]

    = @log_file_path [VARCHAR(512)]

    + @database_name [VARCHAR(32)]

    + @cnv_extension [VARCHAR(4)]

    + @ldf_extension [VARCHAR(4)]

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    January 24, 2012 at 3:06 am

    #1437543

  • RE: Almost a Delimited Split kind of Join?

    Hi Lowell

    This seems to work - at least, the logic is correct according to my interpretation of your requirements. If you add a nonsense character to one of the user's...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    January 24, 2012 at 2:30 am

    #1437518

  • RE: alternative to cte

    kirkdm01 (1/23/2012)

    I was wondering if someone here knew how to write another select statement that wasn't a cte. This displays a list of posts in their heirarchy. Does anyone else...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    January 24, 2012 at 12:16 am

    #1437491

  • RE: Help me: Many Tables to join.

    DBA Rafi (1/23/2012)

    The Plan I posted is from my QA database.

    Hi Rafi

    This is the estimated plan, can you post the actual plan please?

    Cheers

    ChrisM

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    January 23, 2012 at 12:29 pm

    #1437321

  • RE: Three table query problem in stored procedure

    See also 'SET QUOTED_IDENTIFIER (Transact-SQL)' in Books Online, the help system for SQL Server. Double quotes have a special meaning in SQL Server (by default).

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    January 23, 2012 at 12:23 pm

    #1437311

  • RE: Comparing data row by row....

    Here's some results of testing the usual method against a rCTE

    Tests were performed against a million rows, consisting of a frame of 50 seed rows repeated with non-overlapping dates.

    With...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    January 23, 2012 at 7:22 am

    #1437092

  • RE: Aggregate Query

    Mark-101232 (1/23/2012)

    DECLARE @t TABLE(DateValue datetime,Value int)

    INSERT INTO @t(DateValue,Value)

    SELECT '20120102',0 UNION ALL

    SELECT '20120103',1 UNION ALL

    SELECT '20120104',1 UNION ALL

    SELECT '20120105',1 UNION ALL

    SELECT '20120106',1 UNION ALL

    SELECT '20120107',1 UNION ALL

    SELECT '20120108',0 UNION ALL

    SELECT '20120109',1...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    January 23, 2012 at 6:30 am

    #1437047

  • RE: Aggregate Query

    drop table #testvalue

    create table #testvalue (datevalue datetime,value int)

    insert into #testvalue (datevalue, value) VALUES

    ('2012-01-02', 0),

    ('2012-01-03', 1), -- MIN

    ('2012-01-04', 1),

    ('2012-01-05', 1),

    ('2012-01-06', 1),

    ('2012-01-07', 1), -- MAX

    ('2012-01-08', 0),

    ('2012-01-09', 1),

    ('2012-01-10', 1),

    ('2012-01-11', 0),

    ('2012-01-12', 1), -- MIN

    ('2012-01-13',...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    January 23, 2012 at 6:29 am

    #1437046

  • RE: procedure cache hit ratio too high?

    ananda.murugesan (1/23/2012)

    ...7. procedure cache Hit ratio - 90% to 95%

    Procedure Cache Hit Ratio

    Percentage of time when SQL Server looks for an execution plan in the procedure cache and finds...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    January 23, 2012 at 3:34 am

    #1437000

  • RE: Comparing data row by row....

    Evil Kraig F (1/20/2012)

    ChrisM@home (1/20/2012)

    This breaks a 5-row set based on date then time, leaving 2 remaining valid 5-row sets in the 50-row seed data. The 3 islands-n-gaps queries yield...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    January 21, 2012 at 12:44 am

    #1436790

Viewing 15 posts - 541 through 555 (of 1,228 total)