Forum Replies Created

Viewing 15 posts - 5,866 through 5,880 (of 10,144 total)

  • RE: Crazy Interviews

    Stuart Davies (8/17/2012)

    ChrisM@Work (8/16/2012)

    Earlier this year I had an interview for a gig right next to Swindon station, a dream forty-minute commute compared with the two hours each way I’d...

    August 17, 2012 at 8:46 am

    #1527119

  • RE: Convert comma to single quotes

    sqlfriends@sql.com (8/17/2012)

    Hi Experts;

    Good Thanks for all support

    ChrisM : we don't have using any control to design this table.

    Thanks

    FAJ

    What you have there is an EAV (entity-attribute-value) table. Simple-talk (site currently...

    August 17, 2012 at 8:34 am

    #1527109

  • RE: Varchar Exceeding 8000 characters

    anthony.green (8/17/2012)

    Change the function to return varchar(max) and have a str of varchar(max)

    The function returns a maximum of 4757 characters (for a leap year). It's inefficient but works ok.

    Try measuring...

    August 17, 2012 at 8:02 am

    #1527092

  • RE: Why not processing any records further?

    Charmer (8/17/2012)

    ChrisM@Work (8/17/2012)

    Are you inserting new rows into a table or updating existing rows? It's not clear from your description.

    yes i am inserting new rows by taking all the rows...

    August 17, 2012 at 7:14 am

    #1527069

  • RE: Why not processing any records further?

    Are you inserting new rows into a table or updating existing rows? It's not clear from your description.

    August 17, 2012 at 6:40 am

    #1527056

  • RE: Convert comma to single quotes

    sqlfriends@sql.com (8/17/2012)

    Hi Experts:

    This is my table

    Condition ...

    August 17, 2012 at 6:38 am

    #1527054

  • RE: Need help with this query

    prads.cs (8/17/2012)

    Sorry guys for the trouble ... just figured out some crazy method :hehe:

    UPDATEtvLRF

    SETHasMultiple = 1

    FROM@tv_LicenseRenewalFee tvLRF

    INNER JOIN (SELECTGroupCode, MIN(SUBSTRING(ClassificationCode,3, LEN(ClassificationCode))) AS Number

    FROM@tv_LicenseRenewalFee

    WHEREGroupCode <> (

    SELECTGroupCode

    FROM@tv_LicenseRenewalFee

    WHEREHasMultiple = 1

    )

    GROUP BY GroupCode

    HAVING...

    August 17, 2012 at 5:28 am

    #1527029

  • RE: Does/can OUTPUT clause turn identity_insert on & off

    Eugene Elutin (8/17/2012)

    ...

    That will teach me to not try and answer questions before drinking coffee, thanks Chris.

    Seeing your avatar, I wouldn't think that you are great coffee-lover. Are you sure...

    August 17, 2012 at 4:30 am

    #1527013

  • RE: how to change the date value to null??

    HowardW (8/17/2012)

    This sounds a really simplistic question, but based on what you've said, it should just be:

    update xys set submitdate=NULL where id in ('1','2'.........'100')

    I feel I must be missing something...

    August 17, 2012 at 3:42 am

    #1526984

  • RE: how to change the date value to null??

    Lavanyasri (8/17/2012)

    hi ,

    I have a column with date datatype. i updated the column with some date like 02-02-2012 00.00.000 ,for 100 orders Now i want to change the...

    August 17, 2012 at 3:16 am

    #1526969

  • RE: Does/can OUTPUT clause turn identity_insert on & off

    Phil Parkin (8/17/2012)

    Missing something, I'm afraid.

    SELECT ... INTO

    always creates a new table. When it creates that table, uses the data types of the source columns, but not primary keys...

    August 17, 2012 at 2:55 am

    #1526958

  • RE: How to grab characters before and after a string

    Returning NULL if the delimiter isn't found simplifies the code considerably:

    SELECT

    [Room / Shelf],

    [Room] = LEFT([Room / Shelf], x.pos-1),

    [Shelf] = SUBSTRING([Room / Shelf], x.pos+1,8000)

    FROM @ChemInventory

    CROSS APPLY (

    SELECT NULLIF(CHARINDEX('/', [Room /...

    August 17, 2012 at 2:26 am

    #1526949

  • RE: Are the posted questions getting worse?

    dwain.c (8/16/2012)

    Lynn Pettis (8/16/2012)

    Here is one for the do not hire list.

    Or it could be the needs much training list.

    The quality of the hires will be roughly proportional to the...

    August 17, 2012 at 2:10 am

    #1526946

  • RE: Are the posted questions getting worse?

    Lynn Pettis (8/16/2012)

    ChrisM@Work (8/16/2012)

    Hi folks, this evening I’m collecting Symba from here: http://www.tvaw.org.uk/Adoption.htm. We’ve met already, he’s awesome.

    Not sure of the name though. Symba is a bit silly, it’s a...

    August 17, 2012 at 2:05 am

    #1526944

  • RE: Are the posted questions getting worse?

    SQLRNNR (8/16/2012)

    ChrisM@Work (8/16/2012)

    Hi folks, this evening I’m collecting Symba from here: http://www.tvaw.org.uk/Adoption.htm. We’ve met already, he’s awesome.

    Not sure of the name though. Symba is a bit silly, it’s a misspelling...

    August 17, 2012 at 2:04 am

    #1526943

Viewing 15 posts - 5,866 through 5,880 (of 10,144 total)