Forum Replies Created

Viewing 15 posts - 9,331 through 9,345 (of 15,381 total)

  • RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

    ahpitre (2/11/2013)

    How can I use this function to search for more than 1 character? I have data that is delimited by either a comma or semicolon (,;). Need to split...

    February 11, 2013 at 1:03 pm

    #1586725

  • RE: Want one values with similar ids

    I was going to take a shot in the dark because I thought I knew what you wanted but for ID 1 you have the value that was listed first...

    February 11, 2013 at 10:44 am

    #1586679

  • RE: Comparing figures based on relative date

    ChrisM@Work (2/11/2013)

    Paul Munter (2/11/2013)

    I'd like to be able to write a cursor of similar code which does this dynamically for me based on a data set that I have. So...

    February 11, 2013 at 8:46 am

    #1586619

  • RE: Comparing figures based on relative date

    Paul Munter (2/11/2013)

    Hi Sean, aplogies for the lack of standardisation I have updated my code sample in accordance with your post(hopefully)

    No problem. Now that you posted your sample data and...

    February 11, 2013 at 8:03 am

    #1586589

  • RE: Creating Tables

    (Bob Brown) (2/11/2013)

    sestell1 (2/11/2013)

    It's too bad about the wording issues, as otherwise this would have been a decent QotD.

    I think it was a pretty decent QotD. Approximately 2/3...

    February 11, 2013 at 7:51 am

    #1586576

  • RE: ExecuteNonQuery returns -1 even if rows are successfully inserted

    winmansoft (2/11/2013)

    I have am using ExecuteNonQuery to get number of rows inserted But i found that it returns -1 even though rows are successfully inserted.

    I am using simple insert statement.

    ExecuteUpdtCmdWithRetry...

    February 11, 2013 at 7:37 am

    #1586564

  • RE: Comparing figures based on relative date

    From what you have posted it is pretty much impossible to provide much of an answer. I don't think you need a cursor for this but it is hard to...

    February 11, 2013 at 7:28 am

    #1586551

  • RE: Dicommistion Database

    saidapurs (2/11/2013)

    Hi All,

    What are the step need to Decommision the database? Please explain me on this..

    Satish

    What...

    February 11, 2013 at 7:26 am

    #1586549

  • RE: Creating Tables

    I too had the same thought as Hugo. The single batch part threw me off so I figured that the OP must have been running the code as posted when...

    February 11, 2013 at 7:13 am

    #1586542

  • RE: Incorrect syntax near 'END'.

    This looks like it could use some rethinking. It looks like parent-child relationship or some sort. The logic is nearly impossible to follow but I think you could simplify this...

    February 8, 2013 at 10:52 am

    #1586076

  • RE: how to count in sql?

    asco5 (2/8/2013)

    Sean Lange (2/8/2013)

    asco5 (2/8/2013)

    thanks for the code its seem to works i just need to test it in a bigger database with more entry

    i want to ask if i...

    February 8, 2013 at 9:52 am

    #1586049

  • RE: Comparing two rows

    Johny.B (2/8/2013)

    Another solution that uses left join and a [ARE_THE_SAME] column to mark the columns having same values, you can modify the comparison logic based on ...

    February 8, 2013 at 9:43 am

    #1586044

  • RE: how to count in sql?

    asco5 (2/8/2013)

    thanks for the code its seem to works i just need to test it in a bigger database with more entry

    i want to ask if i have a lots...

    February 8, 2013 at 9:27 am

    #1586031

  • RE: Relationship between tables

    Wow that is quite a task for a newbie.

    Over on the left side of this site you will find a link called Stairways. There is an entire series on...

    February 8, 2013 at 8:13 am

    #1585985

  • RE: SQL query - data grouping help

    Use the SUM aggregate function.

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

    February 8, 2013 at 8:04 am

    #1585977

Viewing 15 posts - 9,331 through 9,345 (of 15,381 total)