Viewing 15 posts - 2,671 through 2,685 (of 5,109 total)
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
November 6, 2017 at 5:01 am
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
November 6, 2017 at 4:45 am
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
November 6, 2017 at 3:20 am
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
November 6, 2017 at 1:54 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 6, 2017 at 1:42 am
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
November 5, 2017 at 6:45 am
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
November 5, 2017 at 5:40 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 5, 2017 at 4:30 am
saravanatn - Saturday, November 4, 2017 11:05 PMThanks 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
November 5, 2017 at 3:50 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 5, 2017 at 3:00 am
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
November 4, 2017 at 4:22 pm
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 4, 2017 at 6:04 am
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
November 4, 2017 at 4:38 am
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
November 3, 2017 at 10:25 am
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
November 3, 2017 at 8:06 am
Viewing 15 posts - 2,671 through 2,685 (of 5,109 total)