Forum Replies Created

Viewing 15 posts - 796 through 810 (of 3,221 total)

  • RE: Using SP_

    Jeff Moden (12/14/2011)

    BWAA-HAAA!!! Judging by the fact that more people got the wrong answer than the correct one, I'd say you just taught a whole bunch of people a...

    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]

    December 14, 2011 at 7:10 pm

    #1421700

  • RE: Are the posted questions getting worse?

    SQLRNNR (12/14/2011)

    Jim Murphy (12/14/2011)

    Steve Jones - SSC Editor (12/14/2011)

    SQLRNNR (12/14/2011)

    Steve Jones - SSC Editor (12/13/2011)

    SQLRNNR (12/13/2011)

    About due for a Pantsectomy :-D:-D:-D:-D

    40F in Denver, no need for pants today.:-P

    Just as long...

    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]

    December 14, 2011 at 2:34 pm

    #1421627

  • RE: Using SP_

    Nice question Ron.

    Have we made a case for sp_Tally?

    Put my Tally table into the model DB so it now appears in any new DB created

    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]

    December 14, 2011 at 1:20 pm

    #1421575

  • RE: Access to SQL Server conversion

    These items might assist you in deciding on the migration

    http://www.microsoft.com/sqlserver/en/us/product-info/migration-tool.aspx#oracle

    http://office.microsoft.com/en-us/access-help/move-access-data-to-a-sql-server-database-by-using-the-upsizing-wizard-HA010275537.aspx

    http://blog.nkadesign.com/2009/ms-access-upsizing-to-sql-server-2008/

    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]

    December 14, 2011 at 8:49 am

    #1421379

  • RE: Sorting triggered by data type

    Nice question learned something today - thanks

    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]

    December 12, 2011 at 9:05 pm

    #1420336

  • RE: Are the posted questions getting worse?

    LutzM (12/12/2011)

    Evil Kraig F (12/12/2011)

    ...

    Nah, he used the front portion of the crown. It's about the hardest portion of your body, he's fine. I've done that a few...

    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]

    December 12, 2011 at 7:33 pm

    #1420330

  • RE: Is dynamic SQL the only route to SQL injection?

    In addition to the two answers above you may want to read

    http://msdn.microsoft.com/en-us/library/ms161953.aspx

    The above contains some sample injection attack methods and examples.

    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]

    December 12, 2011 at 6:06 pm

    #1420321

  • RE: how different could it be joining a #temp_table Vs @table_variable?

    You may also want to look at this:

    http://blogs.msdn.com/b/sqlcat/archive/2008/10/09/table-variable-vs-temp-table-and-estimated-vs-actual-query-plan.aspx

    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]

    December 12, 2011 at 5:36 pm

    #1420315

  • RE: Are the posted questions getting worse?

    WayneS (12/12/2011)

    jcrawf02 (12/12/2011)

    WayneS (12/9/2011)

    Hmmm. I think I just found a bug in SQL 2012 - one of the new Analytic functions returns a different value when called from within a...

    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]

    December 12, 2011 at 9:46 am

    #1420162

  • RE: Combine two tables with duplicate records and show latest date

    chie0286 (12/11/2011)

    Thank you very much Sir!

    Heck - glad I could be of assistamce ...

    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]

    December 11, 2011 at 7:55 pm

    #1419845

  • RE: Combine two tables with duplicate records and show latest date

    Is this what you require

    CREATE TABLE #Car_User_Log(CarNo VARCHAR(6), Driver VARCHAR(20), UsedDate smalldatetime)

    INSERT INTO #Car_User_Log

    SELECT 'Car1', 'Neil','12/9/2011' UNION ALL

    SELECT 'Car1', 'Don','12/10/2011' UNION ALL

    SELECT 'Car2', 'Ramon','12/9/2011' UNION ALL

    SELECT 'Car2', 'Sherwood','12/10/2011' UNION ALL

    SELECT...

    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]

    December 11, 2011 at 6:47 pm

    #1419839

  • RE: Current Lsn Number for user database and system database

    LSN is normally the Log Sequence Number and you can read about that here:

    http://msdn.microsoft.com/en-us/library/ms190411.aspx

    If you mean the databse ID number read about it here:

    http://msdn.microsoft.com/en-us/library/ms186274.aspx

    Now if you really mean Database ID...

    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]

    December 11, 2011 at 5:34 pm

    #1419838

  • RE: Wjat would be a good supplmental skill to SQL server

    Jeff Moden (12/11/2011)

    bitbucket-25253 (12/10/2011)

    If you are not completely committed to IT .. and I mean COMPLETELY, then I would suggest taking a college or graduate school course leading to a...

    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]

    December 11, 2011 at 11:43 am

    #1419825

  • RE: Wjat would be a good supplmental skill to SQL server

    If you are not completely committed to IT .. and I mean COMPLETELY, then I would suggest taking a college or graduate school course leading to a degree, and/or a...

    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]

    December 10, 2011 at 8:26 pm

    #1419773

  • RE: Variant Order 3

    Hmmm Not wanting to give away the reasoning utilized to determine the correct answer I am posting this comment - so as to receive automatic notifications of additions to the...

    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]

    December 10, 2011 at 8:10 pm

    #1419771

Viewing 15 posts - 796 through 810 (of 3,221 total)