Forum Replies Created

Viewing 15 posts - 5,806 through 5,820 (of 10,144 total)

  • RE: Split a name on to new columns in a table

    amarkhowe (8/28/2012)

    Thanks you for your reply!

    I do not want to drop the table but split the name on to the same table in new columns?

    That's just sample data.

    Change the...

    August 28, 2012 at 6:03 am

    #1530734

  • RE: replace

    elham_azizi_62 (8/28/2012)

    ...

    my string is parameter that fiil from one function and function returns '0,0,'',0,'',0'

    now how do i do?

    I can only guess what you are trying to say here, it makes...

    August 28, 2012 at 5:11 am

    #1530706

  • RE: replace

    elham_azizi_62 (8/28/2012)

    hello all.

    I have one string like this:'0,0,'',0,'',0' and i want to my result this:'0,null,'',0,'',0' please guide me how to do i do for this result?

    thanks

    No...

    August 28, 2012 at 4:35 am

    #1530685

  • RE: table sub division on sql server 2000

    raghuldrag (8/27/2012)

    table-1

    employee details

    ...

    August 28, 2012 at 4:05 am

    #1530668

  • RE: subdivision on output query in server 2000

    ChrisM@Work (8/28/2012)

    raghuldrag (8/28/2012)

    alter procedure Goals_history

    ...

    What version of SQL Server is your database?

    OP answered in a PM, he's using SQL Server 2000.

    Raghuldrag, please post in the SQL Server 7, 2000 forum...

    August 28, 2012 at 4:03 am

    #1530665

  • RE: subdivision on output query in server 2000

    raghuldrag (8/28/2012)

    alter procedure Goals_history

    ...

    What version of SQL Server is your database?

    August 28, 2012 at 3:52 am

    #1530663

  • RE: increment values on day basis on column

    Generating your own identity values isn't as straightforward as it might at first appear, the code for preventing concurrency issues is fairly complex. Why don't you use the identity column...

    August 28, 2012 at 3:18 am

    #1530648

  • RE: Split a name on to new columns in a table

    amarkhowe (8/28/2012)

    Monring,

    If I have a name all in one cell on a column such as

    "Mr Simon ASHWORTH"

    How can I split the name so that I could have Mr on...

    August 28, 2012 at 2:23 am

    #1530620

  • RE: Create view with no outer joins

    jdbrown239 (8/27/2012)

    Sorry for the initial messy post.

    I think you guys are right. I have tried writing the view without joins and the result set is never the same. I will...

    August 28, 2012 at 2:11 am

    #1530614

  • RE: Use Of TableValueConstructor

    TVC implies a set of row value expressions; single-row value expressions can be very useful, see this article [/url]by Dangler Dwain.

    August 24, 2012 at 9:58 am

    #1529835

  • RE: Tsql procedure to mutiple rows if it has duplicate id

    SQL Kiwi (8/24/2012)

    ChrisM@Work (8/24/2012)

    Try converting it to a read-only fast-forward cursor, and change

    WHERE CURRENT OF reader

    to an explicit UPDATE with a supporting index.

    I didn't write it for performance (it's...

    August 24, 2012 at 9:28 am

    #1529812

  • RE: Tsql procedure to mutiple rows if it has duplicate id

    Luis Cazares (8/24/2012)

    After several runs (with consistent results) that might not be enough to prove something real. I found out that the explicit RBAR (from Paul) beated the hidden RBAR...

    August 24, 2012 at 8:35 am

    #1529769

  • RE: Substrating the columns from two queries

    dwain.c (8/24/2012)

    Grant Fritchey (8/24/2012)

    Jeff Moden (8/23/2012)

    ChrisM@Work (8/23/2012)

    Brandie Tarvin (8/23/2012)

    ... Tootsie Rolls...

    Are we back on Clinton??

    It Depends... are you wearing a blue dress? :-):-D:-P:hehe:

    I thought we had an agreement. You wear...

    August 24, 2012 at 6:31 am

    #1529682

  • RE: Substrating the columns from two queries

    Shadab Shah (8/23/2012)

    Hi,

    I have one query as SELECT A FROM TEMP1.

    And the other query as SELECT B FROM TEMP2.

    Now i want the answer to be shown as A-B.

    I don't know...

    August 24, 2012 at 6:03 am

    #1529675

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

    SQL Kiwi (8/24/2012)

    ChrisM@Work (8/24/2012)

    It looks to me that APPLY evaluates the row where Stringy = NULL and returns NULL, which is subsequently retained by OUTER APPLY and discarded by CROSS...

    August 24, 2012 at 5:57 am

    #1529673

Viewing 15 posts - 5,806 through 5,820 (of 10,144 total)