frdrckmitchell7 (9/25/2013)

---

Thank you for your response:

I've built the (part of) query like this:

(IM.ItemCode BETWEEN '999999' AND 'CL00000'

OR IM.ItemCode NOT LIKE '001920'

OR IM.ItemCode NOT LIKE '001921'

OR IM.ItemCode...

Thanks so far.

Ed: I agree with you 1000% about the layering of views. Got truly spaghetti sql to deal with here. I'm working on convincing the powers that...

Grant, thanks for reminding me. The query plans are the same. The only differences between the two plan XMLs are:

<QueryPlan CachedPlanSize="1352" CompileTime="12244" CompileCPU="12238" CompileMemory="111952">

<QueryPlan CachedPlanSize="1352" CompileTime="12387" CompileCPU="12364" CompileMemory="111952">

Yes,...

Ed Wagner (9/4/2013)

---

Are the returned data sets the same no matter who runs the query? If you're selecting everything from a TVF, what is that function doing? Does...

Unfortunately, the named user does not have permission for SHOWPLAN. I won't be able to change that until next week....

Andy,

I agree with you on the "scoping" of variables. Has anybody EVER come up with a good use case for the scope of variables? I think that MS...

That was easy. Grrrr. I was doing all that work not knowing backup compression was available in Standard edition.

Thanks.

I thought you needed Enterprise edition to get backup compression. We have Standard.

There is a Sql Server Agent service, but not SQL Server Integration Services. How many levels of indirection are there in this product?

Of course. Duh! I've gotten dull due to heat or old age (or both).

Thanks.

Here's some code I wrote to get the first and last day of the previous 12 months. You can modify it for your uses to get week ending dates.

;WITH

t1...

dwain.c (6/25/2012)

---

You can also do it like this:

SELECT x.MyId, MIN(MinAmt)

FROM #test

CROSS APPLY (

VALUES (MyID, MV1), (MyID, MV2), (MyID, MV3), (MyID, MV4)) x(MyID, MinAmt)

WHERE MinAmt >= 150

GROUP BY x.MyID

I've run some...

I heard from a friend recently that went on an interview, and had done some research beforehand. This person jotted thoughts and questions in a notebook, took it to the...

Ok, I'm going to blame the jet lag (35 hours to get from Christchurch, NZ to Boston this weekend) on not seeing the obvious. Yes, prefixing the table name...

Is it possible to have too many columns that depend on custom code for rendering? This report has, among other columns, 13 columns (a gauge panel, three numeric columns,...