I`m attempting to remove the ``*`` from the statement and trying to only select on the view`s date and value column, but the error is stating that the 

``Ambiguous...

Steve,

Thank you so much for helping out. And yes, your suggestion worked like a charm.

Appreciate it.....Walter

Gents,

Here is a small sample of my data.

--===== Create the test table with
CREATE TABLE #PrecipAcc
   (
   Date (datetime2(0))
  ...

Rob,

Yes, that is the case. I'm only searching between two particular dates. Usually, 03/01/2010 (format mm/dd/yyyy) and 03/02/2010 with the same format.

I've removed the DATEADD part,...

Thanks J. Livingston...

I'll give your suggestion a try.

Walter

Morning,
Now that I have a successful sql statement, thanks to the help of others, I now would like to update a column in a table using that same line....

Drew,
Appreciate your return comment. Your suggestion worked like a charm.

Thanks to all the gentlemen who've helped me above.

thx..Walter

Gents,
I can't seem to get this sql statement to work:

select