Forum Replies Created

Viewing 15 posts - 1,111 through 1,125 (of 1,183 total)

  • RE: Sent external email using subscription

    nope

    ______________________________________________________________________

    Personal Motto: Why push the envelope when you can just open it?

    If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

    Jason L. Selburg
  • RE: Sent external email using subscription

    I mean on your email server, you'll need to enable email routing/forwarding. I'm not sure of the specifics. I just know that most companies block forwarding in some way, and...

    ______________________________________________________________________

    Personal Motto: Why push the envelope when you can just open it?

    If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

    Jason L. Selburg
  • RE: Sent external email using subscription

    You'll need to have your net admin allow routing from your report server.

    ______________________________________________________________________

    Personal Motto: Why push the envelope when you can just open it?

    If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

    Jason L. Selburg
  • RE: Strange execution plans

    I'm sure if you post your procedure, someone on here could give yo a better answer and perhaps find the problem.

    ______________________________________________________________________

    Personal Motto: Why push the envelope when you can just open it?

    If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

    Jason L. Selburg
  • RE: Strange execution plans

    From my understanding, if you have a stored procedure that takes parameters one of two things will happen.

    1. If you do not modify the parameters in the procedure, then the...

    ______________________________________________________________________

    Personal Motto: Why push the envelope when you can just open it?

    If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

    Jason L. Selburg
  • RE: Forward Dependencies are not valid.

    It sounds to me like the order of the parameters are wrong. Does the SupID parameter appear above the EmpId parameter in the Visual Studio Parameter box?

    Just a stab, but...

    ______________________________________________________________________

    Personal Motto: Why push the envelope when you can just open it?

    If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

    Jason L. Selburg
  • RE: Reporting Services 101 - Where do I begin ???

    This book should get you started. It's for RS 2000, but the basics are the same. IT usually runs about $40 US and is well worth it.

    http://www.sqlreportingservices.net/default.aspx

    ______________________________________________________________________

    Personal Motto: Why push the envelope when you can just open it?

    If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

    Jason L. Selburg
  • RE: Added "Closed" status to posts?

    I wouldn't suggest "Closing a post" and not allowing any further updates. Just a status that could be set by the original poster or your Admins. I would expect that...

    ______________________________________________________________________

    Personal Motto: Why push the envelope when you can just open it?

    If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

    Jason L. Selburg
  • RE: Numeric version of DIFFERENCE or SOUNDEX?

    Peter, THANK YOU for the help. Your first solution works partially, but it would incorrectly not match '12345' to 'a12345'. And I altered the spt_values to handle varying lengths of...

    ______________________________________________________________________

    Personal Motto: Why push the envelope when you can just open it?

    If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

    Jason L. Selburg
  • RE: Numeric version of DIFFERENCE or SOUNDEX (posted in YUKON also)?

    Here's the problem...

    select difference('1644700809','5xreww332')

    select difference('1644700809','9')

    both return 4.....

    ______________________________________________________________________

    Personal Motto: Why push the envelope when you can just open it?

    If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

    Jason L. Selburg
  • RE: Numeric version of DIFFERENCE or SOUNDEX (posted in YUKON also)?

    I am only using this to display a warning to the user to give them the option of not inserting a record.

    I COMPLETELY understand that many part numbers are only...

    ______________________________________________________________________

    Personal Motto: Why push the envelope when you can just open it?

    If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

    Jason L. Selburg
  • RE: Using CASE inside where clause

    First I sugeest you avoid using '*' in your select statement. Second, I'm making a few assumptions here, but this should get you started.

    select

    u.userid

    from

    ...

    ______________________________________________________________________

    Personal Motto: Why push the envelope when you can just open it?

    If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

    Jason L. Selburg
  • RE: Expression Help

    Keep in mind that RS handles logic at a much slower rate that SQL Server can. If you're not including too much logic, you should be ok. But as you...

    ______________________________________________________________________

    Personal Motto: Why push the envelope when you can just open it?

    If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

    Jason L. Selburg
  • RE: Exporting to Excel problem

    The way I understand it is that when a report is exported to Execl it starts on the left. For each control that is encountered a new column is created...

    ______________________________________________________________________

    Personal Motto: Why push the envelope when you can just open it?

    If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

    Jason L. Selburg
  • RE: New to Reporting Services

    This book is awsome. It takes you from simple reporting to building your own asp.net front end and it covers a ton of info in between. It really helped me...

    ______________________________________________________________________

    Personal Motto: Why push the envelope when you can just open it?

    If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

    Jason L. Selburg

Viewing 15 posts - 1,111 through 1,125 (of 1,183 total)