Forum Replies Created

Viewing 15 posts - 91 through 105 (of 161 total)

  • RE: Update table values if corresponding values change in another table

    pwalter83 (7/31/2013)

    Sean Lange (7/29/2013)

    Since you started a new thread and Chris pointed me back to this one I will post here.

    I would agree that trying to keep this data in...


    The opinions expressed herein are strictly personal and do not necessarily reflect the views or policies of my employer.

    July 31, 2013 at 9:17 am

    #1637428

  • RE: Update table values if corresponding values change in another table

    pwalter83 (7/24/2013)

    ChrisM@Work (7/24/2013)

    pwalter83 (7/24/2013)

    ChrisM@Work (7/24/2013)

    pwalter83 (7/24/2013)

    ChrisM@Work (7/24/2013)

    pwalter83 (7/24/2013)

    ChrisM@Work (7/24/2013)

    Lowell has already asked but the question remains unanswered: why do you want to hold the same data in two places at...


    The opinions expressed herein are strictly personal and do not necessarily reflect the views or policies of my employer.

    July 30, 2013 at 6:51 am

    #1636955

  • RE: Function to return the fiscal month from a date. Fiscal year begins in October

    NineIron (7/26/2013)

    Then October, November and December would be 13, 14 and 15.

    No, the dateadd function takes care of that. October wraps around to January of the next year, then...


    The opinions expressed herein are strictly personal and do not necessarily reflect the views or policies of my employer.

    July 26, 2013 at 11:41 am

    #1636263

  • RE: Function to return the fiscal month from a date. Fiscal year begins in October

    NineIron (7/26/2013)

    I need a function that would return the fiscal month number from a date. Our fiscal year starts in October.

    Something like...

    declare @Date datetime

    if month(@Date)>9 then month(@Date) -9 else month(@Date)...


    The opinions expressed herein are strictly personal and do not necessarily reflect the views or policies of my employer.

    July 26, 2013 at 11:25 am

    #1636256

  • RE: Edit multiple stored procedures

    Elliott Whitlow (7/25/2013)

    LightVader (7/25/2013)

    Elliott Whitlow (7/24/2013)

    ...

    2. I have an article in the works that discusses NEVER using 3 part names in code and using synonyms to point to objects external...


    The opinions expressed herein are strictly personal and do not necessarily reflect the views or policies of my employer.

    July 25, 2013 at 9:37 am

    #1635791

  • RE: Edit multiple stored procedures

    Elliott Whitlow (7/24/2013)

    ...

    2. I have an article in the works that discusses NEVER using 3 part names in code and using synonyms to point to objects external to the local...


    The opinions expressed herein are strictly personal and do not necessarily reflect the views or policies of my employer.

    July 25, 2013 at 9:01 am

    #1635770

  • RE: Can I have a description witha parameter ?

    jbalbo (6/5/2013)

    Thanks for the quick reply

    But how do I assign one a value and one a label ?

    I have it setup to get avalable values from a query via dataset2...


    The opinions expressed herein are strictly personal and do not necessarily reflect the views or policies of my employer.

    June 6, 2013 at 6:42 am

    #1621710

  • RE: The best method for reading books

    For recreational reading, I love my kindle. For technical/learning, I prefer a physical book, much easier to search for certain information or reading the book non-sequentially.


    The opinions expressed herein are strictly personal and do not necessarily reflect the views or policies of my employer.

    May 31, 2013 at 7:34 am

    #1620071

  • RE: Report not working on Report Server

    Have you checked permissions on the table? I ran into this error yesterday and it was due to the fact that the SQL user we use to connect to...


    The opinions expressed herein are strictly personal and do not necessarily reflect the views or policies of my employer.

    May 29, 2013 at 7:27 am

    #1619279

  • RE: Permission by department manager from single report to view.

    nitin.lokhande (5/14/2013)

    Hi

    I am not expert but hard coding is not a good idea, tomorrw the coder leave and some new dept. to be included then what ??

    Copying the same report...


    The opinions expressed herein are strictly personal and do not necessarily reflect the views or policies of my employer.

    May 14, 2013 at 5:40 am

    #1614942

  • RE: Permission by department manager from single report to view.

    alex_martinez (5/11/2013)

    Hello,

    We are using SSRS 2005 and I have a report I want to give access to 5 different managers the report will be in a separate folders by department...


    The opinions expressed herein are strictly personal and do not necessarily reflect the views or policies of my employer.

    May 13, 2013 at 9:48 am

    #1614664

  • RE: Simple 'front ends' for non-developer?!

    drew.georgopulos (5/9/2013)

    Hi

    my instinct is Access would be best, but iirc, you can create parametrized stored procedures in SSMS & invoke them from Excel...i guess it depends on how robust the...


    The opinions expressed herein are strictly personal and do not necessarily reflect the views or policies of my employer.

    May 10, 2013 at 6:15 am

    #1614151

  • RE: The Vacation Dilemma

    I've taken the same week vacation almost all my life. Before I go, I'll take the time to document some of my regular responsibilities, the status of my projects,...


    The opinions expressed herein are strictly personal and do not necessarily reflect the views or policies of my employer.

    April 26, 2013 at 7:04 am

    #1610330

  • RE: Find Currently Running Scheduled Job

    I have a similar "job killer" task. I used sysjobs, sysjobactivity, and sysjobhistory (all in MSDB) to get the information about currently executing jobs. I also have a...


    The opinions expressed herein are strictly personal and do not necessarily reflect the views or policies of my employer.

    April 25, 2013 at 9:18 am

    #1609996

  • RE: A Tale of Broken BI

    george-975422 (10/27/2012)

    I had a similiar experience.

    A little explaination. In some states there are regulated electric suppliers (big utilities) where energy rates are set by the a state commission (not...


    The opinions expressed herein are strictly personal and do not necessarily reflect the views or policies of my employer.

    October 29, 2012 at 12:03 pm

    #1553850

Viewing 15 posts - 91 through 105 (of 161 total)