Forum Replies Created

Viewing 15 posts - 391 through 405 (of 3,221 total)

  • RE: sql server2008 query- To split the delimited values in the table ibnto multiple rows

    I would suggest reading Jeff Moden's aticle here on SSC at:

    http://www.sqlservercentral.com/articles/Tally+Table/72993/

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

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    July 6, 2012 at 11:12 am

    #1509812

  • RE: SQl server2008-split delimited values into three rows

    I would suggest reading Jeff Moden's aticle here on SSC at:

    http://www.sqlservercentral.com/articles/Tally+Table/72993/

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

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    July 6, 2012 at 11:06 am

    #1509809

  • RE: Tsql

    eboucicaut (7/6/2012)

    someone can help me please

    Could not open FCB for invalid file ID 3 in database

    Rather hard to assist you ... what were you attempting to do execute a T-SQL...

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

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    July 6, 2012 at 10:36 am

    #1509791

  • RE: HI all . Glad to see you all . Need guidance :)

    Brandie Tarvin (7/6/2012)

    One thing I strongly advise: Do not take this career path just for the possibility of high pay. If you do not like what you are doing, then...

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

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    July 6, 2012 at 9:30 am

    #1509767

  • RE: Execs and temporary tables

    Emphasis (bolding) added by this poster

    BrainDonor (7/6/2012)

    That explanation requires expanding slightly, because there is more than one type of temporary table.

    Local temporary tables (prefixes with '#') go out of...

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

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    July 6, 2012 at 8:12 am

    #1509711

  • RE: Calendar For the Fiscal Year

    Excellent article here on SSC

    4-4-5 Calendar Functions, Part 1

    By Cliff Corder, 2010/09/06 (first published: 2009/09/28)

    http://www.sqlservercentral.com/articles/function/67046/

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

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    July 5, 2012 at 5:46 am

    #1509051

  • RE: Index Types

    Correct answers:

    1%

    (1)

    Incorrect answers:

    99%

    (113)

    Total attempts: 114

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

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    July 5, 2012 at 5:28 am

    #1509046

  • RE: HI all . Glad to see you all . Need guidance :)

    And i want to know the difference between DBA and database developer . who plays the vital role and important role(highly paid salary) , DBA or database developer ?

    ...

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

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    July 4, 2012 at 1:20 pm

    #1508861

  • RE: Are the posted questions getting worse?

    GilaMonster (7/3/2012)

    For anyone not on/not paying attention to twitter.....

    It seems to be official.... I'm a Microsoft Certified Master for SQL Server 2008.

    https://twitter.com/SQLintheWild/statuses/220252281847808001

    CONGRATULATIONS

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

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    July 3, 2012 at 3:34 pm

    #1508519

  • RE: Conditional Formatting of Date Parameter

    I would use something like this

    DECLARE @T1 DATETIME

    DECLARE @T2 DATETIME

    SET @T1 = '7/02/2012' | The 2 parameters passed to your T-SQL statement

    SET...

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

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    July 2, 2012 at 10:07 pm

    #1508011

  • RE: Conditional Formatting of Date Parameter

    Use the DATEDIFF function - check it out on Books On Line (BOL) or read this:

    http://msdn.microsoft.com/en-us/library/ms186724.aspx#GetDateandTimeDifference

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

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    July 2, 2012 at 7:14 pm

    #1507991

  • RE: inserting unknown row to dimesion table

    You are close to your problem, unfortunately we are not. Could you give us the pertinent table definition(s), some sample data and your desired results in a readily consumable...

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

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    June 29, 2012 at 5:46 pm

    #1507385

  • RE: Transaction

    Koen Verbeeck (6/29/2012)

    Ron's series on transactions led me to believe it should be 2. 🙂

    Got it wrong, but definately learned something. Good question!

    (3 wrong in a row, this is not...

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

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    June 29, 2012 at 5:34 am

    #1507056

  • RE: Transaction

    oops

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

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    June 28, 2012 at 8:14 pm

    #1506918

  • RE: How to migrate SQL 2000 Stored Procedures and Views to SQL 2008

    First step I would take, and have taken is to run the upgrade advisor available at:

    http://www.microsoft.com/en-us/download/details.aspx?id=11455

    then do what has to be done.

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

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    June 28, 2012 at 1:39 pm

    #1506818

Viewing 15 posts - 391 through 405 (of 3,221 total)