I've been using For XML to put SQL query results into HTML pretty successfully for a few years.

Looks basically like this:

IF OBJECT_ID(N'tempdb..#T') IS NOT NULL

DROP...

I don't see it as a bad thing that coders can have blind-spots handled for them by the tools.

Seems kind of like thinking microwaves are bad because people used to...

henriettewhite (1/12/2012)

---

Thank you! These sound both like very good ideas and certainly less problematic if something goes wrong. I have no experience with Event Notification and use...

Bex (1/12/2012)

---

Grant Fritchey (1/12/2012)

---

GilaMonster (1/12/2012)

---

I just had a look over...

DeanORenO (1/11/2012)

---

you people on this forum are always complaining about the questions that are asked on the forums, either you complain that they are too simple, and that the poster...

I use a trace that captures event ID 14. Server-side traces are low-impact, easy to manage, et al. Takes an on-startup proc in master to make sure it...

drew.allen (1/9/2012)

---

GSquared (1/9/2012)

---

Audit logging doesn't need to use the "inserted" data. You already have that in the table you just updated. Logging it just increases the size of...

SQL_By_Chance (1/10/2012)

---

G,

your query has 2 input tables but if you check CTE it is taking input from the same table.

On the first thought, I too thought of using a...

Does that include indexes, constraints, triggers, and extended properties (for the table and the columns)? How about dependencies? ...

I was going to try to help you, but if you're just going to...

The problem with that one is that, when you go back to read it a year from now, it won't be clear what it's doing and how. You can...

Yep. Glad you worked it out. Happy to be able to help.

I must be missing something. Passing parameters from SSRS to SQL procedures is usually very, very simple. You define them in the query.

As for multi-value parameters, I like...

Watch out, ASCIIbetical sorting can get tricky! Even without ASCII null-character codes in the string.

Audit logging doesn't need to use the "inserted" data. You already have that in the table you just updated. Logging it just increases the size of the log...