First, ditto everything Chris said.

Not all that well. You are going to get an index scan instead of a,...

You could do this:

WHERE CONVERT(DATE, Getdate())

NOT BETWEEN TRY_CONVERT(monthbegindate, datetime) AND TRY_CONVERT(monthenddate, datetime)

drew.allen (10/4/2016)

---

You have to be careful with sp_MSforeachdb, because it will also run in the system databases. I assume that you don't really want to create these tables in...

sp_msforeachdatabase is undocumented and overrated. That said, let's say you wanted to create a table named SomeTable in each db, you could do so like this:

EXEC sp_msforeachdb

'

USE ?;

IF...

Perhaps something like this:

WHERE a.start_execution_date >= DATEADD(Hour,-4,getdate())

Edit: that's a "greater than or equal" sign above, it keeps messed up when I post.

drew.allen (10/3/2016)

---

Alan.B (10/3/2016)

---

We have a script for exactly this kind of thing; have a look at nsplit2B which you can find here[/url].

Here's a couple examples:

DECLARE @myv VARCHAR(MAX) = 'AB,CD,EF,GH,IJ';...

getnumsAB

CREATE FUNCTION dbo.GetNumsAB

(

@low bigint,

@high bigint,...

We have a script for exactly this kind of thing; have a look at nsplit2B which you can find here[/url].

Here's a couple examples:

DECLARE @myv VARCHAR(MAX) = 'AB,CD,EF,GH,IJ';

SELECT *...

It appears to be but I have not tested it. In BOL, for SSRS versions 2014 and earlier, it explicitly says for Chrome, "Printing and...

ok, quick update. There does not seem to be a limit (I know you can do 2048 for sure).

For fun, play around with this code:

-- one time setup

USE...

I was curious about this too and did a little research. There appears to be absolutely nothing about this out there about APPLY. Since APPLY is very similar to a...

Costco

Is it possible that you could post the actual execution plan instead of the estimated plan? That will tell us much more. What you posted may not be the plan...

I'm out of time but perhaps this can get you started. You can use DelimitedSplit8K_LEAD (see link in my signature) to parse the string like this:

SELECT ItemNumber, item =...

YES.

I've been a BI Developer/Architect/Consultant for ~7 years and I am a total .NET language novice. Front...