Forum Replies Created

Viewing 15 posts - 136 through 150 (of 3,666 total)

  • RE: Are the posted questions getting worse?

    Happy New Year everyone!!!

    I hope that 2015 was a good year for everyone and that 2016 will be an even better year.

    December 31, 2015 at 8:04 am

    #1848938

  • RE: how does datatypes get set when using select into in sql server?

    dndaughtery (12/30/2015)

    I used a select...into to create a staging table. Its been fine but lastnight I got a truncation error. I was under the "Assumption" that sql server looked at...

    December 30, 2015 at 7:54 am

    #1848753

  • RE: How to remove minutes and seconds from DateTime?

    Got a bit messier than I was hoping for:

    SELECT DATEADD(Hour, DATEPART(hour, GETDATE()), CAST(CAST(GETDATE() AS DATE) AS DATETIME))

    December 29, 2015 at 1:56 pm

    #1848626

  • RE: Other Tools to Develop SSIS Package

    Eric M Russell (12/29/2015)

    At a bare minimum, all you need is Notepad, but the free SSDT tool provided by Microsoft provides some nice to have features too.

    Eric, if you're gonna...

    December 29, 2015 at 11:48 am

    #1848585

  • RE: Are the posted questions getting worse?

    Phil Parkin (12/29/2015)

    Eirikur Eiriksson (12/29/2015)

    Phil Parkin (12/29/2015)

    Eirikur Eiriksson (12/29/2015)

    Phil Parkin (12/29/2015)

    Grant Fritchey (12/29/2015)

    Eirikur Eiriksson (12/29/2015)

    I really appreciate the effort of those who write the articles posted on this site but...

    December 29, 2015 at 11:25 am

    #1848579

  • RE: Other Tools to Develop SSIS Package

    pietlinden (12/29/2015)

    Do you have SQL Server Data Tools? It's not a full version of Visual Studio. That's enough to do SSIS.

    That's not "enough" for SSIS. That is EXACTLY what...

    December 29, 2015 at 11:14 am

    #1848576

  • RE: Where Do Staging Tables Belong

    Orlando Colamatteo (12/29/2015)

    I have had people scoff at running staging databases in FULL, taking backups and including them in Availability Groups and have had people scoff at running them in...

    December 29, 2015 at 10:37 am

    #1848561

  • RE: Are the posted questions getting worse?

    djj (12/29/2015)

    Michael L John (12/29/2015)

    The Detroit area is actually not nearly as bad as people may think, and, Michigan in general is a pretty nice place.

    Plus, you can...

    December 29, 2015 at 9:56 am

    #1848546

  • RE: How to read Folder Names in SSIS

    Phil Parkin (12/28/2015)

    Have you also considered using a script task? It might be the most elegant solution in this case.

    Agree.

    Use a script task and save the script where you...

    December 28, 2015 at 8:26 am

    #1848269

  • RE: Byte Me: Private Cloud

    Eric M Russell (12/23/2015)

    Alvin Ramard (12/23/2015)

    Eric M Russell (12/23/2015)

    Putting your data in the cloud: that's then you save a backup to external disk, and then have it boosted up the...

    December 23, 2015 at 9:23 am

    #1847789

  • RE: Byte Me: Private Cloud

    Eric M Russell (12/23/2015)

    Putting your data in the cloud: that's then you save a backup to external disk, and then have it boosted up the Space Station for safe keeping;...

    December 23, 2015 at 8:29 am

    #1847771

  • RE: Byte Me: Private Cloud

    Ed Wagner (12/23/2015)

    mjh 45389 (12/23/2015)

    Eric M Russell (12/23/2015)

    Eric M Russell (12/23/2015)

    mjh 45389 (12/23/2015)

    I was in a shop at the weekend and they were selling external hard drives as 'Private Clouds'!...

    December 23, 2015 at 8:05 am

    #1847754

  • RE: Are the posted questions getting worse?

    WayneS (12/23/2015)

    Brandie Tarvin (12/23/2015)

    Here's my QOTD:

    If it is Christmas, but you don't celebrate, does the tannenbaum still sing carols to the yule log during the Hanukkah code camp?

    now that depends...

    December 23, 2015 at 7:52 am

    #1847742

  • RE: Select the rows that has only numeric data in varchar field

    gsc_dba (12/23/2015)

    Very slick solution Sean, kudos!

    Slick, but definitely not what the OP was asking for. The OP clearly said he wanted to select the values where ZIP was numeric...

    December 23, 2015 at 7:51 am

    #1847740

  • RE: Are the posted questions getting worse?

    Phil Parkin (12/22/2015)

    Sean Lange (12/22/2015)

    Phil Parkin (12/22/2015)

    It seems that everyone in this thread spends their spare time shooting things :exclamationmark::-D

    I prefer making sawdust as my form of therapy.

    Plugging in my...

    December 22, 2015 at 7:34 am

    #1847449

Viewing 15 posts - 136 through 150 (of 3,666 total)