Post deleted as it has been shown to be open to an injection attack

Steve

A great improvement ..... for posting as well as reading what code others have posted.

Using:

SELECT [Seq No], Col1, Col2 FROM mytable

ORDER BY [Seq No], Col2

will give you

Seq no col2 ...

There is no guarantee that when viewing data from a database table that the rows will be displayed in the sequence in which they were input. You control the order...

MSDB - use the sysjobhistory table...it contains Run_Date, Run_Time and Run_Duration data.

Thomyes

A question - your start and end day values suspiciously look as if they are designating a day of the week.. that is start day 1 is a Monday, 2...

See if this helps. If it does please post back so others may benefit.

'Display all the partition functions and schemes on the database.

Dim pf As PartitionFunction

For Each pf In...

01AV01 - May I ask why you want/need the calculator answer? Especially when

In science and engineering, convention dictates that unless a margin of error is explicitly stated, the number...

Sachi

Do not know if this work in SSIS, but when using OPENROWSET I can start either reading or writing by using:

'SELECT * FROM [Sheet1$a4:c]')

Sheet1$ - sheet name

a4:c - row column...

I am going to assume that you are attempting to determine the long running instances of those...

Is there a simpler reference on how to handle images, or references to images in the database? Or can you give me the right spot to start in BOL?...

Look at the SQL Server 2005 Books Online (September 2007)

CASE (Transact-SQL)

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/658039ec-8dc2-4251-bc82-30ea23708cee.htm

C. Using CASE to replace the IIf function that is used in Microsoft Access

CASE provides functionality...

Let me change your T-SQL slightly

declare @N1 decimal(20,10)

declare @N2 decimal(20,10)

declare @f decimal(38,14)

Set @N1 = 11900000.12345678

Set @N2 = 10000000.12345678

Set @f = @N1 * @N2

Select @f

Answer is then ...

Using Books On Line (BOL) look up CAST and CONVERT (Transact-SQL)

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/a87d0850-c670-4720-9ad5-6f5a22343ea8.htm

DECLARE @InvoiceDate DATETIME

DECLARE @Ans AS VARCHAR(10)

SET @InvoiceDate = '2-29-08'

SET @Ans = CONVERT ( VARCHAR(12) , @InvoiceDate...

This will not log the results to a table, but in a test environment you could manually determine the running time by using SSMS and running a series of tests...