Forum Replies Created

Viewing 15 posts - 241 through 255 (of 557 total)

  • RE: Stored procedures and Creating tables. (Problem).

    Steve Jones - SSC Editor (7/15/2016)

    It helps if you get more specific, then we can work on that solution, perhaps making it more general.

    At the moment I am in a...

    July 18, 2016 at 5:54 am

    #1890566

  • RE: Stored procedures and Creating tables. (Problem).

    GSquared (7/15/2016)

    If that's reasonably accurate, I recommend breaking the functionality up into multiple sub-procs. One proc that creates a table, one that does "process 1", etc. Then conditionally...

    July 15, 2016 at 10:25 am

    #1890365

  • RE: Replicate Vb/excel Formula to SQL 2008 - HULL Moving Average

    Whford (5/24/2016)[hr

    But this one calculation, I am just having a hard time wrapping my mind around. :ermm:

    Are you still looking for a solution ?

    What is the size of N ?

    What...

    June 7, 2016 at 3:05 am

    #1883516

  • RE: How to get output from a select to a file ?

    Jeff Moden (5/13/2016)Nah. No security breach. Not even a bad practice if it's limited to ...

    In general most practises do not form a security breach, provided that the...

    May 19, 2016 at 3:19 am

    #1880118

  • RE: How to get output from a select to a file ?

    sestell1 (5/13/2016)

    Interesting question.

    I've always used a combination of xp_cmdshell and bcp to move data to/from files within T-SQL.

    As said this poses a security 'breach'.

    You could also use OLE automation, but...

    May 13, 2016 at 10:07 am

    #1878968

  • RE: Processing strings.

    I am on leave right now, but still want to keep you posted with my progress.

    Tackled most of the problems using SQL (T-SQL) only. Processing speed is adequate for what...

    April 30, 2016 at 4:51 pm

    #1875773

  • RE: Processing strings.

    Jeff Moden (4/7/2016)

    As hardcore as I am about using T-SQL for database functionality, I'll readily admit that there are many things that need to be done outside of T-SQL and...

    April 11, 2016 at 10:10 am

    #1871196

  • RE: Processing strings.

    patrickmcginnis59 10839 (4/7/2016)

    was anybody able to get a tally table looking solution to work with the delimiter inside quotes exclusion? its obviously easy with a loop, but was curious about...

    April 7, 2016 at 8:18 am

    #1870513

  • RE: Processing strings.

    So there were a number of passionate replies.

    Thanks for the links in the passionate replies, they might lead to something usefull for me. But for me there is still the...

    April 7, 2016 at 3:32 am

    #1870376

  • RE: Processing strings.

    First of all thanks to all the contributors of this thread.

    Allthough this thread and all the links (and indirect links) is a bit overwelming.

    I have allready learned a lot and...

    April 4, 2016 at 3:58 am

    #1869434

  • RE: Processing strings.

    Jeff Moden (4/1/2016)

    Sachin Nandanwar (3/31/2016)

    Why would you want to do string processing using TSQL ? Please see the attached image. I wrote this in C# in less than 20 minutes.It...

    April 1, 2016 at 8:49 am

    #1869180

  • RE: Processing strings.

    As Promissed this is what I reached on Friday, but now cleaned.

    It is still not 'complete'.

    Known problems:

    Performance.

    In some situations where a string is started with a double qoute, this is...

    April 1, 2016 at 1:53 am

    #1869069

  • RE: Processing strings.

    Sachin Nandanwar (3/31/2016)

    Why would you want to do string processing using TSQL ? Please see the attached image. I wrote this in C# in less than 20 minutes.It can be...

    March 31, 2016 at 12:54 pm

    #1868990

  • RE: Processing strings.

    Eirikur Eiriksson (3/26/2016)

    Alan.B (3/25/2016)

    Are you really on SQL Server 2008? If you were using SQL 2012 this article would get you 90% there:

    http://www.sqlservercentral.com/articles/SQL+Server+2012/106903/%5B/url%5D

    I would say more like 99.99% there:-D

    😎

    The...

    March 31, 2016 at 2:16 am

    #1868770

  • RE: Processing strings.

    Luis Cazares (3/25/2016)

    It doesn't need to be a comma or a semicolon. You could use different control characters that are unlikely to be in any current text. Read the "Unlikely...

    March 25, 2016 at 6:47 pm

    #1867823

Viewing 15 posts - 241 through 255 (of 557 total)