You could also use 7-Zip from Sourceforge ; its as freeware compress/decompress utility that has GUI as well as command line abilities.

Links : 7-zip offical site[/url]

...

To learn more about DATEPART function, click on the following link.

Link : DATEPART (Transact-SQL)

hope this helps you!

C'est Pras!

Subhro, try this

use IRISDW_AF;

select Container_Id,End_Journey_Date

from dbo.Container

where datediff(day,day('1/29/2009 12:00:00 AM'),day(End_Journey_Date))<=5

-- Filter with Datepart(year)

AND DATEPART(yy,'1/29/2009 12:00:00 AM') = DATEPART(yy,End_Journey_Date)

;

Tell us if that helped you!

Write a CLR proc and open up IE.. in the CLR proc u can utilize the Process class and run this code

start iexplore.exe this code is to open IE from...

You need to cast the COUNT to DECIMAL/NUMERIC ;

try this:

SELECT ColumnA, COUNT(ColumnB) AS TotalApps ,

(100.00 *...

WayneS (5/26/2010)

---

Since DateDiff returns the number of boundaries crossed in comparing these two dates, it will report the wrong age if...

You can use DATEDIFF function:

LIke:

SET DATEFORMAT DMY

SELECT DATEDIFF(yy,'21-03-1985',GETDATE()) AGE

WayneS (5/26/2010)

---

Paul White NZ (5/26/2010)

---

Is the current column defined as NOT NULL? If so, there is a neat trick that makes it almost instant regardless of the number of...

Kalyan, no, ISNUMERIC cannot be used as a detector to check if a column contains only numerics

Try this:

DECLARE @t TABLE

(

YCol varchar(10) NOT...

😛 :hehe:

One of the excellent book:

Inside Microsoft SQL Server 2005: T-SQL Querying by Itzik Ben-Gan

Link : http://www.amazon.com/Inside-Microsoft-SQL-Server-2005/dp/0735623139

Wow, nice that you understood the concept and appreciating it! Cool! 😎

Cheers, Ken!

I would also recommend you to go through the following article on how to post readily consumable data

CLICK HERE FOR FORUM POSTING ETIQUETTES - JEFF MODEN[/url]

Hope the code above this...

Hi there, here is a piece of code that wll do what you wanted:

As you are first time poster, i took the onus on my side to create DDLs for...

I echo skcadavre here ; Long verbal questions wont attract anyone; but when u post the following, i tell you, you will receicve excellent tested code back:

so, Please post;

1. Table...