you could let a user connect to SQL Server from Access and import a bunch of data from stored procedures, views, or tables (or or or), or let someone with...

SELECT  ListValue,...

FROM <table>

WHERE ListNumber = @ListNumber ;

So the table would be something like

CREATE TABLE ListValue (ListNumber INT, ListValue VARCHAR(10));

GO

INSERT INTO ListValue VALUES(1, 'A'),(1,'B'), (2,'C'),(2,'D');

Didn't Steve answer your question? Seemed pretty clear to me. you just overwrite the ID = 1234 with another value.

insert into Student (studentid,

StudentName,

StudentKey,

StudentAccKey,

StartDate,

EndDate)

SELECT 9786,

StudentName,

StudentKey,

StudentAccKey,

StartDate,

EndDate

FROM Student std

join casetype...

Sounds like a job for EXISTS (SELECT 1 FROM...) AND NOT EXISTS (...)

Then you could do something like create a stored procedure to get the data you want, then use SSIS to export it to an excel file, then schedule it to...

One way to do it is to create a stored procedure that returns just the rows and columns you want, and then call that from Excel.

you just specify the source...

Something like this? (Well, it's a starting point!)

Oh right... nearly forgot MATCHED is a T-SQL keyword, and so is USER_ID

use tempdb;
go

create table matched
(match_id int identity not null...

You're joking, right? This is database 101 stuff.

* How many days of data do we have ?  DISTINCTCOUNT(date) from your data table?

* Counts of rows by each day

SELECT c.date, COUNT(*)...

If you're going to consume this in SSRS, I'd write it in a stored procedure.

Look at windowing functions. You can expand the time window....

SELECT DimDate.Date, AVG([Amount]) OVER (PARTITION BY Date...

• This reply was modified 3 years, 1 month ago by pietlinden.
• This reply was modified 3 years, 1 month ago by pietlinden.

Where are you doing your reporting? If you're doing it in Excel or PowerBI, use DAX, not T-SQL to calculate it.

Let me rephrase my question... (Ask the wrong question, get a useless answer! LOL)

If the users are going do their own analyses with the data, then I would go the...

Is this for reporting? If you're using {SSAS Tabular, Excel, or PowerBI} then DAX is baked right in. "Use the force, Luke!"

The first book I read on DAX was Rob...

I think this may be destined to fail. Convincing him to do simple things like separating his personal and business purchases into separate receipts from Costco is a challenge. Hate...

Nobody's going to download a file that can have viruses in it.

Can you post at least some of it here?

Split the datetime column into two columns, one for the date, and another one for the time. Then your calendar table will work. And you can create a time dimension...

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