WayneS (8/28/2010)

---

thava (8/28/2010)

---

this way is slow when i used a large amount of data so i want change it for that, i need a little explanation there, could you...

Hi...

My name is Wayne. My title is DBA, but I feel like I have so much to learn to be worthy of that title.

thava (8/28/2010)

---

this way is slow when i used a large amount of data so i want change it for that, i need a little explanation there, could you provide...

Jack Corbett (8/27/2010)

---

WayneS (8/27/2010)

---

Jack Corbett (8/27/2010)

---

Wayne,

Thanks. This is a very nice solution, but as you said at the end, it definitely meets US requirements, but I can't say that...

This link will give you some good answers.

Jeff Moden (8/27/2010)

---

I love programming on this old machine... if I can make it run fast on the old machine, things pretty much cook when someone runs it on a...

Jeff Moden (8/27/2010)

---

WayneS (8/27/2010)

---

Using OpenRowset/OpenDatasource, it can't be done.

However, you can accomplish the formatting by:

1. Use the Export wizard.

2. Use a SSIS package.

3. Use the sp_OA procedures to perform OLE...

Are you rendering this in a browser? Because on the child report all you have to do is click the browser's back button... or press backspace.

If you are rendering in...

Jeff Moden (8/27/2010)

---

You folks already have the split thing pretty much down pat so I'll just demo another method for detecting and displaying "gaps". I haven't tested every method...

Jack Corbett (8/27/2010)

---

Wayne,

Thanks. This is a very nice solution, but as you said at the end, it definitely meets US requirements, but I can't say that it will for...

Brandie, you could just change your code to:

Create Procedure spMySillyProc (@Varme)

AS

BEGIN TRY

IF @Varme = 1

PRINT 'Tag, you are it.'

ELSE

BEGIN

...lots of code...

INSERT INTO dbo.MyTable (GoodCol1, GoodCol2, BadCol)

...

To track this information going forward, you could put in a database level trigger.

Thanks! You can imagine that I feel like doing that a lot.

Yes. Dynamic pivot...

Great! but it's only fair to tell us how.