Ah, most likely you have a NULL for the...

Here's another way, starting with the dates as INT as in the OP's situation.

Sample Data:

CREATE table #temp (SysKey int identity(1,1) ,BusName varchar(9) ,BusType varchar(6) ,StartDateKey int ,EndDatekey int)

Insert into #temp...

If that is the exact query you're running, then I imagine it's this line:

when [Tim].[dbo].[PP_FFR_BU].[Zip] = [TimCIS].[dbo].[Legis_Districts].[Zip5] and [Tim].[dbo].[PP_FFR_BU].[Zip4] <> [TimCIS].[dbo].[Legis_Districts].[Zip4]

The TimCIS.dbo.Legis_Districts table is not in a FROM clause for...

Jeffery Williams (4/28/2016)

---

Not exactly.

The execution comes later in another proc.

HOWEVER the printing of the variable is just BEFORE I set the variable value to the DB. What is printed to...

There's no execution of dynamic SQL yet.

It's the text of a TSQL statement, yes, but it's just being assigned to a variable, and then the value of a varchar(max) column...

Unless I'm misunderstanding your claim (quite possible), that's not true.

DECLARE @string1 varchar(3);

DECLARE @string2 varchar(2);

SET @string1='aaa';

SET @string2='bb';

SELECT LEN(@string1+@string2),@string1+@string2;

Cheers!

I'll echo what Lynn said a few posts ago.

You said you were able to reproduce this on a new table.

Posting the DDL and script you used to do that would...

There are really only a couple general ways to get around it.

1) Make sure the data is in memory for the runs where duration matters. This can take a couple...

Text data is not a column returned for those events.

See https://technet.microsoft.com/en-us/library/ms190194(v=sql.110).aspx for the columns returned by the various Objects Events.

If you want to see the T-SQL command associated, you'll need...

The most likely cause of this scenario is data not being in cache.

With the underlying pages not being in memory, the initial run has to load the pages from disk...

That's because you don't have a trailing space in that first value of the type column.

It's a horizontal tab, which makes that value not equal to the others.

You'll need to...

Brandie Tarvin (4/26/2016)

---

I just remembered. There...

Hmmm...and the database context was definitely changed to the database in question?

If I deny backup database to public on my test box, it shows up when I run that query.

Strange...

That DENY didn't show up in the results of the query I posted earlier?

It should have, so I'm curious why it didn't.

Cheers!

John Mitchell-245523 (4/26/2016)

---

Steve Jones - SSC Editor (4/26/2016)

---

Phil Parkin (4/26/2016)

---

As a general rule, it's better to put IsNulls inside Sums rather than outside. This avoids the warning message about NULL...