Hi,

Yes that solves the problem. yes ID is unique identifier and Non Null

Hi what was Your solution? It would be good if you can share one.

I may have similar situation in future.

Thanks

IF SMINO = ID then I want to update IMEI number of that raw to update where SIMNo matched.

ex. Raw 1 & 2 's IMEI number should be updated...

Phew that took me about 10 minutes to do calculation on my mind.

Great question.

Or if your duplicate records keep coming via user input then you can create view with select distinct.

Great question

It's easy to get lost between Nested Transactions specailly when we use same naming for SAVE point & TRAN.

+1

SELECT CONVERT(INT,ROUND(<YourColumnName>,0)) FROM <yourtable>

If you try grouping order id and partkey with count(*) that should give you number of unique combination of order id and part key.

If you want 1 2 3 next...

Good question. Any one know why it returns 1 for some/most of special characters?

Following query will get you result for

SELECT COUNT(S.SalesID)

FROM tblSales AS s

INNER JOIN tblProducts...

Good one should have included DISTINCT to make it more confusing.

Thanks All,

It works. Yes all the codes are separated by spaces at this stage but in future they may appear with other delimiter.

I was trying like '%[b.billing_code]%' and it...

Oh Man how did I got this wrong I read this reference article not so long ago !! (a month may be) Time to refresh my knowledge....

Great question Ron....

vinu512 (5/7/2012)

---

This might work:

Select * From Ex

Where DEPTNO In (Select DEPTNO From Ex Where ENAME = 'SCOTT')

Edit:

If you Don't want Scott in the result set then you can edit the...

Hmmm knew the order but didn't know that we can't use alias in Where clause.