Actually ACCT IN (111, 222, 555, etc.) is shorthand for ACCT = 111 OR ACCT = 222 OR ACCT = 555, etc., so they are equivalent in terms of performance.

Drew

There's not much that you can do to fix bad data, especially if there is no apparent pattern to the bad data. You should go to the people who...

You're overcomplicating things. There is no reason to use windowed functions here. You want a simple aggregate.

-- original code with windowed functions

select catalog_name, CatalogCount, Last_update_time from

(

...

ChrisM@Work (12/28/2016)

---

drew.allen (12/19/2016)

---

Aggregate functions automatically exclude NULL values, so this can be simplified.

SELECT *

FROM (

SELECT

*,

rn = ROW_NUMBER() OVER(PARTITION BY ProductId, ObjectId ORDER BY CheckNumber DESC)

FROM EuroLuxProductBE.dbo.pdt_multidimensions m

CROSS APPLY...

Simon Hammill (12/27/2016)

---

Hi Guys,

Thanks for the replies, after a bit of playing about I finally got it to work as I needed. I used the below code.

SELECT a.accomname, a.availno -...

wweraw25 (12/27/2016)

---

Try this.

DECLARE @TableName As varchar(500), @TableSchema As varchar(500)

DECLARE @sql NVARCHAR(MAX)

SET @TableName = 'Table_Name'

SET @TableSchema = 'dbo'

SELECT @sql = STUFF((SELECT

'

UNION ALL

select ' + QUOTENAME(Table_Name,'''') + ' AS Table_Name,...

Chris.McCarty (12/27/2016)

---

Hello,

how to write a query - to exclude the field that starts with ING

select * form table where ID NOT LIKE 'ING%' ?

I want to exclude ING from all...

AZ Pete (12/23/2016)

---

All,

Two part question:

1) Given a table with N columns (N1, N2, N3, N4, ... etc) and assume that column N1 is a clustered PK and column N2 has...

If the two tables are exactly the same, couldn't you just drop the empty table and rename the remaining table? Of course, that wouldn't get rid of your duplicates.

Another...

ben.brugman (12/23/2016)

---

Did take a better look at the code. I am not familiar with the "BETWEEN UNBOUNDED PRECEDING AND 1 PRECEDING" part.

But I do think I do understand the code....

Thom A (12/26/2016)

---

Firstly a brief explanation of how AND and OR statements work. I noticed that you have a mixture of AND and OR without any brackets, which is likely...

In my very small scale tests, it appears that using the XML count function is much slower than using the SQL count function. Try the following:

NumberOfDeleiveries ...

This seems to perform faster.

SELECT t.Value

FROM @Test t

GROUP BY t.Value

ORDER BY MIN(t.Id)

Drew

Talkers

KGJ-Dev (12/22/2016)

---

Hi,

Below the sample data

select 'verify1' union all

select 'verify1' union all

select 'verify1' union all

select 'chance1' union all

select 'chance1' union all

select 'chance2' union all

select 'chance2'

I need to get...