Mike,

Why do you need a cursor for this? Can't you just do a basic upsert? Here's some fun reading for you:

An UPSERT example from Paul White

Please define "depth level".

Sounds like this is a great candidate for SSRS.

If you were going to automate this, wouldn't it require at least a one-way trust between the two domains? SneakerNet isn't really automation...

What version/edition of SQL Server are you running?

You could use PowerShell...

Tim Smith

Automating Flat File Imports Using Powershell[/url]

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