diva.mayas (6/29/2010)

---

Hi

Can we have more than one identity columns in a table.

if yes then why, if no then why

i am interested to know the reasons behind it....

You're getting there, but you need to take another look at your tables, there should be many more than the two listed. I'd guess about 15.

For instance:

Table StationVehicles

StationVehTypeID VehicleTypeStation...

Well said Paul, couldn't agree more.

scottichrosaviakosmos (6/29/2010)

---

i want to get date difference like a start date and end date and find difference in years but i want like if for example one date is 2007...

Me neither Kingston but it's always nice to have an alternative.

eng.khiat (6/29/2010)

---

SELECT * FROM

(

SELECT top 10 * FROM tableX ORDER BY ID DESC

) AS A

ORDER BY A.ID ASC

It gives error and when i searched...

Potso, none of your sample data posts match up with each other, the column names and contents are all over the place, and your query would generate an error if...

Import the contents of the flat file into a staging table in your db. Assume the data is dirty.

Perform any necessary validation against the staging table - including dupe-flagging.

Transfer...

Of course. SELECT...INTO...FROM...

Best practice is to check for existence of...

Coffindodger

priya__ (6/28/2010)

---

Thanks all for your reply,

I cannot use SUM as I am counting a Key column here and if I use sum it will sum up the columne instead...

I have...

Or this way:

;WITH FastAggregate AS (

SELECT , col1, COUNT(*) AS RowCounts

FROM table1

GROUP BY , col1

)

SELECT ,

SUM(CASE WHEN col1 IS NULL THEN RowCounts END) AS 'nullcnt',

SUM(CASE WHEN col1...

Et tu, Gianluca.

The simple CASE uses equivalence: CASE i WHEN NULL is the same as CASE WHEN i = NULL...

To check for NULLS you must use the searched CASE: CASE WHEN...

The question reads "What will be the output of the following?" and none of the answers...