Doesn't a simple select with TOP & ORDER BY clause do the task?

SELECTTOP 1 id, Eff_Date, DATEDIFF( MINUTE, Eff_Date, GETDATE() ) AS DateDifference

FROM[log]

WHEREecode = 100

ORDER BY DateDifference

Jeff Moden (6/1/2009)

---

3. Requires execute permissions on xp_cmdshell procedure, if multiple files needs to be imported. Most of the DBAs are reluctant to grant permissions on this object as...

You can do this by adding a derived column transformation and then setting the output column value to this variable and then use this derived column in destination component within...

Jeff Moden (6/1/2009)

---

Bulk Insert. On a slow server, it'll load and do some data integrity checks while offloading "bad records" to a "rework file" on a 5.1 million row,...

Don't cross post, it just fragments the replies. Continue discussions here

Verify the data in the table that you have values > 500 characters by using LEN function. For e.g.

SELECT LEN( comments ) FROM myTable

If you are working with SQL 2005 then you might want to have a look at the ROW_NUMBER() function which would quite faster than the EXCEPT operator.

Personally, I prefer prefixing the table name to all columns except foreign keys. It makes easier to understand and write code when joins are involved. For e.g.

SELECT Cust.ID,...

Hey Jeff, I really appreciate you for taking time in detailing the solutions, listing out the issues with them & testing them.

BTW, I am ducking down:hehe:, in case the high...

Indeed, it does not work when prefixing wildcards...

Instead of setting the ResultName=CurrStatus, set ResultName=0 if it is the first column of the resultset.

Appreciate for the feedback.

DURGESH (5/29/2009)

---

hi all,

I have a table as follows

col1 col2

aa ...

You can use wildcard characters in CONTAINS predicate. For e.g.

WHERE CONTAINS( description, '"civi*"' )

See the following article that exactly does the same.

http://vyaskn.tripod.com/search_all_columns_in_all_tables.htm