Viewing 15 posts - 2,581 through 2,595 (of 3,221 total)
Post deleted as it has been shown to be open to an injection attack
March 18, 2009 at 11:52 am
Steve
A great improvement ..... for posting as well as reading what code others have posted.
March 17, 2009 at 1:20 pm
Using:
SELECT [Seq No], Col1, Col2 FROM mytable
ORDER BY [Seq No], Col2
will give you
Seq no col2 ...
March 14, 2009 at 12:13 pm
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...
March 14, 2009 at 10:37 am
MSDB - use the sysjobhistory table...it contains Run_Date, Run_Time and Run_Duration data.
March 12, 2009 at 12:44 pm
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...
March 12, 2009 at 10:33 am
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...
March 11, 2009 at 4:17 pm
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...
March 11, 2009 at 4:06 pm
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...
March 11, 2009 at 9:36 am
ssismaddy
So, is there any method to log these 7 stored proc timings??
I am going to assume that you are attempting to determine the long running instances of those...
March 11, 2009 at 7:49 am
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?...
March 10, 2009 at 11:32 am
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...
March 10, 2009 at 11:10 am
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 ...
March 10, 2009 at 10:27 am
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...
March 10, 2009 at 8:48 am
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...
March 9, 2009 at 9:04 am
Viewing 15 posts - 2,581 through 2,595 (of 3,221 total)