Forum Replies Created

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

  • RE: Set Date based on day of Month

    spaghettidba (7/21/2016)

    Dates have no format when they are stored in the database

    Dates definitively have a format when they are stored in the database.

    This format partly determines what you can do...

    July 21, 2016 at 8:52 am

    #1891352

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

    GSquared (7/20/2016)

    I built something very similar, but it uses XML instead of EAV, and NULLs out empty columns. Used less space and XML parsing was faster than EAV reconstitution....

    July 21, 2016 at 6:27 am

    #1891289

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

    Sergiy (7/19/2016)

    Been there, done that.

    Exactly that.

    So then I have some questions, because I am still strugling with parts of the code.

    How do you handle EOL within fields? (Or a bit...

    July 21, 2016 at 6:12 am

    #1891284

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

    GSquared (7/19/2016)

    How are you doing the CSV imports? OpenRowset? Linked servers? BCP?

    For most of those, you need to have the file definition already in-place.

    If you're pulling data...

    July 19, 2016 at 10:03 am

    #1890902

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

    Sergiy (7/19/2016)

    Because it's not a single-user environment.

    Because a process can be delayed, another file can arrive before the previous one is done.

    Because - see your starting topic.

    You listed there several...

    July 19, 2016 at 9:41 am

    #1890895

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

    Sergiy (7/18/2016)

    Create and delete static tables on fly is one of the worst possible ways to do things in SQL Server.

    Why ?

    One of the obvious ones - create static tables...

    July 19, 2016 at 2:39 am

    #1890786

  • 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

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