Looks like you need two instances of TB_EMP to join on the welder key and another to join on the Operator key.

1 lakh = 100,000

Are you trying to create an aging query, so that each invoice is "binned" by age, which is determined by [DocDate]? (the usual is something like "less than 30 days",...

• This reply was modified 5 years, 4 months ago by pietlinden. Reason: code reformat
• This reply was modified 5 years, 4 months ago by pietlinden.

Just to see if I could do it, I wrote some code to do the testing for me... <g>

I shamelessly stole Phil's checking code.... Seems to work, though.

            
July 22, 2020 at 6:34 pm
            
#3773927

            
            
                                                
        

Steve,

Since it's only looking at column names and not rows of data, it seems this could be done easily with a little bit of dynamic SQL (just get a list...

Maybe this and use it as a cursor so I can create the columns that way?

use tempdb;
GO

IF OBJECT_ID('tempdb..#Test2') IS NOT NULL DROP TABLE #Test2
CREATE TABLE #Test2
(A int,...

That many points and no consumable data?

SvcAcct is used on different ServerNames

SELECT ServiceAccount
FROM Accounts a INNER JOIN Servers s ON a.ServerID = s.ServerID
GROUP BY ServiceAccount
HAVING COUNT(*)>1

Oh, so it's not an "out of the box" thing. I was watching one of Brent Ozar's videos on SSMS, and I thought it was. Thanks! Might have to splurge...

That's...

I believe that the editor window colors are a windows user specific setting, not a SQL session specific setting.

=(

Drat. So at least I might not be as dumb as I...

DECLARE @p_start_date DATETIME = CAST('2017-12-01 00:00:00' AS DATETIME);
DECLARE @p_end_date DATETIME = CAST('2017-12-31 00:00:00' AS DATETIME);
SELECT
DATEDIFF( HOUR
, @p_start_date
, @p_end_date
);

Like this maybe?

DELETE
FROM #tblTest1
WHERE ID IN (
SELECT ID
FROM #tblTest1 t1
CROSS APPLY STRING_SPLIT(t1.SName, '/') ss
WHERE ss.value  IN (SELECT SName FROM #tblTest2)
);

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

Did you try running SSMS as admin, too?

One way is to use a Calendar table, and to include Fiscal Month and Fiscal Quarter, and join to that. And then do the pivot

Without a Contacts table, you can't do it.

You'd get all the contacts who had been contacted in the last 18 months, and then exclude those ContactIDs from those in the...

STRING_AGG()?

USE AdventureWorks2017;
GO

SELECT OrganizationLevel
, STRING_AGG(CONVERT(nvarchar(max), JobTitle), CHAR(13)) AS csv
FROM HumanResources.Employee
GROUP BY OrganizationLevel;