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?