Forum Replies Created

Viewing 15 posts - 61 through 75 (of 107 total)

  • RE: BCP upload from a txt file

    David Burrows - Monday, August 7, 2017 5:46 AM

    That is what is causing the error, either remove the spaces or put quotes...

  • RE: BCP upload from a txt file

    David Burrows - Monday, August 7, 2017 4:39 AM

    As a guess, if you posted part of the file you are using, I would...

  • RE: BCP upload from a txt file

    Hi David. That's a wonderful solution to get results with where clause. However i an stuck at a situation. The number of columns in data file and in format file...

  • RE: Formatting in HTML table

    Thom A - Wednesday, July 19, 2017 4:30 AM

    sqlenthu 89358 - Wednesday, July 19, 2017 4:17 AM

  • RE: Formatting in HTML table

    Thom A - Wednesday, July 19, 2017 2:34 AM

    sqlenthu 89358 - Wednesday, July 19, 2017 2:29 AM

  • RE: Formatting in HTML table

    Thom A - Wednesday, July 19, 2017 1:46 AM

    sqlenthu 89358 - Wednesday, July 19, 2017 1:42 AM

  • RE: Formatting in HTML table

    Thom A - Tuesday, July 18, 2017 5:31 AM

    sqlenthu 89358 - Tuesday, July 18, 2017 5:09 AM

  • RE: Formatting in HTML table

    Lowell - Tuesday, July 18, 2017 5:20 AM

    sqlenthu 89358 - Tuesday, July 18, 2017 5:05 AM

    July 18, 2017 at 8:15 am

    #1951407

  • RE: Formatting in HTML table

    Thom A - Monday, July 17, 2017 6:10 AM

    This should do the job:
    CREATE TABLE #Sample
      (cobdate date,
      TradingType varchar(10),
     ...

  • RE: Formatting in HTML table

    Lowell - Monday, July 17, 2017 6:27 AM

    For the RevenueAmt, if the datatype is MONEY, the convert function has an additional parameter...

  • RE: Designing and Architecture

    Thanks for the insight Grant. We have two new prod servers in one location and two DR servers in another location. We have rto of 2 hours and rpo is...

  • RE: Tsql Query help

    Jeff Moden - Thursday, June 22, 2017 7:45 AM

    sqlenthu 89358 - Wednesday, June 21, 2017 9:34 PM

  • RE: Tsql Query help

    Thanks Jeff. Very helpful and interesting.

  • RE: Tsql Query help

    Thom, both urs and Luis' query gave me a fair idea of how I should start. However the table gets populated on daily basis and the report is needed on...

  • RE: Tsql Query help

    Thanks to both of you guys. However there is no limited number of Org_ids. It can vary and change from time to time.
    In between, I replied many hours back...

Viewing 15 posts - 61 through 75 (of 107 total)