ffarouqi (1/18/2016)

---

Fyi...we've used isdate to eliminate the non-date stuff, but the problem still persists. Kindly, let me know which piece of code is causing the issues, because if I run...

qbrt (1/18/2016)

---

I am in the process of transitioning our eCommerce database to the declarative model of SSDT to move the database development process into our CI pipeline. Using idempotent MERGE...

tusharchpatil (1/18/2016)

---

Hi All,

If i used select * from emp where rownum < 5;

I am getting the correct output of table ie. 4 rows.

but it is not working on rownum >...

Dreamsz (1/18/2016)

---

Hi,

I am facing an issue as described below.

select * from dbo.xyz

where a in ('a string of multiple values')

and <some condition>

and cast(a as datetime)=cast(b as datetime)

a is varchar(50), and...

ROW_NUMBER() is your friend here. Something like:

select rw = ROW_NUMBER() OVER (PARTITION BY KEY_NO ORDER BY DATA)

My pleasure. Glad you got it working.

Have you considered putting 'lag' in your CTE, to get 'previous' price and then selecting from your CTE if price <> previous price?

Welsh Corgi (1/15/2016)

---

Phil Parkin (1/15/2016)

---

Welsh Corgi (1/15/2016)

---

drew.allen (1/14/2016)

---

No, you don't....

Welsh Corgi (1/15/2016)

---

drew.allen (1/14/2016)

---

No, you don't. You can use...

Are you referring to this type of table variable?

The older type of table variable is not in-memory. Nor is it good for holding large quantities of data.

Welsh Corgi (1/14/2016)

---

I execute the following Query:

INSERT INTO POSTAL (ID,Latitude, ID.Longitude, CityTownshipID, CountyRegionID,StateProvinceID,CountryID)

SELECT ZipCode, Latitude, Longitude,CityTownshipID , CountyRegionID, StateProvinceID, CountryID

FROM Postal_Codes_Import

WHERE NOT EXISTS (SELECT *

...

Welsh Corgi (1/14/2016)

---

Phil Parkin (1/14/2016)

---

The WHERE NOT EXISTS () construction often performs better than using a LEFT JOIN – I would recommend a test.

You should include table schemas in your...

The WHERE NOT EXISTS () construction often performs better than using a LEFT JOIN – I would recommend a test.

You should include table schemas in your code to avoid the...

Why would the Id be the same as the ZipCode?

Script Component Source is where I would start, yes ...