Forum Replies Created

Viewing 15 posts - 286 through 300 (of 557 total)

  • RE: Convert a Date

    Luis Cazares (1/25/2016)

    the problem often relies on keeping the default (us_english)

    I do strongly object to the notion that the default language is English.

    I know in almost all science fictions...

    January 25, 2016 at 9:58 am

    #1854225

  • RE: Smartway update statement

    asita (1/24/2016)

    Hello

    Can you please let me know the smart way of doing this? (below three statements into simple one statement) please help me

    UPDATE dbo.ClnTrail

    SET trailproposed_Weekno = '01 - 01/01/2016'...

    January 25, 2016 at 9:23 am

    #1854208

  • RE: Create Text File from SELECT

    TSQL Tryer (1/25/2016)

    Hi,

    How do I get the header at the top of the file in a Select statement -

    select '"BEN_CLAIM" "3P_RENT"' ,'','','',0,'' -- Same number...

    January 25, 2016 at 9:11 am

    #1854202

  • RE: Convert a Date

    Luis Cazares (1/25/2016)

    Another option:

    SELECT UPPER( REPLACE( CONVERT(char(11), GETDATE(), 106), ' ', '-'))

    Be carefull with dates, very often the language or the regional settings are important.

    For the solution of Luis (our...

    January 25, 2016 at 8:54 am

    #1854192

  • RE: Split row data to multiple columns

    A solution could be:

    SELECT

    listpos

    , substring(str,1, PATINDEX ( '%:%' , str )-1) str

    , substring(str, PATINDEX...

    January 21, 2016 at 9:58 am

    #1853548

  • RE: How to select 200k data faster in sql

    Grant Fritchey (12/10/2015)

    A single SELECT statement without any kind of filtering offers very little in the way of query tuning. A scan is the best way to access the data...

    December 10, 2015 at 8:03 am

    #1845226

  • RE: How to select 200k data faster in sql

    select '"'+Word+'",' +' ' from Dictionary order by Word asc FOR XML PATH('')

    My expectation is that this will work a lot faster.

    Please do share...

    December 10, 2015 at 7:29 am

    #1845213

  • RE: how extract values from expressions

    Search on the forum for:

    DelimitedSplit8K

    Recipe:

    Replace all chars/strings which are not a value with an 'X', or another character which is not used.

    Use the DelimitedSplit8K function to split the string into...

    December 10, 2015 at 6:47 am

    #1845193

  • RE: How to update rows faster

    rhans (12/9/2015)

    Hi Guys,

    Need help from SQL experts for my scenario. I have a Inventory table that has:

    - 2 million current month transactions

    - 38 million for previous months translations

    I...

    December 10, 2015 at 6:19 am

    #1845177

  • RE: Using convert function in create table statement

    Excel

    hours:minutes:seconds yyyy-mm-dd (hh:mm) float (days)

    24:00:00 ...

    December 10, 2015 at 5:51 am

    #1845166

  • RE: Using convert function in create table statement

    pwalter83 (12/8/2015)

    ben.brugman (12/8/2015)

    pwalter83 (12/8/2015)

    Upon assigning the datetime datatype to SQL, the issue still is not resolved as now if the value in EXCEL is 885:39:35 it is displayed as '1900-02-05...

    December 8, 2015 at 11:58 am

    #1844746

  • RE: Using convert function in create table statement

    pwalter83 (12/8/2015)

    Upon assigning the datetime datatype to SQL, the issue still is not resolved as now if the value in EXCEL is 885:39:35 it is displayed as '1900-02-05 21:39:35' in...

    December 8, 2015 at 10:12 am

    #1844721

  • RE: Using convert function in create table statement

    But you are still missing the point.

    The datatype in Excel does NOT vary. (ONLY the format is different).

    What is important is the datatype of the field in SQL-server. (Again not...

    December 8, 2015 at 9:48 am

    #1844711

  • RE: Using convert function in create table statement

    Excel

    format display

    :mm:ss ...

    December 8, 2015 at 9:16 am

    #1844699

  • RE: Using convert function in create table statement

    pwalter83 (12/8/2015)

    Thanks for your suggestion. However, it still doesn't help with my basic requirement. I have to convert the time duration column in excel specifically where values like 100:20:30 exist.

    What...

    December 8, 2015 at 7:59 am

    #1844659

Viewing 15 posts - 286 through 300 (of 557 total)