<snip> Duplicate post

• This reply was modified 4 months, 2 weeks ago by  noxidjkram.

Thanks - a great article. Very helpful.

In section 6A, whilst not core to the topic, would "union all" be an appropriate choice instead of union for performance/workload reasons?

M

To this:

m.definition Like '0.000000E+0MP_cte%20$s'

Did you use the AI to generate your article by any chance?

Model: ChatGPT  Claude was created by Anthropic, while ChatGPT was created by OpenAI. We have different model architectures and were trained on different datasets.

Yes - i understand now.

If you wish to display your data in a table, then transpose your results (within your SQL Stored Procedure/Query) and send through the required 'header' as...

As far as I know font is set per element.

If you know you are only going to use one font (as we do) then store it in a field...

Another vote for a well written introduction.

For all those experienced and insulted DBAs out there, please remember the up-and-comings like myself who really appreciate an introduction to the subject wherever...

markus.krenn (3/26/2009)

---

Hi Boyan Penev,

why do you need parameters?

Your Resultset of the StoredProcedure has only one row containg the value of the colors. So, my meaning is that you can use...

You mean the text in your column header to read vertically oriented rather than horizontally? or actually transposing (or rotating 90degrees) the whole table?

M

For me, the wizard was great to begin with when I didn't have a good handle on how to set properties etc manually, but after using BIDS for 18 months...

When it comes to templates it doesnt really matter too much anyway.

You can just copy and paste your 'template' into your newly created project file and add it from there...

Great article/series.

One small point - you state that you cannot use databased images in headers and footers... I'd like to point out that you can. 🙂 You need to store...