Forum Replies Created

Viewing 15 posts - 166 through 180 (of 3,544 total)

  • Reply To: What is wrong with my code?

    below86 wrote:

    when I drop a column name like Policy_Type into the report, SSRS is smart enough to replace the underscore with a space for the column name on the report.

    Actually...

    Far away is close at hand in the images of elsewhere.
    Anon.

    July 25, 2019 at 8:28 am

    #3665967

  • Reply To: full text search

    Jeff Moden wrote:

    Sailor wrote:

    Ahh, yes the table does have a full text definition.  It's just not finding   A00J010002158.  If I do like '%A00J010002158', it finds it.  But that is very slow....

    Far away is close at hand in the images of elsewhere.
    Anon.

    July 22, 2019 at 3:45 pm

    #3665127

  • Reply To: Separate Money Value By "/" Character

    Jeff Moden wrote:

    Ah, apologies.  I'd camped out too long on this post and didn't refresh before answering and so missed the fact that Mr. Burrows already posted the correct and for...

    Far away is close at hand in the images of elsewhere.
    Anon.

    July 17, 2019 at 3:39 pm

    #3663826

  • Reply To: Separate Money Value By "/" Character

    As already stated this is normally done in presentation layer.

    However if you wish to do it in T-SQL and the datatype is MONEY you can do it this way

    Far away is close at hand in the images of elsewhere.
    
Anon.

    July 17, 2019 at 12:32 pm

    #3663719

  • Reply To: Is SSIS a dinosaur in Modern ETL?

    Jeff Moden wrote:

    David Burrows wrote:

    Jeff Moden wrote:

    The only exception is for daily transfer of 40GB in 140 KISAM files from a third party system and found SSIS the fastest method.

    I don't know...

    Far away is close at hand in the images of elsewhere.
    Anon.

    July 12, 2019 at 4:10 pm

    #3662432

  • Reply To: Is SSIS a dinosaur in Modern ETL?

    Jeff Moden wrote:

    As for SSIS...I don't care for it either (I don't actually care for any of this drag'n'drop stuff because it turns out that's usually not all that's necessary) but...

    Far away is close at hand in the images of elsewhere.
    Anon.

    July 12, 2019 at 8:10 am

    #3662318

  • Reply To: passing delimited text from stored procedure to show in flat file

    Chris Harshman wrote:

    ... but SSIS can call a stored procedure for a data source, and write the output to a text file.  That may make more sense than trying to format...

    Far away is close at hand in the images of elsewhere.
    Anon.

    June 21, 2019 at 4:04 pm

    #3656212

  • Reply To: Are the posted questions getting worse?

    Grant Fritchey wrote:

    I was on Poland recently, but no one let me drive a tank...

    Now, that would be scary :-/

    Far away is close at hand in the images of elsewhere.
    Anon.

    June 21, 2019 at 1:40 pm

    #3656160

  • Reply To: passing delimited text from stored procedure to show in flat file

    mcfarlandparkway wrote:

    Hello David, Instead of calling from procedure, can we handle in SSIS package using script component?  with out casting original columns from the table?

    Due to the fact the COUNT...

    • This reply was modified 6 years, 12 months ago by David Burrows.

    Far away is close at hand in the images of elsewhere.
    Anon.

    June 21, 2019 at 7:48 am

    #3656054

  • Reply To: passing delimited text from stored procedure to show in flat file 

    CREATE TABLE #output (TypeNo int,Line varchar(255));

    INSERT #output (TypeNoLine)
    SELECT 1,'HEADER|"'+CONVERT(char(8),GETDATE(),112))+'|"'+REPLACE(CONVERT(char(6),GETDATE(),108),':','') FROM #output;

    INSERT #output (TypeNo,Line)
    SELECT 2,CAST(id as varchar(20))+'|"'+CAST(empid as varchar(20))+'|"'+[text]
    FROM [sometable];

    INSERT #output (TypeNo,Line)
    SELECT 3,'COUNT|"'+CAST(COUNT(*)+1 as varchar(20)) FROM #output;

    SELECT Line
    FROM...

    Far away is close at hand in the images of elsewhere.
    Anon.

    June 20, 2019 at 12:57 pm

    #3655743

  • Reply To: Are the posted questions getting worse?

    Best to ignore the post and everyone else do likewise 🙂

    Far away is close at hand in the images of elsewhere.
    Anon.

    June 19, 2019 at 4:39 pm

    #3655353

  • Reply To: Slower is Faster

    Jeff Moden wrote:

    It worked out well because, when people ask me why their code had performance issues, I could tell them, "Well, if you had used the fn Tally function like...

    Far away is close at hand in the images of elsewhere.
    Anon.

    June 18, 2019 at 2:03 pm

    #3654765

  • Reply To: formatting T-SQL

    Jeff Moden wrote:

    While it's not my job to judge, I do "follow" you on these forums for a reason... you're posts over the last more than a decade have always been...

    Far away is close at hand in the images of elsewhere.
    Anon.

    June 13, 2019 at 2:58 pm

    #3653281

  • Reply To: formatting T-SQL

    Jeff Moden wrote:

    IIRC, it was David Poole that said "If you're the first person people come to with database problems rather than the last, you might be an exceptional DBA".

    They do...

    Far away is close at hand in the images of elsewhere.
    Anon.

    June 13, 2019 at 7:36 am

    #3653104

  • Reply To: ssrs display text with no data

    Add a new row at the end of the table outside of any groups

    Add text and format the row

    Change the row visibility to hide the row if the dataset contains rows

    Far away is close at hand in the images of elsewhere.
    Anon.

    June 12, 2019 at 12:27 pm

    #3652692

    • Viewing 15 posts - 166 through 180 (of 3,544 total)