Almost every property in SSRS can be set through an expression as well as directly entering a value. Right-click the Name text-box, and select text-box properties. Select the "Font" tab....

Sorry, I don't do c.u.r.s.o.r.s.

(See??? I can't even type it!) :w00t:

..... what's wrong with the query? Why do you feel a cursor...

Scripting it out will do MOST of what you need. You will find that SQL does not script out ANY passwords, so you will need to change the scripted password...

ColdCoffee (6/2/2010)

---

I sense the OP needs 4 columns out of the string, as in, FirstFacilityID ,FirstPatieintID, SecondFacilityID, SecondPatieintID ; these 4 columns will hold only intergers, stripped from the real...

What ColdCoffee...

This solution is based on using a DelimitedSplit function, which is this (This function uses an in-line tally table. A persistent tally table will be more efficient. See the article...

SELECT TableName = st.name, [# Rows] = sip.rows

FROM sys.system_internals_partitions sip

JOIN sys.tables st

ON...

SELECT [TableName] = st.name,

[IndexName] = si.name

FROM sys.tables st

JOIN sys.indexes si

...

You will just have to build the URL as an expression. Determine what the URL needs to be to pass the parameter (you do know that you can pass parameters...

What you're really talking about is changing what schema the tables belong to.

What you have to watch out for is any query that uses > 1 part naming convention:

<server>.<database>.<schema>.<table>

So, if...

Very possible, and not that hard to do.

Read the "Cross Tabs and Pivot Tables" Part 1 and 2 articles (click the links in my signature).

BTW, thanks for posting the table...

Here's a method that utilizes an infrequently used form of the update statement, nicknamed the "Quirky Update". It's wicked fast, but has about a dozen rules that MUST be followed....

Okay, then based upon the string that...

If I'm understanding this correctly, you want to just remove all numbers and hyphens? (0-9 and "-")

Both the [refTable] and [c] are table aliases... use whichever one you want to.

The optimizer expands an IN to all those OR conditions... check the execution plan, they will be...