SELECT User, ProcessId, COUNT(*) AS ProcessDupCount

FROM dbo.table_name

GROUP BY User, ProcessId

WHERE ProcessId > 1

HAVING COUNT(*) > 1

This should give you the data type of the column:

SELECT TOP (1) wf.SMP_FLAG

INTO #temp

FROM WF_SMP wf

EXEC tempdb.sys.sp_help #temp

Here's the original post:

"I have a little exercise and would like to know your opinion on the most effective/best way to approach.  Please see the result I am looking for...

You're welcome.

Yeah, you'll need lots of extra disk space.

Presumably the log file is already a big size for a db that includes a table that size.  But you might want...

For example purposes, I'll assume your clustered index is on a $IDENTITY column, say "id".

(10) Create a new table, with the new data types, and the clustered index (only!) from...

You need to convert the "NOT IN"(s) to "NOT EXISTS"(s), like this:

NOT EXISTS(SELECT 1 FROM TB_REINPUT TR WITH (NOLOCK) WHERE TR.ORDER_DATE>=@LAST_ORDER_DATE AND TR.STATION_ID=@P_STATION_ID AND

TR.ORDER_DATE+COMMIT_NO = TB_WORK_ORDER_MFD01.ORDER_DATE+TB_WORK_ORDER_MFD01.COMMIT_NO)

You don't really need sys.indexes in the row-count query:

OUTER APPLY (
    SELECT SUM(p.rows) AS TotalRows
    FROM sys.partitions p
   ...

My approach was similar (I couldn't post to this site for a while):

SELECT 
    text_column,
    LTRIM(RTRIM(SUBSTRING(text_column, CASE WHEN position_after_required_name = 0...

Need the sample data in a directly usable format, not in a picture, which we can't write T-SQL against.

The idea being that you can change the starting day to adjust for any day of the week.  0=Mon, 1=Tues, ..., 5= Sat, 6=Sun.

For example, if you wanted the next...

I use a consistent method for any day, so I don't use techniques like the one given.

Instead, I recommend:

DATEADD(DAY, -DATEDIFF(DAY, 5, S1SDAT) % 7 + 7, S1SDAT)

for example:

SELECT

S1SDAT,

DATEADD(DAY, -DATEDIFF(DAY, 5,...

There is no query that will tell you what index(es) were created in the last few days.  SQL Server itself does not store that info anywhere.

I'm very confused about what final results you want to see.  Here's a query that returns all columns; adjust it to return only the columns you want.

SELECT...

Paul White and/or Itzik Ben-Gan have done write ups on the problem with non-unique sorts.  The solution is indeed to make sure you specify ORDER BY values that will insure...

select m.CompanyId,m.PackageId,m.partsfamilyid,max(m.countparts) as countparts,
    STRING_AGG('(' + CONVERT(VARCHAR(8000), countPartsValues) + ')' + CONVERT(VARCHAR(8000), MSLIDValue),'|') WITHIN GROUP(ORDER BY MSLIDValue ASC) AS MSLDIFF  
from #final m
inner...