Try this:

SELECT * INTO #Values
FROM (
SELECT 'Timothy' AS Search_value, 'Tim' AS Replace_Val UNION ALL 
SELECT 'Kathleen', 'Kathy' UNION ALL 
SELECT 'Joseph', 'Joe' UNION ALL 
SELECT 'Michael','Mike' 
)...

There are formatting functions. You should be able to convert to any format you want.

=Format(Fields!MyDate.Value, "dddd, MMM d yyyy")

Function ChrW takes Unicode code. So find the one you like and pass it.

https://www.rapidtables.com/code/text/unicode-characters.html

I believe it should be True if you run remote SPs. For example you connected to ServerA and want to execute SP on ServerB:

exec ServerB.MyDB.dbo.MySP

SELECT CHAR(149)

Here is what I use to display little pointy triangle on one of my reports. This is 2008 thou.

Microsoft.VisualBasic.Strings.ChrW(9658)

• This reply was modified 6 years, 4 months ago by rVadim. Reason: added VB code

Are you sure it's a SQL Server's message? Can you post exact text and message ID?

Same technique as before. For the first 3 months of 2018 it'll look like this:

SELECT
  C.prefix
 ,[Jan-18] = COUNT(CASE WHEN CONVERT(CHAR(6), W.[timestamp], 112) = '201801' THEN...

• This reply was modified 6 years, 4 months ago by rVadim.

Assuming that division is on Foreign vs. Local currency, something like this:

SELECT 
  keyinstn,
  Abbreviation,

  RatingSymbol = MAX(CASE WHEN ratingtypedesc LIKE 'Foreign%' 
 ...

I'm getting error:

Msg 208, Level 16, State 1, Line 67
Invalid object name 'CS_REPTOT'.

Thanks Jeff! I'm not an OP but still...

And if we want to get days out of it and keep hours within 24 then last SELECT would be something like this:

Another options is to delete in smaller chunks over period of time.

Dropping article will invalidate snapshot.

• This reply was modified 6 years, 4 months ago by rVadim. Reason: Corrected myself

You probably will have better luck on some VB.Net forum.

The OP of this post suggests that 1899-12-30 is coming from Access DB.

DECLARE @D DATETIME = '1899-12-30 09:12:32.000'
SELECT @D, CAST(@D AS TIME), CAST(CAST(@D AS TIME) AS CHAR(8))

From what I learnt in this post it could be waiting for OLE DB info while parsing query during compilation. So, maybe (just guessing here) there is a difference...