Viewing 15 posts - 5,626 through 5,640 (of 26,490 total)
Mat Cooke (1/14/2015)
Indeed!!Incorrect syntax (on sql 2000)
Works fine on 2008 R2
It would also fail on SQL Server 2005. It is the construct of the Insert statement. On SQL...
January 14, 2015 at 12:28 pm
... Mark one off, 45 days on the calendar to go. 45 days on the calendar to go, 45 days to go, ...
January 13, 2015 at 9:31 pm
How do you know the year?
January 13, 2015 at 7:54 pm
Koen Verbeeck (1/13/2015)
FYI, I received the Author of the Year award at MSSQLTips.com!Thanks everyone for voting!
Congratulations.
January 13, 2015 at 2:08 pm
... Mark one off, 46 days on the calendar to go. 46 days on the calendar to go, 46 days to go, ...
January 13, 2015 at 8:47 am
Alvin Ramard (1/12/2015)
Lynn Pettis (1/12/2015)
Alvin Ramard (1/12/2015)
Lynn Pettis (1/12/2015)
Steve Jones - SSC Editor (1/12/2015)
Test drove a few cars over the...
January 12, 2015 at 4:21 pm
Alvin Ramard (1/12/2015)
Lynn Pettis (1/12/2015)
Steve Jones - SSC Editor (1/12/2015)
Test drove a few cars over the weekend. After selling the...
January 12, 2015 at 4:16 pm
Steve Jones - SSC Editor (1/12/2015)
Test drove a few cars over the weekend. After selling the 911, I'm looking for...
January 12, 2015 at 3:49 pm
Brandie Tarvin (1/12/2015)
Lynn Pettis (1/12/2015)
January 12, 2015 at 11:22 am
Something else to remember. If your CF application is accessing data from the SQL Server database using stored procedures there will be changes to this process if you move...
January 12, 2015 at 10:02 am
Brandie, just curious, when you are importing the file how is it inserted into the table(s)? Does the data go in sequentially on the clustered index? What I...
January 12, 2015 at 9:48 am
Still before midnight Afghanistan time so this count is still valid:
... Mark one off, 47 days on the calendar to go. 47 days on the calendar to go, 47 days...
January 12, 2015 at 9:19 am
My suggestion, prior to posting any code, run it in an empty database. Post it when everything runs without error.
January 11, 2015 at 3:23 pm
Mile Higher Than Sea Level (1/11/2015)
SELECT * into [ATempTable2]
FROM ...
January 11, 2015 at 3:00 pm
Mile Higher Than Sea Level (1/11/2015)
CREATE TABLE [dbo].[tblAPD_Fed_ST_CO](
[intID_APD_FedStCo] [int] IDENTITY(1,1) NOT NULL,
[ID_Wells] [int] NULL,
[txtFedStCo] [nvarchar](9) NULL,
[lngID_APD_Status] [int] NULL,
[lngID_Reg_Office] [int] NULL,
[Dt_APD_Sub] [datetime2](0) NULL,
[Dt_APD_Apv] [datetime2](0) NULL,
[txt_APD_Apv_Status] [nvarchar](12) NULL,
[blnApprovalCancled]...
January 11, 2015 at 2:58 pm
Viewing 15 posts - 5,626 through 5,640 (of 26,490 total)