Forum Replies Created

Viewing 15 posts - 4,261 through 4,275 (of 5,590 total)

  • RE: Stored Procedure Cursors

    Marv-1058651 (4/28/2010)

    I am executing a cursor that is taking about 40 seconds to insert into a temp table. When I execute the sql as a new query, the results are...

    April 28, 2010 at 2:18 pm

    #1159283

  • RE: How to SUM on a filtered group?

    You know, the people that help out here are all un-paid volunteers. Providing the DDL scripts (CREATE TABLE, CREATE INDEX, etc.) for the tables affected, and INSERT statements to put...

    April 28, 2010 at 2:08 pm

    #1159280

  • RE: SQL Server gets confused, insert instead update

    PSSQL (4/28/2010)

    What I can not understand is if the record is found, why the error is telling about an Insert, that I am not using at all.

    Probably because, behind the...

    April 28, 2010 at 9:48 am

    #1159081

  • RE: full text search to match pipe separated data

    SandeepGupta (4/28/2010)

    I have a column with datatype nVarchar which contains pipe separated data like 1|10|11|5|4.

    Is there any way to match exact number(s) using full text search or any other way?

    If...

    April 28, 2010 at 9:35 am

    #1159059

  • RE: Missing numbers in a series

    Raj.. (4/28/2010)

    I have the data like 1,2,4,5,7,8,11,12,13,15,17,19,20. How to find the missing numbers in the series?

    Please help me

    Thanks in advance..!!

    Raj,

    Since you are showing a comma-delimited list, this solution will...

    April 28, 2010 at 9:24 am

    #1159051

  • RE: Are the posted questions getting worse?

    Does anyone happen to know where a Microsoft reference exists that defines the XML index structures in SQL 2008? I'm looking for both the Primary and Secondary XML index structures.

    For...

    April 27, 2010 at 9:03 pm

    #1158623

  • RE: Special Grouping with ROW_NUMBER

    I think I'm going to have to start forcing myself to try using CROSS APPLY until I get the hang of it.

    April 27, 2010 at 6:07 pm

    #1158599

  • RE: Date Periods

    jrizzo-1083740 (4/27/2010)

    Thanks Wayne,

    Got it to work.

    Great!

    April 27, 2010 at 3:09 pm

    #1158536

  • RE: Are the posted questions getting worse?

    Lynn Pettis (4/27/2010)

    Don't know, but as the forum indicates he is still logged on, I hope I didn't scare away this OP.

    Just asked for what we always ask for in...

    April 27, 2010 at 1:38 pm

    #1158472

  • RE: Are the posted questions getting worse?

    Lynn Pettis (4/27/2010)

    Don't know, but as the forum indicates he is still logged on, I hope I didn't scare away this OP.

    Just asked for what we always ask for in...

    April 27, 2010 at 1:38 pm

    #1158471

  • RE: Date Periods

    jrizzo-1083740 (4/27/2010)

    Hello I am a newbie so please keep the beatings to a min.

    I already have the SP working but I can only use specific dates and not the Year...

    April 27, 2010 at 12:59 pm

    #1158438

  • RE: Issues with finding MIN value in join.

    Since we're having troubles helping you out, I'd like to suggest that you provide us with the CREATE TABLE statements for your tables, INSERT statements for some sample data, and...

    April 27, 2010 at 12:54 pm

    #1158435

  • RE: Adding StartDate and EndDate to WHERE Clause of a StoredProcedure

    brian.cook (4/27/2010)

    Hi, I have a stored procedure that currenly has one parameter in it. I want to add a @StartDate, and an @EndDate parameter to it, however I am unsure...

    April 27, 2010 at 7:34 am

    #1158211

  • RE: DateTime

    I was a little bit disappointed that the answer went into how a datatime data type is stored in two ints, and did not discuss why "1" = "1900-01-02".

    April 27, 2010 at 7:17 am

    #1158192

  • RE: Finding previous record based on a single common field.

    mister.magoo (4/23/2010)

    Here you go...Wayne had it just about right, but missed the sort order reversal required...

    mister.magoo, thanks for catching this.

    April 26, 2010 at 1:17 pm

    #1157831

Viewing 15 posts - 4,261 through 4,275 (of 5,590 total)