Forum Replies Created

Viewing 15 posts - 2,656 through 2,670 (of 5,109 total)

  • RE: Excel 256 Column Layout

    I'd suggest assigning your column delimiter an I'd of some sort then, and then putting filters on your matrices.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Reporting Services will not start with a .NET 2.0 Runtime Error

    Could you post the logs from SSRS, they might provide some more insight.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Dynamic variables in SQL server for HTML

    OK, I see what you're after now.

    SQL isn't really great at this, if I'm going to be honest. If you're generating HTML reports it's best at top-down...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Excel 256 Column Layout

    Create 2+ tablixes on your report, put the first 256, or so, columns in the first tablix, then the next 256 in the 2nd tablix, the next 256 in the...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Are the posted questions getting worse?

    There are some days I really hate our Vendor system...

    One of my biggest bug bears is how it handles field name changes on SQL's side. When someone realises...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Dynamic variables in SQL server for HTML

    Maybe it'll be easier for me to start from the beginning instead and simply understand your end goal, rather than what it is you've tried so far. At the moment...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Excel 256 Column Layout

    To export more than 256 columns in SSRS 2008 you'll need to split your data in your report into two separate tablixes in your report and insert a page break...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Dynamic variables in SQL server for HTML

    70712 - Monday, November 6, 2017 9:20 AM

    Hi,

    Some test data bellow if I have understood those guidelines correctly. As I say,...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Query

    I realise that there is a language barrier here, but your statement doesn't really make sense. Cold you try rewording your statement into a question please, and try to be...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Dynamic variables in SQL server for HTML

    70712 - Monday, November 6, 2017 7:48 AM

    Hi, 

    Apologies, this is what the email looks like:

    I am using the variable to identify, how...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Does Anyone know how you can copy values from a previous row into a null column in SSIS

    Little confused by what your asking. It looks like, from your data, that you silple don't want to import the summary rows. If you use a conditional split to separate...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Are the posted questions getting worse?

    Lynn Pettis - Sunday, November 5, 2017 6:44 PM

    Jeff Moden - Sunday, November 5, 2017 6:26 PM

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Error Handling in SQL Server 2008 R2 Try Catch issue

    rahulsahay123 - Monday, November 6, 2017 5:07 AM

    i am not able to log the error message. control is not coming to the...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: sql data muniplication help

    Ok, for a solution, this should get you what you're after. The method is called Cross Pivoting (because you use a CROSS APPLY to Pivot your data). If you have...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: sql data muniplication help

    Welcome to SSC. When posting data questions, it best to provide DDL and consumable sample data for other users. We don't have access to your server, or data, thus you...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

Viewing 15 posts - 2,656 through 2,670 (of 5,109 total)