Forum Replies Created

Viewing 15 posts - 10,726 through 10,740 (of 15,381 total)

  • RE: Update based on last update

    robert.baird 2778 (9/14/2012)

    Hi all -

    I'm trying to run an update query based on the last time the update query was run.

    Ex:

    I run the query at 5pm (via a once every...

    September 14, 2012 at 12:43 pm

    #1538082

  • RE: Are the posted questions getting worse?

    GilaMonster (9/14/2012)

    SQL Kiwi (9/14/2012)

    GilaMonster (9/14/2012)

    SQL Kiwi (9/14/2012)

    Lynn Pettis (9/14/2012)

    Hey, any comments on what is posted here?

    My first reaction was, "LOL!". Posted a more serious comment.

    Thank you, you saved me...

    September 14, 2012 at 12:36 pm

    #1538079

  • RE: Using Print, will it slow down procedure?

    ScottPletcher (9/14/2012)

    Lynn Pettis (9/14/2012)

    /****** Object: UserDefinedFunction [dbo].[DelimitedSplit8K] Script Date: 09/14/2012 09:43:51 ******/

    IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[DelimitedSplit8K]') AND type in (N'FN',...

    September 14, 2012 at 10:26 am

    #1538016

  • RE: Calculating the total for the month

    ByronOne (9/14/2012)

    Hi Everyone

    I have a table in SQL Server that contains sales performance by items sold by the week i which they were sold. The only date field in...

    September 14, 2012 at 8:50 am

    #1537896

  • RE: Find specific words in a string

    This has a distinct feeling of being a dynamic sql version of a catch all query. Take a look at Gail's article about this here. http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/%5B/url%5D

    September 14, 2012 at 8:45 am

    #1537894

  • RE: Need to implement the Business rule row by row

    Saravanan_tvr (9/13/2012)

    Yes, We have a cross validations with 10 Master table then Update and Insertions based on the Logic. from excel one row at a time. as per the...

    September 14, 2012 at 8:00 am

    #1537843

  • RE: Select Case When

    Skanda (9/14/2012)

    Hi,

    am having two columns

    Usage, Expiration date.

    My requirement is : when "usage" column is blank "expiration_date" should not come in select,

    Am using below logic, but it is not working.

    select

    case...

    September 14, 2012 at 7:50 am

    #1537834

  • RE: SQL to create Timeslot Table between StartTime and Endtime of a day

    dwain.c (9/13/2012)

    Sean Lange (9/13/2012)

    ...some guy on the internet

    I think I'll change my board name. 🙂

    LOL by no means was any disrespect intended good sir. 😀 I of course would be...

    September 13, 2012 at 7:27 pm

    #1537601

  • RE: SQL Server nvarchar(max) fields are truncated

    valeryk2000 (9/13/2012)

    That may work short term but in the long run that is not going to survive. The text datatype has been deprecated and will be removed in the future.

    It...

    September 13, 2012 at 2:02 pm

    #1537464

  • RE: encrypt password in sql server database

    aaron.reese (9/13/2012)

    If you can't unencrypt it, is there any point in keeping it

    Yes, an example is in my original post; where you convert another value and compare the results. ...

    September 13, 2012 at 1:57 pm

    #1537460

  • RE: SQL to create Timeslot Table between StartTime and Endtime of a day

    sbk2007 (9/13/2012)

    Thanks so much, well I had already achieved the resultset yesterday (but with loop:)) urs worked liked a breeze without loop!!Thanks again..

    Important lesson here is that looping should be...

    September 13, 2012 at 1:48 pm

    #1537455

  • RE: Duplicate Records

    Sharon Kumar (9/13/2012)

    In this Ourid is having int values and Faclity having char values

    I want output where faclity is a and b having same our id column value

    eg: a=2

    ...

    September 13, 2012 at 1:46 pm

    #1537454

  • RE: Duplicate Records

    Sharon Kumar (9/13/2012)

    I have a table xtr

    OURIDFACLITY

    1A

    1b

    2C

    3D

    3b

    3A

    2A

    4B

    5B

    I want output like

    OURIDFACLITY

    1 A

    1 b

    3 ...

    September 13, 2012 at 1:24 pm

    #1537432

  • RE: GO Part 2

    joe.wolfe (9/13/2012)

    The given answer to this question is "true", but I am not sure this is correct. The "NotGo" throws an error "Incorrect syntax near 'NotGo'" and the variable @test-2...

    September 13, 2012 at 1:12 pm

    #1537428

  • RE: ODBC - connection to sublist failed.

    jane.frasier (9/13/2012)

    This is the first time that I have done this. I guess since on MY computer I setup an ODBC DSN and that worked, that for people using this...

    September 13, 2012 at 12:53 pm

    #1537418

Viewing 15 posts - 10,726 through 10,740 (of 15,381 total)