ChrisM@Work (2/10/2016)

---

If it's only one, then the original scalar function returning the result to a variable would have been just fine - and it would have met Gail's precautionary restrictions...

I do not use OPENDATASOURCE but the syntax to reference different Worksheets (i.e. "Tabs") is in the FROM clause. So, change [Sheet1$] to [Sheet2$] and see what happens.

Like this:

CREATE FUNCTION dbo.fnPressGaneyDownload()

RETURNS TABLE AS

RETURN (

SELECT CAST(

...

What day does your standard week begin on, Saturday, Sunday, Monday,...?

As an aside, this is the kind of stuff I would put into my calendar table. So, if you do...

Reminds me of this...

I think you have been provided good explanations of CASE and IF, and when you can use each. When you go further into what you are trying to do you...

The performance of FORMAT is very poor when used over large sets of data which is unfortunate because the syntax is more readable than any of the other methods available...

Seems my reference was not applicable since it was for splitting up a string longer than the allowable 8000 SQL Server supports but still not unbounded like a MAX type.

Clearly...

MadAdmin (2/9/2016)

---

Apparently there is a compatibility matrix which lets the engine know if the cast preserves the order of the data between the 2 data types.

So Cast ( intcol as...

Any reason why they cannot just use the standard Export dropdown available in the ReportViewer to get the PDF version?

I have done this using the ReportViewer control by spinning up an alternate Windows Identity in the background that has access to the SSRS Web Services (report server directly) but...

I get different plans but indeed see an index seek on both. One item to be careful of with your recommendation regarding the logic:

-- What you should suggest

SELECT SomeID,

...

Check out my blog post on this topic.

I had the best luck with SSIS (Attempt 4):

https://thesqldev.wordpress.com/2014/07/02/importing-data-in-a-mysql-database-into-a-sql-server-database/

For your case, if you have to stay in T-SQL, see attempt 3. Items...

I get an error navving to the link...

Please provide the driver version being used for GODADDY Linked Server.

PS going from ascii-255 to UTF-8 may be the issue. Try casting customer to NTEXT or NVARCHAR(MAX) in your SELECT.