You have the correct idea... but since you didn't post anything about what the "user_splits" table looks like or what data it has in it, I have no idea what...

Wel-l-l-l-l-l.... kind of...

Sys.Objects has a Modify_Date column on it so you can tell when the last change occurred... you just can tell what the change was.

No, no... the TIMESTAMP datatype has absolutely NOTHING to do with a date or a time. Despite what Sam offered up, the best you'll get is some date and...

Grant Fritchey (3/5/2008)

---

We use this approach for variable parameters that may or may not be supplied. It works very well. It's set based. It will take advantage of indexes. It...

Ok... thanks for the feedback...

Please post the actual query... there's no way the one you posted actually works.

It's certainly not automatic, but my first inclination is to ask...

1. You allow folks to change production stored procedures without DBA approval?

2. Are there no documentation standards? ...

Ok... since you can't actually see Ascii 26 except maybe as a supurious square, how can you tell the end of file marker is being loaded?

And, still, you haven't tried the solution that Ian posted which doesn't have that problem... 😉

Ralph Curry (3/5/2008)

---

OK, the same technigue of packing aggregate into a string, but using a correlated subquery.

select

Widget,

DateValue

from (

select

...

Heh... at least you tried. Thanks for the feedback.

The end of file marker is typically an ASCII 26 and SQL Server will not read it in. You don't have to prevent it from happening.

I could be wrong, but this sounds like a "running total" problem with an additional SELECT to find the 2 million mark... please see the following...

http://www.sqlservercentral.com/articles/Advanced+Querying/61716/

There's usually some merit and some future need for knowing the times. I think it's a huge loss of data to update datetimes that have the time to all...

Can't help on the Reporting Services thing...

... But that's a cool avatar ...

... and my favorite NRA "saying" is "When they outlaw guns, only outlaws will have them."