JasonH-ITG (1/6/2017)

---

Nope, not in my case; it had persisted between restarting SSMS and reboots. It was only occurring on one of my servers; workstations and other servers did not...

WITH cte

AS

(

SELECT tbl1.Date, tbl1.ID, tbl1.Order_Amount, tbl2.StoreNum, ct = COUNT(tbl1.id) over(partition by tbl1.id)

FROM tbl1 right join tbl2

ON tbl1.ID = tbl2.ID

)

SELECT * FROM cte

WHERE ct > 10

I suspect the problem was...

JasonH-ITG (1/6/2017)

---

Sorry for replying to an old post, but THANK YOU! This fixed the issue for...

mikevessey (1/6/2017)

---

hey,

nobody said you had been tripped up... in fact I said that I had been tripped up before

in sql 2000 days people always said PHYSICAL storage order. most...

mikevessey (1/6/2017)

---

I've been tripped up by this before too

The key point is PHYSICAL .

A clustered index does not determine the order it is stored on disk.

I went to a...

Phil Parkin (1/6/2017)

---

On your SQL Server instance, in SSMS, go to

Server Objects/Linked Servers/Providers and check which version of the ACE driver appears there.

Assuming version 16 is there, try running...

On your SQL Server instance, in SSMS, go to

Server Objects/Linked Servers/Providers and check which version of the ACE driver appears there.

Assuming version 16 is there, try running the export...

RonKyle (1/6/2017)

---

SSIS is a maintenance nightmare! Avoid SSIS like the plague. It's for people who shouldn't be coding at all! About the only exception I can think of is if...

mikevessey (1/6/2017)

---

lets be clear on that point....

a clustered index does not prevent duplicates

a primary key (normally also the clustered index) or also a unique constraint will prevent duplicates

the clustered index...

John Magnabosco (1/5/2017)

---

I am working on an ETL process which pulls from several APIs. Essentially, I capture the JSON output and then leverage OPENJSON to parse the output. I have...

1) Helps validation by ensuring there are no duplicates (of course, you may not always want this)

2) Maybe...

Luis Cazares (1/5/2017)

---

My suggestion is that you insert parameter values into a table for each parameter.

Basically, your stored procedures would have a format similar to this:

CREATE PROCEDURE SomeReport (

...

Fuseball sounds like it could go off with a bang.

Of...

Does anyone have any idea why a thread I created yesterday

http://www.sqlservercentral.com/Forums/FindPost1847804.aspx

appears to have removed or marked as spam?