Maybe for the less patient you can point me to those articles?

Jared

Are there surviving machines that can run SQL 7?...

GilaMonster (12/8/2011)

---

Let's take an example to be absolutely clear.

CREATE INDEX idx_Test ON SomeTable (ColA);

SELECT ColA FROM SomeTable;

SELECT ColB FROM SomeTable WHERE ColA = 137;

The given index is covering for the...

ramanamreddy (12/7/2011)

---

Hello,

I have a column patID with some values( with some condition 1), patID with some columns(with some condition 2).How can I merge all the values into a single patID...

MidBar (12/7/2011)

---

Thanks Jeffrey,

So ISO standard is the strongest reason of choosing this format i.e. "YYYYMMDD HHMMSS" which is widely adopted by most DBAs/Developers and easily understandable in most of DBMS...

Jeffrey Williams 3188 (12/6/2011)

---

MidBar (12/6/2011)

---

OK will we get any advantage in query performance if we write condition in select like this 2011-09-23 11:12:13

OR

can be any dis-advantage if we write like...

MidBar (12/6/2011)

---

OK will we get any advantage in query performance if we write condition in select like this 2011-09-23 11:12:13

OR

can be any dis-advantage if we write like 23/sep/2011 111213?

"YYYY-MM-DD HH:MM:SS...

Not looking back at your original code, you should have indexes first on the columns that you filter on. Was that a date range I believe? Also, if you...

MidBar (12/6/2011)

---

Sorry if my question was not clear, as it was not about datatype date, time, datetime etc. However, question was about storage and retrieval of datetime values and which...

It has to be the data type of the MySql data, because the syntax '2010-01-01' works the same on both MySql and MSSQL.

Jared

Is it possible you have some data problems in the csv? For example, in the column mapping of the wizard, are there more columns than there should be?

Thanks,

Jared

I'm sorry, but this is quite a silly...

Ah yes... 9 to 10. Oops... I still think the best way to do this is to have the columns in the table;

CREATE TABLE ClientVersion (id int identity(1,1), Version...

Being that this is a data warehouse, why not build an aggregate table and run your query against that?

Jared

Run this:

use tempdb

CREATE TABLE #ClientVersion(id int identity(1,1), ClientVersion varchar(20), UserName varchar(20))

INSERT INTO #ClientVersion

SELECT '2.5.0.1','ram'

UNION ALL

SELECT '2.6.0.2', 'suresh'

UNION ALL

SELECT '2.7.1.2', 'ram'

UNION ALL

SELECT '2.5.1.2', 'raj'

UNION ALL

SELECT '2.3.1.2', 'ram'

UNION ALL

SELECT '2.3.0.2', 'gouse'

UNION ALL

SELECT...