I had trouble following along and ended up using tutorials from the internet. I'm using Excel 2016. Type "Power view" into help, to get a long list of...

The "date" datatype does not contain time.

I think you want something like this:

DECLARE @h TABLE (Hr int not null);

INSERT into @h values (0),(1),(2),(3),(4),(5),(6),(7),(8),(9),(10),(11),(12),(13),(14),(15),(16),(17),(18),(19),(20),(21),(22),(23);

SELECT * FROM @h;

DECLARE @t TABLE (dt_arrival datetime...

Run these to see what your server settings are. The last column is the value I would expect.

select 'ServerSetting', 'DefaultLangID', @@DEFAULT_LANGID, '0'

UNION all

select 'ServerSetting', 'DefSortOrderID', @@DEF_SORTORDER_ID, '52'

UNION...

I run this on customer sites to make sure SSMS text won't get chopped.

-- First run this test

-- is ssms configured for 8192 char output in text mode?

SET NOCOUNT ON;

DECLARE...

Have you checked your SSMS tools-options text and grid output truncate length settings?

Maybe characterset settings are affecting things.

Are you concatenating a zero byte in the middle? A zero byte...

I suspect a trigger might be converting it to nvarchar and back.

There may be implicit conversions to nvarchar and back if you use some built-in functions.

I suspect SSMS query environment...

Can I "phone a friend" or "ask the audience"?

Sql Server 2008 r2 can't handle the IIF functions. So I reformatted your code and got it working.

/* ** Agent Job List ******************************************************** **

** Description: Create a list of agent...

Well, I started on Sql Server 4.21 back when there was no DRI (declarative referential integrity) nor table checks so triggers were the only way to go as a single...

So you want to compare the tree structure and not the values, correct?

I've used this dbo.XmlTable function to do it. Get the function from here:

http://beyondrelational.com/modules/2/blogs/28/posts/10495/xquery-lab-58-select-from-xml.aspx

And here is some simple...

The "Joel Test" in Steve's link is right on target for the Project Leader. I work at a software development company and we always succeed in our projects, on...

Here is something that is not a joke: Microsoft is working on getting sql server running on Linux by next year.

A login is for Authentication.

A User is for Authorization.

Here is another possible way to delete a duplicate row:

-- delete all duplicates but first in each set

WITH cte AS

(

SELECT a.*,

ROW_NUMBER() OVER(PARTITION BY col1, col2 ORDER BY col1,...

The cartoon chart is irrelevant in cases where I want to be prepared to solve crises in seconds; it may take me hours or days to create scripts, say, to...