I'm not sure what those double-pipes are meant to do. Is that T-SQL?

I tried it in a test database, and got a syntax error from it.

I've been using the RedGate tools for a long time, and find they do a very good job.

Well, the highly conditional Where clause will probably cause an overly broad execution plan to be built.

Can you separate each of those CASE clauses into separate procs and have the...

Is this something you can do with a stored procedure, instead of a view? If so, stored procedures can do dynamic SQL and could build a select statement each...

Can you check the firewall's logs to see what's trying to get through? That'll pretty much tell you what you need to let through, won't it?

First, why have the hierarchy in two tables? It's more usual to have one table and a parent ID that refers back to the same table.

Second, try having one...

You're welcome.

I have an account, apparently.

The closest you could get to what you're trying to do would be some sort of pivot operation. T-SQL does those, but not very well.

Views can't be dynamic. ...

Koen (da-zero) (1/5/2011)

---

GSquared (1/5/2011)

---

Brandie Tarvin (1/5/2011)

---

Any programming language that complains when I try to use 0 as a divisor should be taken off the market and all its install disks...

There are a couple of ways to do it. Will you be doing this often, or just once?

If often, RedGate (link at the top of the page) has a...

Honestly, the best way to find out how much tempdb you need is, set it to a best guess, and let it auto-grow.

Brandie Tarvin (1/5/2011)

---

Is something wrong with me that, as much as I'd like to win a free seat on SQLCruise (RE: Idera's little contest), that it's not incentive enough for...

I wouldn't do that in a trigger, usually. I'd be more inclined to use a job with a frequent schedule. Otherwise, you hold up the insert transaction till...

Are the parameters the same data types as the columns?