Generally speaking, if you can provide a clear question, some sample data (create table and insert scripts), and an expected output, you can ask all kinds of questions and get...

Since you're new here... here's an article you owe it to yourself to read (it'll take like 2 minutes!)

Forum Etiquette: How to post data/code on a forum to get...

• This reply was modified 1 week, 2 days ago by pietlinden.

force it to NTEXT?

[ @stmt = ] N'statement'

A Unicode string that contains a Transact-SQL statement or batch. @stmt must be either a Unicode constant or a Unicode variable. More complex Unicode expressions, such as...

clone the report and have the TOP 15 filter on one and not on the other? Just have a hyperlink in each to go to the other report

Are you using your login credentials to run the SSIS packages? I think you need to use different accounts, otherwise, there's no way to tell the two apart.

It already "knows"... That's what SYSTEM_USER returns. For example...

SELECT SYSTEM_USER AS WindowsAccount, be.*
FROM Bakery.dbo.BakeEvents be;

I know, looks really stupid, but the first column is the user running...

I can calculate the new unit cost or value or whatever... But do I store it in something like a stockTake table? Something like this?

CREATE TABLE [dbo].[StockTake](
[StockTakeID]...

In other words, a running total of  Open + Created + Won + Lost

You could calculate them individually and then add... or...

ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW?? (using a...

Don't you optimize workloads and not individual queries? Some queries may get slower if you change indexing, but on the whole, the workload efficiency will increase. I doubt that's something...

Oh, sorry. Silly me! So I just modify the step where it writes the one row ...

 ' Display last table's content.
    ...

• This reply was modified 3 months, 1 week ago by pietlinden.

Why would I need enterprise grade for a one man show? For something he'd run every few weeks?  I'm not processing 100K files an hour.

If you can point out where...

FWIW, I got one way to work... I used Abscess and Excel and a linked table to SQL Server. That way I can just call .RefreshAll() in Excel so that...

Okay, I'm an idiot. It's super simple.

Take the total value of the new inventory

((Unit Price / Unit Weight * Qty Purchased) + (Per Kg Price * Weight On Hand) )...

(You could absolutely cheat and create a hyperlink or a button in your Access front end that opens the SSRS portal, and then you wouldn't really need Access reports at...

I've been looking at a bunch of them. There are several libraries that read/parse PDFs. Guess I'll dig into that.