Forum Replies Created

Viewing 15 posts - 1 through 15 (of 20 total)

  • RE: Encryption

    Tao Klerks (3/29/2010)


    While the intent of the question is clear, there is currently some question as to the accuracy of the selected answer:

    http://www.schneier.com/blog/archives/2009/07/another_new_aes.html

    That's a very interesting read. I got...

  • RE: How many rows are returned from the query below?

    Wow. A few people get the question wrong and they assume the person writing the question must cover every version/release of SQL, must write the query to make sure...

  • RE: Counting spaces with datalength

    Very interesting. I typically use LEN but I can see how datalength would be useful.

  • RE: FOR XML PATH

    I like the question but more importantly I enjoyed the fact that it was an image. Forcing users to think it out.

    I was a little thrown off...

  • RE: When Do You Deploy?

    I work at a fortune 50 company but we are pretty decentralized. For our IT dept. we are forbidden from weekend upgrades. As long as it is a...

  • RE: Concatenation Cursor

    Nice question. I guessed at the answer but lucked out.

    I already have a use for this in a couple of procedures today. PERFECT TIMING!!

  • RE: Safety in Numbers

    Good discussion. Like many other I too keep at least 2 full backups and the trans logs between. I know there really is not a need to keep...

  • RE: Rowcount

    I assumed the answer would be (0,1) but when I ran it I got (1,1) on many version.

    I'm just posting to get my "point" back.

    Interesting debate...

  • RE: Row Number

    joseph_smithy-1130150 (7/17/2009)


    i want to add a row number to the bottom of the table in SSRS.... so it count how many rows i have

    You could also use "=count(Fields!?????????.Value)" as the...

  • RE: Database schema design

    It does depend but if I had 200,000 inserts a day I would want to normalize the data as much as possible. After a month, your looking at 6,000,000...

  • RE: Hide or Disable parameters in SSRS 2005

    Yusuf Ali Bhiwandiwala (9/20/2009)


    I'm sorry friend. This will not work. The user will still be able to give some value to the date parameter (p) , even if useDate is...

  • RE: Hide or Disable parameters in SSRS 2005

    Yusuf Ali Bhiwandiwala (9/18/2009)


    tmacs33,

    The question is : How do we grey out a report parameter (date type or not)?

    If greying out can be achieved, the SSRS world would be a...

  • RE: What to do when your job is sapping your motivation?

    aaa-322853 , first hang in there. I was once in a similar situation. Initially I tried to push back and fight them but then I was to by...

  • RE: ssrs 2008 deployment

    pilypala (9/17/2009)


    In visual studio, report solution explorer, I typed in TargetServerURL the following:

    http://myLocalhostname/MyReportServerName

    and leave TargetDataSourceFolder - empty

    and leave TargetReportFolder - empty

    but once I deployed the report, it...

  • RE: Hide or Disable parameters in SSRS 2005

    Yusuf Ali Bhiwandiwala (9/17/2009)


    Jack,

    That is what we have been doing to effectively disable the report params based on other params.

    But, can you suggest how to do so if the parameter...

Viewing 15 posts - 1 through 15 (of 20 total)