Viewing 15 posts - 3,016 through 3,030 (of 3,221 total)
Sorry Ken did not see your post before I shoved my two cents in.
A varchar '0' is NOT a valid date-time format. Date formats are 'mm-dd-yy' examples; '07-09-08'...
July 12, 2008 at 3:36 pm
This appears to be what you need to do.
"How to add an incremental counter in a SQL Server 2005 Integration Services package by using a Script component in a Data...
July 10, 2008 at 2:31 pm
Suggest you look at this function available in VB:
DatePart(interval, date[,firstdayofweek[, firstweekofyear]])
The intervalargument has these settings:
Setting Description
yyyy ...
July 10, 2008 at 10:03 am
Rather difficult to assist you considering the minimum amount of information you have supplied.
Please read
http://www.sqlservercentral.com/articles/SQLServerCentral.com/62764/ and then reply here with the essential information so that you can receive meaningful...
July 10, 2008 at 9:49 am
Before ruling out 2005 read up on the compatability level .. when set it determines how SQL statements will or will not function.
Level Server Revision
60 = SQL Server 6.0...
July 9, 2008 at 11:03 am
Most unusual - got the same identical error this morning using SSMS. Unusual in that last night about 10 PM all was fine. Decided to shut down my...
July 9, 2008 at 6:38 am
A possible approach is to open your app with a simple form with a window for entering the users SQL Server Login Name - which may or may not be...
July 8, 2008 at 4:46 pm
Having submitted 4 QOD and struggling to insure that they were clearly worded I can understand the authors problem and appreciate all his work but before condemning BOL may I...
July 8, 2008 at 9:08 am
Did you look into the SDK offered as a free download?
It could give you sufficient information so as to be able to write a program using a flavor...
July 7, 2008 at 6:52 pm
From Books on Line (BOL)
Date and Time (Transact-SQL)
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/9bd1cc5b-227b-4032-95d6-7581ddcc9924.htm
Then more from BOL
CAST and CONVERT (Transact-SQL)
specifically CONVERT ( data_type [ ( length ) ] , expression [ , style ]...
July 7, 2008 at 6:41 pm
In addition to what the others have told you add this aide:
The following will find all views in a database containing the specified text (that is the table name you...
July 7, 2008 at 4:28 pm
Being a developer in a company unit of some 600 potential users of a application we start out by selecting a group of users ( 2 to as many as...
July 7, 2008 at 12:01 pm
Jeff ran your codea and got the following:
@Day @monday ...
July 5, 2008 at 2:44 pm
Think I have it now:
DECLARE @SomeDate AS DATETIME
DECLARE @Day AS INT
DECLARE @monday AS DATETIME
DECLARE @friday AS DATETIME
SET @SomeDate = 'date in week desired '
SET @Day = (SELECT DATEPART(weekday, @SomeDate)-1)
SET...
July 5, 2008 at 12:20 pm
FORGET THE SOLUTION PRESENTED WHEN THE DAY OF THE MONTH BECOMES A DOUBLE DIGIT for example July 15th THE T-SQL POSTED ABOVE DOES NOT WORK PROPERLY
I should have test...
July 5, 2008 at 11:16 am
Viewing 15 posts - 3,016 through 3,030 (of 3,221 total)