Hope you're okay with ugly...

SELECT ID

, col

, rn

FROM

(

SELECT ID

, Col

, Prefix

, NumPart

, ROW_NUMBER() OVER (PARTITION BY Prefix ORDER BY NumPart DESC) AS rn

FROM (

SELECT ID

, col

, LEFT(col,1) AS Prefix

, CAST(RIGHT(col,2)...

Steve,

See if Kevin Boles has any horror stories that aren't confidential. =)

Use a Tally table and a deliberate cross join?

how would I query just those people who are assigned to just the AMB facility? --- kinda contradicts your subject question... but anyway...

If you're filtering for a single value, you...

I don't know of one. Shouldn't be very hard to write. It might be something like:

Device--(M,1)--IPAddress

and then you'd have location, deviceType, etc about each device. Not a...

tracking net IP addresses how? are you one of the poor souls using static IP?

Could you be more specific? Sounds like you need a BYTE for each octet, and then...

Use DelimitedSplit8K[/url] and append the result to a final table?

If there is no data in any of the left join columns, I do not want to display data on the report.

Then why not use an inner join?

I was looking around to see if I could answer your question, but what I found is that v1 may not work with SSRS 2014.

Check out this article.

Damian,

can someone create a stored procedure that brings all the data together into one dataset? I suppose you could write a stored procedure that creates a temporary table and...

Sounds like you could use a subscription to do this. That will handle sending the reports to each user. If you're not using Enterprise, you can use Jason Selburg's...

You can't store "spaces" in a date. Period. Dates are stored as numbers in T-SQL, and you can't store spaces in a numeric field.

For a newb, nice job posting!

This should do it... you might want to play with ROW_NUMBER() for a while... super handy once you figure out how it works.

SELECT y.Class

,...

"I need it to filter on the latest version of each of the 3 documents the person has to sign."

but there's no MAX(Date) anywhere... how are you returning the latest...

the usual way of dealing with a series of IIF statements is nesting them... Here's the barebones structure (which you've sorted out)

=IIF(<test>,<true part>,<false part>)

In your case, I think you...