Read Jeff's article on DelimitedSplit8K[/url], which contains a download that has the complete DelimitedSplit8K code. (Read the article, and the link is... <should I tell?> ) Once you...

If you are using Windows authentication, then security is handled by Active Directory. You create users and then add them to Groups, and assign the permissions to the groups...

Good point! Especially if you use a pivot table or PowerPivot... but you need Excel 2010 or later for PowerPivot.

You could always just add a column to the addresses table to indicate what type it is (home or work). Then you would just write a case statement to...

Kazmerelda (12/2/2016)

---

So I currently have it so that if the date is the current month, then a red line goes around the column within the matrix report that I have.

What...

" However if I want domain user testdomain/testuser to have access that has been user within the entire database for that user " ???

You can create users and groups in...

You'd have to do something in your stored procedure.

Here's an example of getting all the invoices with fewer than 3 line items:

SELECT i.InvoiceID

FROM Sales.Invoices i INNER JOIN Sales.InvoiceLines il

ON i.InvoiceID...

Okay... rereading this... A Calendar table won't necessarily work. I think this will only work if you know what month all of the absents occurred in. If you can't...

Please do everyone a favor and read this article Forum Etiquette: How to post data/code on a forum to get the best help[/url]

Saying please and thank you without actually listening...

Oh, I get it... you're trying to do the matrix as a crosstab or whatever inside SQL instead of doing it in SSRS. Doing it in SSRS is really...

Maybe I'm missing something, but if you have a bunch of events over a span of time, you could have EventType on columns, Months on rows, and then a count...

I modified the code to make sure it would work... so this is a little different than the last version. Should work with strings of any length as long as...

Sorry, but I beg to differ on your formula... How about

=Right(User!UserID,InStr(User!UserID,"\",CompareMethod.Text)-1)

I'm not sure where you got the value of 10 from... maybe the length of your servername?

As to where...

Some sample data to play with would help a LOT.

One way of doing it is this:

SELECT 100 As Amount, 'AB' AS CustomerID

UNION ALL

SELECT 200 , 'CD'

UNION ALL

SELECT 300, 'BB'

then folks...

I have a stored procedure that returns records by a patient's location in the hospital. I want to be able to return all records EXCEPT those in location = C3....