Forum Replies Created

Viewing 15 posts - 511 through 525 (of 566 total)

  • RE: How to Ignore Report Parameter

    Welsh Corgi (1/24/2012)

    wolfkillj (1/24/2012)

    Your splitter function returns the expected results, but the code in the stored proc should select the column Item from the function in the subselect in the...

    January 25, 2012 at 12:40 pm

    #1438391

  • RE: How to Ignore Report Parameter

    Your splitter function returns the expected results, but the code in the stored proc should select the column Item from the function in the subselect in the WHERE clause, not...

    January 24, 2012 at 2:14 pm

    #1437964

  • RE: How to Ignore Report Parameter

    Welsh Corgi (1/24/2012)

    wolfkillj (1/13/2012)

    Welsh Corgi (1/11/2012)

    After you have created the "splitter" function, your query syntax would look like this:

    WHERE State in (select Item from dbo.DelimitedSplit8K(@State, ','))

    I tried that but I...

    January 24, 2012 at 11:13 am

    #1437835

  • RE: How to Ignore Report Parameter

    mjbriggs03 (1/24/2012)

    Good question and I'm not sure haha. My query is about 32,000 characters long with nested selects, joins, etc. A real doozy. I've added two parameters...

    January 24, 2012 at 10:44 am

    #1437819

  • RE: How to Ignore Report Parameter

    mjbriggs03 (1/24/2012)

    I literally just wrote a parameter that I wanted to allow the user to use OR not use, their choice. It was a range parameter for population figures...

    January 24, 2012 at 9:39 am

    #1437774

  • RE: Create Paramater Filter by State

    Welsh Corgi (1/13/2012)

    The refresh and all of the other control with the exception of the Show or Hide Parameter button are disabled on the preview tab.

    The Refresh button will be...

    January 13, 2012 at 9:30 am

    #1433370

  • RE: Retrieving rows with unique data in certain fields

    stephen99999 (1/11/2012)

    Ooo. Sorry, I think I missinterpreted your requirements.

    Try this instead:

    SELECT qid, postcode_area, vehicle_group, premium, lic_years, ncb, proposer_age, email, created

    FROM Mainstreet.dbo.leads l

    ---------------

    --try this join

    inner join (

    SELECT distinct id

    FROM Mainstreet.dbo.leads

    ) le

    on...

    January 13, 2012 at 9:12 am

    #1433333

  • RE: Create Paramater Filter by State

    Welsh Corgi (1/11/2012)

    matt.jonas (1/11/2012)

    Can you post code for the stored procedure you are calling to populate your State dropdown box?

    I have made some progress.

    I created another Data Set to poulate...

    January 13, 2012 at 8:43 am

    #1433305

  • RE: How to Ignore Report Parameter

    Welsh Corgi (1/11/2012)

    I added a Null Value to the table that is used to populate the list-box, I select Null but I get no results.

    The Stored Procedure has the...

    January 13, 2012 at 8:35 am

    #1433294

  • RE: DATETIME Query problem

    If you use the ISO 8601 format for date/time string literals, conversions to DATETIME and DATETIME2 will not be affected by the SET LANGUAGE and SET DATEFORMAT session locale settings....

    January 10, 2012 at 10:00 am

    #1431284

  • RE: greatest(a,b,...) function

    wolfkillj (11/30/2011)

    Greg J (11/29/2011)

    Correct me if I'm wrong, but if the function that JLK proposed were to be inserted into an otherwise set-based UPDATE or SELECT statement, would it not...

    November 30, 2011 at 9:35 am

    #1414782

  • RE: greatest(a,b,...) function

    Greg J (11/29/2011)

    Correct me if I'm wrong, but if the function that JLK proposed were to be inserted into an otherwise set-based UPDATE or SELECT statement, would it not then...

    November 30, 2011 at 9:25 am

    #1414770

  • RE: insert in batches

    Sam Bendayan (11/21/2011)

    By "inserting in batches" do you mean breaking up the insert into batches? Such as doing 10,000 rows at a time instead of doing all 1 billion...

    November 22, 2011 at 12:33 pm

    #1411751

  • RE: I have a coworker....

    GSquared (11/21/2011)

    Koen Verbeeck (11/20/2011)

    Sean Lange (11/18/2011)

    Koen Verbeeck (11/18/2011)

    That will only work if she keeps the lit on the pot, so that pressure rises within the pot.

    I don't think you can...

    November 22, 2011 at 12:20 pm

    #1411746

  • RE: Landing My First Job

    Joseph Hampton (11/22/2011)

    I got the job as a Data Analyst(pretty much analogous to SQL Developer). The cool thing is the DBA is giving me opportunities to take on some...

    November 22, 2011 at 11:26 am

    #1411717

Viewing 15 posts - 511 through 525 (of 566 total)