bhavik.bk (8/21/2014)
ok.. i checked this link http://technet.microsoft.com/en-us/library/ee634547%28v=sql.110%29.aspx , which gives me some ideas. But very less examples in relation to using values in coding. i.e.you cant use it like you use DISTINCT.
SELECT DISTINCT customerid
FROM Employees
if you replace VALUES with DISTINCT ..it fails...So how do i use it?
Like this?
select distinct v1, v2
from (values ('1','2'), ('1','2'),('3','4')) as Source (v1,v2)
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.