I'm not really sure what you're asking here. It seems (to me) that you're implying that you've been told that the Full Text Search should only run under the local...

There's not, necessarily, a "con" to running the services on different servers apart from costing. When running them on a separate servers, then that's 2 sets of licences (and hardware...

Drew's...

DECLARE @StartDate date, @EndDate date;

SET @StartDate = CASE WHEN DATEADD(QUARTER, DATEDIFF(QUARTER, 0, GETDATE()), 0) = CONVERT(date,GETDATE()) THEN DATEADD(QUARTER, DATEDIFF(QUARTER, 0, DATEADD(DAY, -1,GETDATE())), 0)
                                    ELSE DATEADD(QUARTER,...

It actually worries me that someone out there was under the impression that converting an integer (or a string containing an integer numeric) to a decimal, reduces the value of...

You need to CONVERT and then divide by 100. An Integer, as a decimal, doesn't change its value.

You'll find it unlikely that people will open and/or use your Excel document. You need to supply your data in a consumable format; Phil, Jeff and I all have a...

You'll need to create a user defined table type, then DECLARE and INSERT the values into the and then pass that to your Function.

You're going to need to inspect each column and check if it has a value of NULL. This isn't going to be quick, but:
SELECT *
FROM YourTable
WHERE Column1...

Do you have to do this with an expression? I ask, as it may be easier to return the parts in your dataset, rather than splitting them in the report....