Can't see your data. Without that, I'm pretty sure we can't do anything. Could you post at least some representative data? (CREATE TABLE and INSERT scripts, not pictures =) )

Never mind. I'm a knucklehead. Bring in all the tables (seems I shouldn't have to?), filter by name, expand tables, append.  "Use the force, Luke!"

• This reply was modified 2 years, 7 months ago by pietlinden.

Why do you want to partition the table? Partitioning a table is for speeding up backup, not speeding up your queries.

(Where's the "SQL Howlers" article that Gail Shaw wrote about...

Use ROW_NUMBER() OVER (PARTITION BY<field list> ORDER BY <field>) where the columns in the PARTITION BY section are the columns you would use to determine uniqueness.

Standard way to do this...

• This reply was modified 2 years, 8 months ago by pietlinden.

You have to sum first, and then use LAG on that result to get what you want... like this... Oh, and since you're new, I created tables for you etc....

are you using Tabular or Multi-dimensional?

in tabular, you don't need a separate date table. Just use ALL() to remove whatever filters you want from the evaluation context.

Are you attempting to restore over the top of another database? (Did you change the name of the database you're restoring? You should have). Once you do that, you can...

"But in this case the business is using Access managing their own Access db. So looking for same functionality but with a SQL Server. Please advise? Thanks in Advance!"

Maybe I...

Could you use EXISTS () with a correlated subquery instead of APPLY? (or is that just brutally slow?)

a generic recipe is something like this:

CREATE TABLE Recipe (

FinalProductID INT NOT NULL,

IngredientID INT NOT NULL,

Quantity INT NOT NULL CHECK (Quantity>0)

CONSTRAINT pkRecipe PRIMARY KEY (FinalProductID, IngredientID)

);

The "amount" output is the...

Disclaimer: I'm not an expert, but this worked for me... I didn't create mad dynamic SQL, but...

("Ingredient" is just some table I had in a database... nothing special.)  But  I...

You can do this with text functions like CHARINDEX, LEFT, RIGHT.

What have you tried?

Google-fu not working? See this page...

use tempdb;
go
DECLARE @MyMachine NVARCHAR(128);
SELECT @MyMachine = CAST(SERVERPROPERTY('MachineName') AS NVARCHAR(128))
PRINT @MyMachine + ' is a piece of junk';

LOL. That's exactly how I feel about touchscreen radio controls. Are those things designed to kill me? I thought the whole idea was to be able to use the radio...

T-SQL is pretty big (there are lots of functions etc). One way to learn it is to break it up into chunks. So you get a database and start asking...