Forum Replies Created

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

  • RE: find string in another string

    As allready said, the splitter by Jef Modem is a very usefull tool in general and also for this situation.

    In the example below I have removed the spaces in the...

    February 11, 2016 at 9:41 am

    #1858078

  • RE: How do we get which tables / procedure / views / functions are not used more than 2 months?

    I do use the following 'BLOB' of code to 'track' usage. (Edit : Sorry, tables only).

    This is run repeatedly and shows the usage of tables between two calls.

    Here the code...

    February 11, 2016 at 6:43 am

    #1858001

  • RE: Help to get desired result from query

    Stix83 (2/11/2016)

    View 2 works great however view one is the issue.

    here is my joining statement:

    sELECT B.CONTACT AS CONTACT,

    B.MAIN AS PHONE,

    B.CELL AS CELL,

    B.DATE_OF_CONTACT AS...

    February 11, 2016 at 6:20 am

    #1857992

  • RE: SQL collations are different . Is it a problem ?

    WhiteLotus (2/10/2016)

    Hi Guys ,

    I am migrating database from server A to server B . The collation in Server A is SQL_latin1_general_CP1_CI_AS and server B is

    Latin1_General_CI_AS

    So the database from server...

    February 11, 2016 at 5:17 am

    #1857968

  • RE: Export and import.

    Steve Jones - SSC Editor (2/9/2016)

    For reference data, some people are trying to move towards something like MDS, which gives you a central place to store and get data from...

    February 11, 2016 at 2:06 am

    #1857935

  • RE: Convert a Date

    ChrisM@Work (1/25/2016)

    How can the code return incorrect results, Ben? Am I missing something here?

    The name of the month is language dependend. This often leads to trouble.

    When storing a date in...

    January 25, 2016 at 10:05 am

    #1854228

  • 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

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