Marie,

That's what I was thinking... It's just easier to do this in steps. Then maybe put them all in a stored procedure, if this has to be done more...

so write it to a temp table and do a series of updates on it.

I tend to validate my design by collecting a list of questions the database has to answer. If I can work through how to design the queries (not necessarily...

REPLACE is your friend. =)

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...