Cross post ; Please pour your suggestion at http://www.sqlservercentral.com/Forums/Topic928725-391-1.aspx

To add on, the manual right-click-extractall available in Windows is carried out by zipfldr.dll in the background; As DLLs cant be worked over from command line, you have no option...

Here are some example on how to use 7-zip : 7 Zip Examples from dotnetperls.com

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!