Viewing 15 posts - 196 through 210 (of 898 total)
sj_prasad (6/4/2013)
My problem is VRCRAMT is not properly updating with BILLAMOUNT.ie VRCRAMT = 0 even if BILLAMOUNT > 0
please help
PRASAD SJ
You will have to do some de-bugging yourself in that...
June 4, 2013 at 5:03 am
Well. That is how AND works.
SELECT STNNo FROM table1 where VoucherBookletNo = 'VVB0000021' AND VoucherBookletNo ='VVB0000025'
If your query is translated in simple English, it will be something like
Give me the...
June 4, 2013 at 4:47 am
m.rajesh.uk (6/4/2013)
what is the difference between show plan xml,show plan xml for query compile,show plan xml statistics profile in the context of profiler. How to get query...
June 4, 2013 at 4:23 am
sj_prasad (6/4/2013)
Yes, only one record will be inserted into the table [dbo].[BILL_TRN] at a time.PRASAD SJ
It will still be better to create the code which can handle multiple row inserts...
June 4, 2013 at 4:17 am
m.rajesh.uk (6/4/2013)
Hi can any one explain what these SID and PID . what is the use of them..
Are these column names from some system tables?
June 4, 2013 at 4:08 am
sumadevu (6/4/2013)
declare @id intselect @id=id from grts where name=@name
if exists (select * from grts where id=@id)
begin
update grts set name=@name,class=@class where id=@id
end
You can remove some redundant code as done below..
if exists...
June 4, 2013 at 4:04 am
raghuldrag (6/4/2013)
Hai ,Then How call update and insert in that procedure
As I said earlier, the checking that you are doing using EXISTS needs to be changed
If you are...
June 4, 2013 at 4:00 am
What are you trying to do?
If you are creating an INSERT/UPDATE procedure, you probably need to pass the id and do the existence check based on that
If passing the id...
June 4, 2013 at 3:47 am
You are probably looking for this, a scalar valued column cannot contain 2 different values in a single row
SELECT STNNo FROM table1 where VoucherBookletNo = 'VVB0000021' OR VoucherBookletNo ='VVB0000025'
-- OR
SELECT...
June 4, 2013 at 3:26 am
Duplicate post. Please direct all your replies here.
http://www.sqlservercentral.com/Forums/Topic1459272-3077-1.aspx
June 4, 2013 at 1:23 am
Something like this..
SELECT*,
CASE WHEN SUBSTRING(rate, 1, 1) = '*' THEN '10' ELSE SUBSTRING(rate, 1, 1) END AS game1,
CASE WHEN SUBSTRING(rate, 2, 1) = '*' THEN '10' ELSE SUBSTRING(rate, 2, 1)...
June 4, 2013 at 1:15 am
immaduddinahmed (6/3/2013)
create table attendance
(
CID int, mean company id
BID int, mean branch id
date datetime,
eid int, mean employee id
timein datetime,
timeout datetime,
)
and we dont have a employeeid in...
June 3, 2013 at 6:37 am
I am not sure why are observing a difference in behavior
But, I see some issues in your UPDATE statement
You are updating all the rows in the table when a row...
June 3, 2013 at 6:30 am
Sorry, but this will not be enough
Please provide the DDL of both the tables involved, some sample data and the expected results based on your sample data
If you are not...
June 3, 2013 at 5:55 am
immaduddinahmed (6/3/2013)
Sir i use your function and its give me multiple result
Multiple results is not a result of the use of the function
There is some issue with your JOINS, may...
June 3, 2013 at 5:41 am
Viewing 15 posts - 196 through 210 (of 898 total)