troubleshooting Question

SQL - Order by Asc query

Avatar of chokka
chokkaFlag for United States of America asked on
Microsoft SQL Server 2005Microsoft SQL Server 2008SQL
1 Comment1 Solution550 ViewsLast Modified:
SQL 2005 / 2008

This query over here ...

select DateFilled from
                  (
                  select patcustid,DaysSupply,DateFilled from vOeOrderHistoryWide
                  union all
                  select patcustid,DaysSupply,DateFilled from vOeOrderWide
                  )as x
                  where patcustid = 8

Returns Null and Date Field.

When i filter the query with Order By Asc - It returns NULL. Instead of picking the NULL Value, i am looking for first lowest Date Filled.

How to tune the query to fetch the lowest Date Filled !!
select top 1 DateFilled from
			(
			select patcustid,DaysSupply,DateFilled from vOeOrderHistoryWide
			union all
			select patcustid,DaysSupply,DateFilled from vOeOrderWide
			)as x
			where patcustid = 8
			order by DateFilled asc
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 1 Comment.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 1 Comment.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros