Forum Replies Created

Viewing 15 posts - 1,456 through 1,470 (of 2,007 total)

  • RE: Getdate function not returning data

    Jnrstevej (10/17/2011)

    Yes your right it should be from October and include Nov 12 miss that out

    The adjustments you have made is perfect the other 2 questions i have is...

    October 17, 2011 at 8:01 am

    #1395346

  • RE: Getdate function not returning data

    Jnrstevej (10/17/2011)

    Brilliant thanks for that.

    Another question how would i control the dates that i want to show and increment it by 12 months according to the current.

    For...

    October 17, 2011 at 5:46 am

    #1395246

  • RE: Getdate function not returning data

    Jnrstevej (10/17/2011)

    Hello,

    I'm trying to return data for the current month(October 2011) but i cant seem to get it to work. Anyone what i am doing wrong here?

    declare...

    October 17, 2011 at 4:44 am

    #1395227

  • RE: Finding the column containing the minimum value

    IF object_id('tempdb..#Tab1') IS NOT NULL

    BEGIN

    DROP TABLE #Tab1

    END

    --1,000,000 Random rows of data

    SELECT TOP 1000000 IDENTITY(INT,1,1) AS ID,

    v1, v2, v3, v4, v5, v6

    INTO #Tab1

    FROM (SELECT...

    October 17, 2011 at 4:13 am

    #1395214

  • RE: Finding the column containing the minimum value

    Gianluca Sartori (10/17/2011)

    Cadavre (10/17/2011)

    Gianluca Sartori (10/14/2011)

    I couldn't resist!

    Me either 😀

    I already knew it was slow, but it was such a fun problem!

    It's something you don't stumble upon very often.

    Agreed. Which...

    October 17, 2011 at 2:33 am

    #1395180

  • RE: Finding the column containing the minimum value

    Gianluca Sartori (10/14/2011)

    I couldn't resist!

    Me either 😀

    ========== BASELINE ==========

    SQL Server Execution Times:

    CPU time = 203 ms, elapsed time = 205 ms.

    ================================================================================

    ========== CROSS JOIN ==========

    SQL...

    October 17, 2011 at 1:54 am

    #1395168

  • RE: Get data one by one and split using cursor or while loop

    metnik1981 (10/14/2011)

    @Mark-101232

    Hi! This topic is old, just want to add another question.

    If it's not exact multiple of split_value, how can i get the remaining split id?

    For example

    DECLARE @table1 TABLE(id...

    October 14, 2011 at 9:27 am

    #1394714

  • RE: Name concatenations

    Do you have a list of all of the companies that you can store in your own table? If so, this is trivial. If not, it's impossible due to the...

    October 14, 2011 at 9:04 am

    #1394692

  • RE: T-SQL Literature

    derekr 43208 (10/14/2011)

    Hi Guys

    I am looking to sharpen my T-SQL skills

    I've been eyeing the T-SQL Fundamentals book by Itzik Ben-Gan

    Anybody been through this book already? Reviews?

    Thanks

    I've not read that one,...

    October 14, 2011 at 7:59 am

    #1394650

  • RE: Finding the column containing the minimum value

    ChrisM@Work (10/14/2011)

    Anytime Phil. Test them both, I reckon Lowell's MegaCASE will win hands down.

    Now that you mention it, that was what I was looking at 🙂

    I like Chris' solution, because...

    October 14, 2011 at 7:07 am

    #1394627

  • RE: Challenging table join problem

    irobertson (10/13/2011)

    Interesting. Cue bout of furious SQL to investigate 🙂

    Think I have it, the ceiling method is matching 0.00* to 1.0 instead of to 0.0. This means that when you...

    October 13, 2011 at 9:27 am

    #1394147

  • RE: Challenging table join problem

    irobertson (10/13/2011)

    Much simpler (and more efficient) to just ceiling the ranged value I think:

    select *

    from MyValuesTable

    join MyScalesTable

    on ceiling(MyValuesTable.ValueFloat) = MyScalesTable.Scale

    Cheers, Iain

    Hmmm.

    --First things first, lets build a nice play-area

    IF...

    October 13, 2011 at 9:15 am

    #1394129

  • RE: Challenging table join problem

    ramadesai108 (10/13/2011)

    Hi All,

    I have a table with the ID (int) and ScalePoints (float) columns called Points.

    I have another table with Scale (float) and Descr(varchar) called Scales.

    I...

    October 13, 2011 at 9:08 am

    #1394116

  • RE: SSIS Package development and Deployment

    shyam.kishore (10/12/2011)

    I am new to SSIS. Please any body guide me, what points I should take care (development as well as deployment) while create an API package that will responsible...

    October 13, 2011 at 2:47 am

    #1393868

  • RE: Calculate quarterly data

    4EverandEver (10/13/2011)

    I need to calculate quartely bonus for consultants. The business rule is a consultant need to achieve 110% of his targets for each month in a quater to qualify...

    October 13, 2011 at 2:37 am

    #1393864

Viewing 15 posts - 1,456 through 1,470 (of 2,007 total)