If it was something that wasn't usually requested or accessed by the CIO, I'd get him to tell me who in security I would need to ship the data to....

or Foxpro...

I keep having issues with typing the wrong unit. Scott's right of course....

Jeff Moden (12/13/2007)

---

Heh... they even made the same mistake that caused the y2k crisis...

Best T-Shirt I ever saw on the subject of "SQL Darwin Awards" was...

[font="Courier New"] SELECT *

...

It sounds like your database is in what is called "Full recovery" model. Meaning - all activity is logged into the transaction logged and kept there until the logs...

...and as I recall, tourist visa's can't be turned into work visa without you leaving the country (even if for just a short while)....

Definitely check the requirements, you wouldn't want...

Aaron Ingold (12/13/2007)

---

That along with multiple nested IN statements, crazy temp table usage, and the general assumption of "Well it returns the right answer so it must be good" gives...

Bob Hoffman (12/13/2007)

---

Just yesterday, our HR contacted me with a problem. A user had entered part of the URL to the online benefits page (3rd party) into the Google...

Keep in mind that getdate() is non-deterministic, so that if it happens to be using that your result will forever be non-deterministic.

Something else is making it non-deterministic. I just tried using hashbytes of a single column in a persisted computed column, and it does work. Check for any other...

try something like this:

select right(datepart(yy,startDate),2)+'/'+right(datepart(yy,endDate),2) as YearLabel,

etc....

We're actually already there. There's a recent exploit in Quicktime files that allow for remote code execution and privilege escalation. It's already surfaced at least once, targeted at...

Jeff Moden (12/13/2007)

---

And, you have to be really, really careful... that "3rd party POS", as Matt called it, may have been the "brain-child purchase" of that management... you may...

You set the function to return a generic IEnumerable. You also need a method to return the individual rows (unless the object you return has a default enumeration method)

Here's...

Good thing you found that. I hadn't noticed that part, and was about to start a thread to figure that out. Like I said - I never used...