If you really want help, help us help you.

Post TEXT, not pictures. And if you're stuck on something, post what you tried. We're not here to do your homework. Ideally,...

I don't see any way to group these so that you can use ROW_NUMBER() with a PARTITION clause. Can you explain how these are supposed to group? If you can't...

I created this measure using the allselected function.

Could you post the code for it? Something like

DIVIDE ( [Total Sales], CALCULATE([Total Sales], ALLSELECTED('Calendar'[Month]))

https://www.mssqltips.com/sqlservertip/6338/sql-server-backup-size-vs-database-size-script/

Thanks for the data setup... this matches your expected output...

SELECT *
FROM dbo.Sales s
INNER JOIN dbo.FiscalPeriods fp
ON s.DOCDATE>=fp.FirstDate AND s.DocDate<=fp.LastDate;

You may create a staging table, populate it with the data from a trigger and use a job to output the data to a file.

I guess use the Inserted virtual...

Unless I'm reading it wrong, sounds like you could use Service Broker for that...

"Here are some examples of reasons you might use Service Broker:

Asynchronous triggers. You can construct asynchronous triggers either...

Created a User DSN, and it worked a champ.

Then for fun I created a trivial stored procedure just to see if I could call it.

CREATE SCHEMA junk;

CREATE...

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

something like this?

SELECT DISTINCT ID
FROM Response r
WHERE EXISTS (SELECT 1 FROM Response r2 WHERE r2.ID = r.ID AND r2.result = 'Y')
AND EXISTS (SELECT 1 FROM Response r2...

=IIf(Round(Fields!Qty1.Value,3) = Round(Fields!Qty2.Value,3),"Red","Black")

This almost worked <g>.

DECLARE @tableName NVARCHAR(50);
DECLARE @TemplateSQL NVARCHAR(500)=
'SELECT *
INTO #tempData
FROM dbo.MikeyData n
EXCEPT
SELECT *
FROM #tempData d;';

DECLARE @InsertSQL NVARCHAR(500);

DECLARE tables_cursor CURSOR  FAST_FORWARD
    FOR 
SELECT ao.name
FROM...

What are your options?

If you can use SSRS, it's stupid easy.

Can you use a matrix in .NET? (Well, SSRS is an ASP.net application, so I would think so.)

I created a table for this... (Far easier to do in SSRS with a matrix visual)

now someone who's better at Pivot than I am can have a play.

            
September 1, 2020 at 2:26 pm
            
#3785215

            
            
                                                
        

Got some sample records?  And how about a couple of CREATE TABLE scripts. Or do you have something against tested queries?

So what's your question? You want to split the last and first names into separate columns in your SQL query? (I would do that... makes querying much easier and faster).