Viewing 15 posts - 2,821 through 2,835 (of 3,221 total)
You would obtain better help if you followed the procedures recommended in the article in my signature block.
Now assuming that the attendance table includes
A row for each employee,...
September 29, 2008 at 12:46 pm
Is this what you are searching for?
SELECT REPLACE(CONVERT(VARCHAR(15), GETDATE(),101),'/','')
For today this returns 09292008
or this
SELECT REPLACE(CONVERT(VARCHAR(15), GETDATE(),104),'.','')
For today this returns 29092008
or this (Thanks to Jeff Moden for reminding me of...
September 29, 2008 at 12:11 pm
This might help:
FROM BOL for 2005
http://msdn.microsoft.com/en-us/library/bb326281(SQL.90).aspx
The SQL Server Database Engine cannot continue executing the query because it is trying to read data that was updated or deleted by another transaction....
September 27, 2008 at 6:25 pm
You can obtain a list of all defined extended properties by querying
sys.extended_properties catalog view and insert that into a cursor as you seem to want to do. (Please...
September 27, 2008 at 3:07 pm
I would recommend that you examine the use of an "Application Role". You can search SQL Server Central there has been a number of articles explaining it use....
September 27, 2008 at 9:04 am
You could use OPENROWSET in your T-SQL statement which would write your output to an Excel workbook
An example is:
INSERT INTO OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=D:\MSSQL\Test.xls', 'SELECT * FROM [Sheet1$]')
SELECT * FROM...
September 26, 2008 at 5:23 pm
Try this:
SELECT Hours, CAST(SUBSTRING(CAST(Hours AS VARCHAR(40)),CHARINDEX(':',Hours)-2,2) AS INT)
AS 'Int Hours' FROM Table1
Table1 contents as displayed in SSMS open table
9/26/2008 4:46:20 PM
9/26/2008 4:46:22 PM
9/26/2008 4:46:24 PM
9/26/2008 5:01:01 AM
9/26/2008...
September 26, 2008 at 3:58 pm
You might want to try:
SELECT * FROM sys.sql_modules WHERE Definition LIKE '%tablename%' OR Definition LIKE '%tablename%'
Now this could get to be tedious what with adding the OR clause so as...
September 26, 2008 at 9:25 am
SQL Dba 808.
I have used Excel to report similar information to management using graphs with a twist. I found managers not so interested in what the situation was last...
September 26, 2008 at 8:17 am
Remember what the definition of DECIMAL includes:
Precision is the number of digits in a number.
Scale is the number of digits to the right of the decimal point in a...
September 26, 2008 at 7:29 am
Have you tried using Information_Schema.table_constraints?
September 25, 2008 at 10:38 am
nithin
This appears to be a rather under normalized design and my first suggestion would be to look at your design. The other 60 odd values if as you state...
September 25, 2008 at 9:46 am
In the dim distant past, having worked for a division of the Union Carbide Corp. (since gone belly up and sold) where at the end of your first year of...
September 25, 2008 at 8:41 am
mark
But why say DateTime2 and not BigDateTime?
Who truly knows. I find the collective mind of Microsoft to be somewhat like a split personality. Occasionally the Marketing...
September 24, 2008 at 5:59 pm
mark.nijhof
From BOL 2008 read the subject Datetime(Transact-SQL) I would say that Microsoft's developers have felt the same anguish (or puzzlement) about handling date and time data as you have expressed...
September 24, 2008 at 3:15 pm
Viewing 15 posts - 2,821 through 2,835 (of 3,221 total)