Evil Kraig F (11/28/2012)

---

Alan.B (11/28/2012)

---

I am trying to understand why went with a loop vs a set-based approach. I posted...

I am trying to understand why went with a loop vs a set-based approach. I posted a more set based...

This is a bit tricky and I am still working on this. Here's what I have thusfar...

--Create temp table to hold the dummy data

if object_id('tempdb..#IDs') is not null

drop table #IDs

CREATE...

By "apply a style sheet" are you talking about applying an XML transform using XSLT or apply CSS formatting?

You can also do this (I'm just showing another way to pivot):

;WITH sourceData ([RowID],[Region], [Factor])

AS

(

SELECT '1','Capitol',' Text1' UNION ALL

SELECT '2','Capitol',' Text2' UNION ALL

SELECT '3','Capitol',' Text3' UNION ALL

SELECT '1','Central',' Text4'...

No problem.

Just wanted to know whether it is correct because i will doing it on the production and have to be very sure before doing and don't have any test...

Edit: I misunderstood your question... What's with the NULLS?

Is DBA a limited Profession? Short answer: No. Long answer: Nope.

The DOM presents an XML document as...

I have seen it done with Sharepoint 2010 and using the Microsoft Report Viewer Redistributable. I have never done it though nor am I a Sharepoint guy.

For the crowd you describe I think the SQL tutorial at W3Schools is a good start (my 2¢). Like Jeff mentioned they have a "Try it yourself" section and they...

The top row (the first instance of the TR tag) you could add any attributes...

jjolk (11/21/2012)

---

I know I'm missing something obvious, but I'm trying to learn about Replication and all the documentation I read says to right click on the "Replication" node in SSMS...

Yes.

P.S. W3Schools is the best place to go...