Forum Replies Created

Viewing 15 posts - 2,671 through 2,685 (of 5,109 total)

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

    What is your question here? You've made some statements about what your goals, but not asked a question.

    As per the documentation on TRY...CATCH (Transact-SQL), however,...

    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

    Those links are to your local server, they aren't going to be accessible by us; we're not on your network.

    This would be easier with some consumable sample data...

    Thom~

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

  • RE: SQL - How to replace certain repeated values with null

    Could you please provide your data in a consumable format please? Have a look at the link in my signature on details on how to achieve this. You're much more...

    Thom~

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

  • RE: How many child packges can be called in one master package ? any limit ?

    Duplicate of a topic you made 2 days ago, and received an answer to. Rather than posting a new topic, if you have further questions, you're better off replying on...

    Thom~

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

  • RE: Encrypt a column in sql server?

    Jeff Moden - Sunday, November 5, 2017 9:48 AM

    Thom A - Sunday, November 5, 2017 3:00 AM

    Thom~

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

  • RE: SQL Puzzle challenge

    For example:
    [Code]SELECT 1;
    SELECT 2;
    GO[/query]
    That's two statements, run in the same session, with 2 result sets.

    Thom~

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

  • RE: Initial size of data file

    It won't contain any information, as there is no data in the database. Think of it like an empty box, it still takes up space with or without stuff in...

    Thom~

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

  • RE: Encrypt a column in sql server?

    vsamantha35 - Sunday, November 5, 2017 4:20 AM

    Hi Thom,
    Thank you for the example. Now, assume that the data is encrypted, suppose...

    Thom~

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

  • RE: SQL Puzzle challenge

    saravanatn - Saturday, November 4, 2017 11:05 PM

    Thanks Allen... 
    Can you kindly  tell me how to generate two result sets...
    Regards,
    Saravanan

    Use 2 SELECT statements in...

    Thom~

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

  • RE: Encrypt a column in sql server?

    Jeff Moden - Saturday, November 4, 2017 8:42 PM

      Don't even think of using dynamic data-masking for this because a half-wit...

    Thom~

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

  • RE: Encrypt a column in sql server?

    It sounds like what your trying to describe is a feature called Dynamic Data Masking (DDM), which you can read about here: https://docs.microsoft.com/en-us/sql/relational-databases/security/dynamic-data-masking. DDM, however, was introduced with SQL...

    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?

    Thom A - Monday, October 30, 2017 11:15 AM

    Steve Jones - SSC Editor - Monday, October 30,...

    Thom~

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

  • RE: Row Wise Balance

    Add Opening Balance too. You can have more than two fields in an expression.. Opening Balance + Credit - Debit = Closing Balance

    Thom~

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

  • RE: Row Wise Balance

    Not sure what you mean by "Row Wise balance". Is this simply Credit Amount - Debit Amount? That would be:
    =Fields!CrAmount.Value - Fields!DbAmount.Value

    Thom~

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

  • RE: Min not working for ROW_NUMBER

    Without the original data, how can we hope to get the results your after? Could you please post DDL and consumable sample data?

    Thanks.

    Thom~

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

Viewing 15 posts - 2,671 through 2,685 (of 5,109 total)