Forum Replies Created

Viewing 15 posts - 271 through 285 (of 1,228 total)

  • RE: tuning query using max() over(partition by) clause

    venus.pvr (1/31/2014)

    anyone can think of anything for this one. I have n't been able to figure it. Thanks

    Your query almost certainly isn't doing what you are expecting. The column Usr...

    [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]

    February 1, 2014 at 1:10 am

    #1685281

  • RE: Working If Statement

    Read about BEGIN in books online. Which statements do you expect to be executed when IF returns true?

    [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 30, 2014 at 2:12 pm

    #1684853

  • RE: Old SQL Code and Compatibility

    homebrew01 (1/30/2014)

    We haven't written any code like that in a while. It is easy to search for '*=' and find the left joins. Not so easy to find the...

    [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 30, 2014 at 1:05 pm

    #1684828

  • RE: Which one of these three (2) WHERE clauses is BEST for PERFORMANCE?

    Tell us - try them.

    [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 30, 2014 at 12:58 pm

    #1684824

  • RE: How to use scalar function without WHILE

    vip.blade (1/27/2014)

    Hi,

    thanks for your fast response! It's a function to calculate the Levenshtein-Distance from this article: http://www.sqlservercentral.com/articles/Fuzzy+Match/92822/

    As far as I know there is no way to transform it into...

    [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 27, 2014 at 1:23 pm

    #1683692

  • RE: How to use scalar function without WHILE

    You're welcome. If you've run the code you will have noticed that you get duplicates - the same name pair appears twice in the result set, a.firstname + b.firstname and...

    [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 19, 2014 at 1:16 pm

    #1681406

  • RE: How to use scalar function without WHILE

    -- you have to test each row against all the other rows in the table i.e. CROSS JOIN:

    ;WITH [50RandomRows] AS (SELECT TOP 50 * FROM [AdventureWorks2012].[Person].[Person] ORDER BY NEWID())

    SELECT

    a.BusinessEntityID,...

    [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 19, 2014 at 10:57 am

    #1681400

  • RE: ProperCase Function

    This thread has been fun to watch, thanks folks! Here's an option I'm surprised nobody posted up:

    CREATE FUNCTION [dbo].[IF_ProperWithREPLACE]

    (

    @inputstring VARCHAR(8000)

    )

    RETURNS TABLE WITH SCHEMABINDING

    AS

    RETURN

    (

    SELECT ProperisedString =

    REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(

    REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(

    REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(

    ' '+@inputstring COLLATE...

    [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 19, 2014 at 5:42 am

    #1681388

  • RE: Return random records in a table-valued function?

    pietlinden (1/9/2014)

    Correct. It's modeling cancer treatment therapy, so sometimes they get fatal complications, and after that you can't test them anymore. (Cheery huh?)

    1989/90 I worked for a while in...

    [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 9, 2014 at 1:14 pm

    #1678956

  • RE: Return random records in a table-valued function?

    Each enrollee has a (random) small number of cycles, each cycle has a (random) number of symptoms - is this correct?

    If a group 5 symptom is allocated at any point,...

    [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 9, 2014 at 11:13 am

    #1678892

  • RE: insert twice seems to pick up new id

    Looking at the original code, it appears fine. A test harness works fine too, showing that your theory is sound:

    CREATE TABLE #tbl_directdebits (

    ID INT IDENTITY(1,1),

    ref VARCHAR(2),

    recurperiod VARCHAR(2),

    servicelevel VARCHAR(2),...

    [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 8, 2014 at 2:43 pm

    #1678599

  • RE: SQL Help needed...

    Sean Lange (1/8/2014)

    satishchandra (1/8/2014)

    Jeff, Here is the code for split function..

    Take a look at the link provided by Jeff above or the same link in my signature about splitting strings....

    [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 8, 2014 at 2:24 pm

    #1678597

  • RE: SLICING DATA IN A TABLE

    Which is probably faster than this, but you get the idea:

    WITH SampleData (VendorNbr, CCode, PayDate, NetPaid) AS (

    SELECT 'AAAAAAAAA', 1, 20120101, 3000.00 UNION ALL

    SELECT 'AAAAAAAAA', 1, 20120101, 6000.00 UNION ALL

    SELECT...

    [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 8, 2014 at 2:22 pm

    #1678596

  • RE: help with insert query

    harita (1/8/2014)

    hi all

    I am trying to insert from tableA to tableB

    there are 1000 records in tableA and I want to insert 100 records at a time into tableB

    idea is to...

    [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 8, 2014 at 1:35 pm

    #1678580

  • RE: COUNT

    Sean Lange (1/8/2014)

    sharonsql2013 (1/8/2014)

    Yes so I am counting RoundTables in ('1', N/A') AND IsVideo in ('1', 'N/A').

    and then need to do an and between these to counts.

    Should I separately count...

    [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 8, 2014 at 1:16 pm

    #1678568

Viewing 15 posts - 271 through 285 (of 1,228 total)