Viewing 15 posts - 5,671 through 5,685 (of 13,874 total)
Have a look at this. It assumes that RelatedLoans.SoldLoan cannot also exist in the MasterLoan column:
DECLARE @MasterLoanData TABLE
(
NoteNumber VARCHAR(10)
, Balance INT
);
DECLARE @RelatedLoans...
April 24, 2017 at 10:45 am
April 24, 2017 at 9:41 am
Your UPDATE statement has a single target (r)
Yet your statement is attempting to update columns from m1 and m2.
April 24, 2017 at 9:02 am
As for the link that Phil gave - yes the Integration Services SERVICE is not required to run the packages - this is because from SQL 2012 SSIS catalog was...
April 24, 2017 at 8:59 am
April 24, 2017 at 8:45 am
You've been here long enough to know how to do this.
Here is a formatted version, for all those who struggle to optimise embedded SQL:DECLARE @PatientVisit_ID...
April 23, 2017 at 2:22 pm
April 23, 2017 at 9:04 am
April 23, 2017 at 7:15 am
Please help me to figure out why the SQL query is taking more time compare to ORACLE.?
Sounds like you figured it out for yourself. You're not comparing like with...
April 21, 2017 at 12:15 pm
SSIS packages do require an instance of SSIS to be able to run, unless SSDT has...
April 21, 2017 at 9:18 am
April 21, 2017 at 8:53 am
April 21, 2017 at 6:04 am
April 21, 2017 at 5:48 am
A more efficient way of coding this is to perform the deletion and then check @@ROWCOUNT afterwards, thus hitting the table once per deletion rather than twice.
April 21, 2017 at 5:45 am
Try running in 64 bit mode and see what happens.
April 20, 2017 at 3:50 pm
Viewing 15 posts - 5,671 through 5,685 (of 13,874 total)