Forum Replies Created

Viewing 15 posts - 31 through 45 (of 113 total)

  • RE: Finding “Active” Rows for the Previous Month (SQL Spackle)

    Excellent article. A problem that i have never come across but may do. The train of thought on the problem was insightful.

    January 30, 2014 at 6:52 am

    #1684631

  • RE: Text Date format into datetime

    Sorry please ignore the post. I managed to find a solution. Once you trim off the day the rest will just convert.

    Clever SQL!

    So just incase anyone finds...

    January 16, 2014 at 1:27 am

    #1680550

  • RE: Parameter selection failure

    I had something very similar recently. Look for odd characters in the drop down selection. One of my drop downs had a CRLF at the end of one...

    November 14, 2013 at 9:14 am

    #1666425

  • RE: ISNUMERIC(varchar)

    For me this is one of the big issues with 2008. As these will pass isnumeric but some of them (for instance ",") will then not convert into decimals...

    October 15, 2013 at 2:43 am

    #1658435

  • RE: Using a column name in a COUNT function

    According to MS sys.partitions.rows "Indicates the approximate number of rows in this partition"

    http://technet.microsoft.com/en-us/library/ms175012.aspx

    October 15, 2013 at 1:55 am

    #1658420

  • RE: Can we display some text message before exporting data in SSRS

    If you enbed as suggested you could then hide the text when exported so it doesnt appear on your output file (to do you need 2008 or above).

    Dan

    September 18, 2013 at 3:07 am

    #1651033

  • RE: How to get the Report URL in SSRS

    TomGuide (9/6/2013)

    Hi Guys,

    Thank you so much for your replies.Your replies and suggestions helped me to gain more knowledge.Thanks for that.

    I have also googled from my end and I found that...

    September 9, 2013 at 9:47 am

    #1648590

  • RE: T-SQL

    PRR.DB (7/22/2013)

    If table doesn't have clustered index , there is no guarantee for order , if table having clustered index then result will display clustered index column order.

    Is my...

    July 22, 2013 at 1:45 am

    #1634362

  • RE: SQL Server 2012 Concat

    Carlo Romagnano (7/9/2013)

    Hugo Kornelis (7/9/2013)

    Carlo Romagnano (7/9/2013)

    select concat(null + 'Hello','testString') as a

    , null+'testString' as b

    It simply returns 'testString', NULL

    😀

    Yup. If you wanted to get 'HellotestString',...

    July 9, 2013 at 4:30 am

    #1630722

  • RE: How to get list of tables used in SSRS reports

    I dont think you can. You have to bear in mind that it may not use tables - it may use views or stored procedures or suchlike.... which then...

    June 21, 2013 at 4:31 am

    #1626267

  • RE: HTML Slow

    Looking at the Rsexcutionlog3 the PDF takes 7 seconds to render, the html of exactly the same takes 70 seconds to render.

    Any ideas anyone?

    Dan

    June 12, 2013 at 9:17 am

    #1623394

  • RE: IFF - 1

    sfayer (6/6/2013)

    Why does 'r ' = 'R' evaluate to true?

    Steve

    Thats what i was going to say. Surely that depends on if the system is running with Case Sensitive or...

    June 6, 2013 at 2:10 am

    #1621629

  • RE: Parallel Processing Using Jobs

    gfish (4/29/2013)

    I am not just speaking hypothetically. We added an almost identical process to our system years ago and we are now spending a lot of time getting rid of...

    April 29, 2013 at 8:41 am

    #1610844

  • RE: Parallel Processing Using Jobs

    Hey all,

    Great idea - and perfect timing for me.

    I am currently looking to rewrite some of our TL (E is done prior) to a better system then it currently runs...

    April 29, 2013 at 2:01 am

    #1610695

  • RE: Can This Work?

    p.govindaraj (3/1/2013)

    Yes, It will create infinite loop but it will end with maximum nesting level on 32

    I love that - a finite infinite loop!

    March 1, 2013 at 6:35 am

    #1592341

Viewing 15 posts - 31 through 45 (of 113 total)