In my org IT doesn't work with confidential data such as payroll or sensitive company secret data so we are allowed to  see the production data. Our DBAs copy...

Gold toe, always go for the gold toe

Fixed that for...

but....you tested dropping those columns in UAT somewhere and had the devs sign off on what to change and whether it worked correctly, right? Or you'll do that for the...

see? learn something new every day. Now we just need a Guns of Navarro/Mission Impossible/James Bond movie about Bothans that ties right into Jedi

Like all art, it means different things to different people. I was born in '78, so only got to see Return of the Jedi in the theater, guess which movie...

that's why I...

As to the last film. How long have they known that they could launch a ship into space warp or whatever they're calling it and destroy every single thing...

I've seen how people drive with only three degrees of freedom, flying cars? No thanks. Solve the self-driving problem first, IMHO.

Suggestion for if you want to continue to use this contractor, figure out what your metrics are for a "successful" solution (delay less than x seconds, allows for x users...

Right, so do a count() of the files, group by month(convert(date time,dateColumn)),

or if you want the week, group by datepart(week, convert(datetime, dateColumn))

I just did that to show you how it works, you would just put your column there, but without the ddl and sample data I used a variable. If you...

Agreed with Drew. For example, you created a thread asking if it would make sense to add a short question thread.

Also, if you're just thinking that a short question/answer makes...

1. You can CONVERT() your string to a datetime value, which will make your life a lot easier, then you can group by day.

   DECLARE @myDate varchar(50);
   SET @myDate...

Hey Russ, good to hear from you! Thanks for the compliment, but truth be told, it's all just painful experience, not smarts. I got the idea from one of these...