SQLKnowItAll (4/18/2012)

---

Sean Lange (4/18/2012)

---

Not really true or an accurate...

Like this?

select Location, MIN(Starttime), MAX(Endtime)

from #Testing

group by Location

Not really true or an accurate way to do...

nadave1123 (4/18/2012)

---

Yes I am using Oracle, but I really like this forum and web-site as answers are always pretty simple and easy to understand:) I would appreciate if you...

When posting...scroll down...there is a button down there for attachments. 😀

I think this should closely represent what you are trying to do?

create table #MyTable

(

RowTimeStamp rowversion,

SomeValue varchar(10) default 'asdf'

)

insert #MyTable default values

select * from #MyTable

create table #MyTable2

(

RowTimeStamp rowversion,

SomeValue varchar(10)...

Few syntax error but pretty close.

CREATE TABLE #Testing

(

Location varchar(255),

...

Please post it in a format that is not on flickr. I am not the only person who has a net nanny at work that will not allow them to...

More importantly what is the error message??? I bet it will tell you the problem.

"Cannot update a timestamp column" perhaps?

The timestamp (rowversion) datatype is NOT editable.

Lynn Pettis (4/18/2012)

---

If I read the link correctly, timestamp may be...

As I posted in the other thread. The timestamp datatype is deprecated. http://msdn.microsoft.com/en-us/library/ms182776%28v=sql.105%29.aspx

Use datetime to record datetime information.

Simple, don't use timestamp as a datatype. It is deprecated. http://msdn.microsoft.com/en-us/library/ms182776%28v=sql.105%29.aspx

If you want to record dates for things like LastUpdated use datetime.

Excellent job posting ddl and sample!!! However I don't even being to understand what you want for output. I can't view your image. One solution is to create a temp...

You know with over 3,000 points you really should know better than posting such vague questions. Try reading the article at the first link in your signature.

Then when you want...

Pretty sparse on details. There is no reason that a stored proc called from a report can't use temp tables. Does the proc work when run outside the report?