You will have to do some de-bugging yourself in that...

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...

m.rajesh.uk (6/4/2013)

---

Hi All,

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...

It will still be better to create the code which can handle multiple row inserts...

Are these column names from some system tables?

You can remove some redundant code as done below..

if exists...

As I said earlier, the checking that you are doing using EXISTS needs to be changed

If you are...

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...

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...

Duplicate post. Please direct all your replies here.

http://www.sqlservercentral.com/Forums/Topic1459272-3077-1.aspx

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)...

immaduddinahmed (6/3/2013)

---

trans and attendace is same table

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...

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...

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...

Multiple results is not a result of the use of the function

There is some issue with your JOINS, may...