Forum Replies Created

Viewing 15 posts - 3,361 through 3,375 (of 6,486 total)

  • RE: Question about ORDER BY

    FerasGer83 (5/11/2008)

    When we use INSERT SELECT statement, why can't we order the rows before inserting them in the specified table?

    what's the logic from that?

    Regards

    If the table you are inserting into...

    May 11, 2008 at 10:10 am

    #813556

  • RE: A Simple Mistake

    troyehall (5/10/2008)

    To remove the expressiveness enabled by case sensitivity because some people can't deal with the consequences makes as little sense as restricting handguns from responsible, law-abiding adults because irresponsible...

    May 10, 2008 at 1:24 pm

    #813495

  • RE: SQLCLR Web Service

    I think you might be running into a straight resource issue. CLR functions can't (as far as I know - I haven't been able to make this work) tap into...

    May 9, 2008 at 6:36 pm

    #813417

  • RE: How can I unencrypted a stored procedure

    Have you tried turning on profiler and running the procedure?

    Often enough - Profiler will capture the unencrypted version of the procedure. No fuss, no muss.

    May 9, 2008 at 6:17 pm

    #813414

  • RE: search time ~18 seconds in a 5Gb DB

    achaudhr (5/9/2008)

    I have a database whose size increased from like 28000 records to 800K records ansd searching in this database takes about 18 seconds which is not a pleasure, can...

    May 9, 2008 at 6:14 pm

    #813413

  • RE: Lookup Data in DB

    It IS a scary thing with that many rows - but SSIS seems to manage pretty well anyway.

    Glad it helped. Let us know if you need something else!

    May 9, 2008 at 6:12 pm

    #813412

  • RE: Complex query design

    JReed - help us help you...

    Read this and see if you can give us some specifics as is decribed in the article:

    http://www.sqlservercentral.com/articles/Best+Practices/61537/%5B/url%5D

    May 9, 2008 at 6:10 pm

    #813411

  • RE: SQL Script

    Henry - was there a question lurking in there somewhere?

    May 9, 2008 at 6:07 pm

    #813410

  • RE: SET @@IDENTITY OFF ?????

    rbarryyoung (5/9/2008)

    Matt Miller (5/9/2008)

    kevin mann (5/9/2008)

    Why the prohibition from using SCOPE_IDENTITY (which would be your solution in this case)?

    I don't know... ask the authors of Access. I cannot control...

    May 9, 2008 at 5:17 pm

    #813395

  • RE: Changing the seed and increment values on the identity column

    SQL ORACLE (5/9/2008)

    I got the same error. It seems that we cannot do it in either SQL 2000 or SQL 2005, although in BOL claims we can do it in...

    May 9, 2008 at 3:04 pm

    #813371

  • RE: Can this be done without a cursor?

    Tim OPry (5/9/2008)

    Thanks again - but still no joy. The join fails - should it not have a comparative after patindex, but even when I added somethingn it cannot match...

    May 9, 2008 at 2:47 pm

    #813362

  • RE: Can this be done without a cursor?

    Tim OPry (5/9/2008)

    Thank you for the suggestion, but both return: "Incorrect syntax near 'kw'.", pointing to the line with the CONTAINS keyword.

    I haven't been able to create a join using...

    May 9, 2008 at 1:38 pm

    #813329

  • RE: Can this be done without a cursor?

    Tim OPry (5/9/2008)

    I am searching a single TEXT column for 25+ keywords and I need to return the recordID and the matching keyword.

    A portion of the current query:

    Declare @Results table(Keyword...

    May 9, 2008 at 12:00 pm

    #813286

  • RE: Query by Year

    gtan018 (5/9/2008)

    I copied the codes you provided and got the following error message:

    Must declare the scalar variable "@year"

    Thanks for your help.

    You must not have copied something right - my variable...

    May 9, 2008 at 11:51 am

    #813275

  • RE: Accessing Named Instances

    Ashley Fawcett-Jones (5/9/2008)

    Yes, I did that. Any more ideas? Thanks for the swift response.

    Hmm - I didn't have to work that hard at it. three separate Cluster groups, each...

    May 9, 2008 at 11:48 am

    #813274

Viewing 15 posts - 3,361 through 3,375 (of 6,486 total)