Forum Replies Created

Viewing 15 posts - 2,671 through 2,685 (of 18,926 total)

  • RE: INSERT INTO

    Lady Di (9/14/2011)

    The second select doesn't return 2... It returns 1.

    What is it???

    There's a small typo in the question. Happens sometimes.

    Steve will awards points back whenever he gets...

    September 14, 2011 at 5:53 am

    #1381207

  • RE: SSRS Export option

    activesoma (9/14/2011)

    Hi

    It is possible in SQL Server 2008 R2

    Go through the link for the step by step process.

    http://www.mssqltips.com/sqlservertip/2106/conditional-report-rendering-based-on-render-formats-for-ssrs-reports/

    Awesome.

    Another good reason to ask for the upgrade around here!!

    September 14, 2011 at 5:51 am

    #1381205

  • RE: INSERT INTO

    Lady Di (9/14/2011)

    The second select doesn't return... It returns 1.

    What is it???

    Yes it does. I'm guessing the PK sequence is wrong in the 2nd insert series, hence the incorrect...

    September 14, 2011 at 5:48 am

    #1381201

  • RE: INSERT INTO

    bitbucket-25253 (9/13/2011)

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    So this sig was written 2 years ago for specifically this moment. Nice forethought :hehe:

    September 14, 2011 at 5:43 am

    #1381195

  • RE: INSERT INTO

    Awesome question.

    And TIA for the points back :-D.

    Notice how I'm definitely not throwing the first stone here 😛

    September 14, 2011 at 5:42 am

    #1381193

  • RE: Difference between char and char(1)

    It's always better to specify the length. Different types have different default lenghts which are also altered be different circumstances. Which is why I don't memorise it. ...

    September 14, 2011 at 5:33 am

    #1381191

  • RE: SSRS Export option

    deepak.a (9/14/2011)

    Hi Ninja,

    Thanks for the reply is there any other way do this , because user wants to see the export option in lists

    Regards - Deepak

    Really streching it here.

    More...

    September 14, 2011 at 5:32 am

    #1381190

  • RE: 95th percentile

    Now 100% sure this applies for your case (speed read the thread, but it seems unsolved at the moment).

    Maybe this can inspire you the answer you need :

    WITH Waits...

    September 14, 2011 at 5:14 am

    #1381175

  • RE: Jeff Moden elected Exceptional DBA of 2011

    sushila (9/14/2011)

    CONGRATULATIONS Jeff!!! I cannot think of anyone who deserves it more. You've always been exceptional - glad that the recognition has been formalised.

    I'm hoping that Steve posts...

    September 14, 2011 at 5:09 am

    #1381173

  • RE: Store all in one database instead of one prodcution database and one historic database

    Grant Fritchey (9/14/2011)

    Ninja's_RGR'us (9/14/2011)

    Grant Fritchey (9/14/2011)

    Although, the current database was frequently very small and very responsive, the situations where you had to create cross-database joins were a pain.

    Why?

    The syntax is...

    September 14, 2011 at 5:08 am

    #1381172

  • RE: Are the posted questions getting worse?

    Grant Fritchey (9/14/2011)

    Of the year? I think I'd put it down to of the decade, but that's not what the contest was. Regardless, congratulations Jeff. You earned it! Can't wait...

    September 14, 2011 at 5:03 am

    #1381169

  • RE: Reports not getting most recent data

    The only close experience I have with this was back in Access where the data in the report was correct but the graphics were lagging behind.

    Now I know how unlikely...

    September 14, 2011 at 5:03 am

    #1381168

  • RE: Calculating Next Date problem

    vilonel (9/14/2011)

    @ninja's_RGR'us - this will help me - great work - thanks

    2+ birds, 1 stone, HTH :-).

    September 14, 2011 at 5:00 am

    #1381167

  • RE: SSRS Export option

    I'm really hoping someone knows this because I could use that as well.

    Right now the only idea I have is to put the render mode in the url. That...

    September 14, 2011 at 4:59 am

    #1381165

  • RE: Multiple values not showing in SSRS Report

    Jnrstevej (9/14/2011)

    It works in SSMS in the sp but when i try to refer to it in BI visual studio (SSRS) i usually get an error message that it doesnt...

    September 14, 2011 at 4:57 am

    #1381161

Viewing 15 posts - 2,671 through 2,685 (of 18,926 total)