Presenting

Lynn Pettis (12/10/2009)

---

Here is the fun part of living in Colorado. This past week we have had tempatures down to -13F (not including wind chill factor) and during the...

You are welcome

Jeff Moden (12/9/2009)

---

CirquedeSQLeil (12/9/2009)

---

Dropping only provides...

Sunny

Totally agree. I am doing the back questions to hone up a bit. There are some nitpicky things in some of the questions that make you have to...

I agree with the previous post on this one. The default for Reporting Services 2000 was for pageheight to be in Inches and the height would have been 11...

RBarryYoung (3/15/2008)

---

Does anyone check these things?

It is really disturbing how many wrong answers there are. It also makes me wonder how the folks with over 90% right ar doing...

Have you considered using a maintenance plan, or an SSIS package to do this?

Both seem like viable alternatives as well (in addition to Steve's suggestion).

try using xcopy with a command to delete

or you can do a dir to parse the filename and date info into a temp table and then do a move based...

Lynn Pettis (12/9/2009)

---

Based on your sample table and data:

with CombinedData as (

select

row_number() over (partition by ItemId order by LocationDateTime asc) as RowNum,

ItemId,

...

This guy has been a frequent post-er today

Better yet, have the user start using Windows Authentication instead of SQL Auth. Then the user will be using windows credentials. If the user can't remember the password...

Some reading on the subject:

http://blogs.msdn.com/lcris/archive/2007/09/13/basic-sql-server-security-concepts-ownership-chaining-good-and-evil-schemas.aspx

Nice query, I am playing with it now and adapting to my needs. Seeing if I can take it to the level of overkill 😀