Viewing 15 posts - 286 through 300 (of 927 total)
sreeram.sivakumar 61990 (6/30/2015)
The Result should be1,100,null,10
5,500,400,20
7,700,null,4
8,800,600,2
can you please explain why 5,500,400 have 20 quantity instead of 10? because if we apply the same rule on 8,800,600 then it should...
June 30, 2015 at 11:32 pm
sreeram.sivakumar 61990 (6/25/2015)
Yes if there is sourceno then you need to get its quantity till it reaches null. and then calculate the prior max for the lastest ID.
so the corrected...
June 26, 2015 at 12:35 am
sreeram.sivakumar 61990 (6/25/2015)
correction result should be1,100,null,10
5,500,400,20
7,700,null,4
8,800,600,2
one rule i didn't understand
i-e
if 8,800,600,2 then 5,500,400,10 instead of 5,500,400,20
as per the sample data if destination no have source then...
June 25, 2015 at 2:19 am
John Mitchell-245523 (6/24/2015)
twin.devil (6/24/2015)
We have been ordered to do so....:w00t:
ok. thats a very good reason to merge two sp in 1.
I disagree. The person doing the ordering may not...
June 24, 2015 at 3:28 am
here is working example which i have suggested. i also tried to give you an answer to conflict question. if it is you are looking for:
if object_id('Proc1') is not null
drop...
June 24, 2015 at 3:23 am
Will the financialYearID not conflict ?
can share some detail regarding this, i didn't get your point on this one 🙂
June 24, 2015 at 3:10 am
ok for this i have shared a few situation which can caused you can take them as a starting point and some research of your own and hopefully you will...
June 24, 2015 at 2:43 am
We have been ordered to do so....:w00t:
ok. thats a very good reason to merge two sp in 1.
i would suggest to create Calling SP and call your already existing sp...
June 24, 2015 at 2:40 am
why you need to combine these to procedures in the 1st place ?
June 24, 2015 at 1:00 am
Hi Guys, I have thought of the concurrency issues on the querying side.
can you share some detail for this?
June 24, 2015 at 12:59 am
what i understand from your question is that you are looking for the Time portion from the datetime field.
DateTime: 24-Jun-2015 12:45:35.000
and your are looking for
'12:45:35.000' only.
check the following link
June 24, 2015 at 12:10 am
there are many factors which can cause timeout of a query.
e.g.
1. Table locking, which mean one transaction is hold locks on the table/row the other query requires.
2. query / batch...
June 24, 2015 at 12:04 am
nice, easy and informative. Thanks for sharing
June 23, 2015 at 11:58 pm
Viewing 15 posts - 286 through 300 (of 927 total)