iqtedar (7/7/2010)

---

thanks. One of the issues what i can forsee by using sql agent is that ,lets say i have 200 jobs then i will need to manually add agent...

Did you try running the DBCC Shrinkfile with TruncateOnly after or before the EmptyFile?

ISTR going through this and I had to run both of them (don't remember the order) before...

Don't worry. We all started that way.. @=)

PeterG-377490 (7/7/2010)

---

A typical query would be to search for a transaction...

As the others have said, this is all built into SQL Server already. And if there's an alert you can't find, but want, you can make your own.

And on jobs,...

Eugene Elutin (7/6/2010)

---

Post #945638 explains how you can generate random number using NEWID() function without using FranchiseID column to randomize.

It doesn't uses FranchiseID in the TaxID...

I just realized I'm going about this all wrong. I don't need *random* numbers specifically. I just need numbers that are NOT the TaxID. Which means I can use a...

First of all, "she", not he. @=)

Secondly, I need random numbers that do not repeat. I'm not limited to a range, but I need to make sure they only repeat...

Glad we could help.

lionwelp (7/1/2010)

---

I want to have the most recent...

CTE stands for Common Table Expression. There's no easy way to explain it except as a pre-query to your main query which can replace 1) a temp table, 2) replace...

Good catch. I missed the '/' character. I was assuming that maybe he meant for that to be the unicode character of N.

Have you experimented with PIVOT yet? As usually coded, it wouldn't directly output your results as expected, but I bet you could nest a few PIVOT subqueries together to come...

Honestly, I think you're overly complicating things. You don't need the function, if I'm reading your code correctly. You can just do a CASE statement in the JOIN clause.

Also,...

What is vvers_dat supposed to be? I'm running your code on my sandbox and I can't do the data insert because that column disallows NULLs and has no insert value...

Thanks, everyone. I appreciate your assistance. Looks like I'm stuck with cursors still, but I'm well on my way to a solution.

Soon as I verify it, I'll write up an...