Steve Jones - SSC Editor (9/10/2014)

---

Jeff Moden (9/10/2014)

---

Heh... yeah... just like they gave us the ability to write...

I will also recommend Gail's article.

The logic for your query will look like this (note that you did not detail the expected behavior for if only @enddate has a...

IF @user > '' --This checks for not null and not empty

Cool. I never knew you could do that, very interesting :laugh:

Edit: sql code tag messed up my "greater than"...

Ok, I had a few minutes to kill. There will be a little more work to get this to work with what you have done thus far.

The Function:

CREATE FUNCTION...

I don't have access to a pc at the moment otherwise I would give a better example...

You could accomplish this using a splitter and splitting the strings using the space...

To be fair, Microsoft did give us master data services which has a CLR udf splitter (an awful one) that still requires enabling CLR on so most DBAs just say...

First, for what it's worth - I started as a network guy and moved into SQL because I loved it (I liked Cisco). I even took a little pay cut...

gbritton1 (9/3/2014)

---

I'm using the splitter (just downloaded the zip file) and noticed something odd. Dunno if its just me, but check this out:

select * from dbo.[DelimitedSplit8K](' ', ' ')...

When you join...

First I would see if the query returns anything when you replace

o.StatusID in (Select osl.val from dbo.SplitStringToIntegerArray(@OrderStatusList, ',') osl ) and

o.OrderTypeID = 1

with

where o.OrderTypeID = 1

If you...

If I understand your question correctly you need to do what is referred to as a Left Anti Join Semi Join.

There are a couple ways you can do this:

DECLARE...

The company I work for has offices in a lot of markets (Seattle, NY, San Fran, Chicago, Houston, L.A., etc...). I have seen compensation fluctuate a lot based on cost...

SSAS is the Analysis part of the Microsoft BI stack (SSRS, SSIS and SSAS). Pre-2012 the only components were OLAP cubes (Dimensional model) and Data mining. In 2012 they...

First let's create a function called topn...

CREATE FUNCTION topn(@n int, @x int)

RETURNS TABLE AS

RETURN

(

WITH

E1(n) AS (SELECT 1 FROM (VALUES (1),(1),(1),(1),(1),(1),(1),(1),(1),(1)) t(n)),--10

E2(n) AS (SELECT 1 FROM E1 a CROSS JOIN...

Just a quick note about duplicates.

If the possibility exists for duplicate values then you would use DENSE_RANK instead of ROW_NUMBER. In the examples below I took Lutz' code...