|
|
|
January 2003 March 2003 April 2003 May 2003 June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 April 2008 |
Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 Internal SQL Server error on SQL Statement Posted by Catch_22 at 3/25/2007 9:38:19 PM Hi,
I'm have a stored procedure running on an SQL Server 2000 database.
One particular SQL statement is failing (listed below) :
DELETE t_PaymentLN
FROM t_Payment inner join t_PaymentLN
ON t_Payment.PaymentID = t_PaymentLN.PaymentID
inner join t_StgSASummary
on t_StgSASummary.CustomerN...more >>
Import data from linked server Posted by bubbles at 3/25/2007 9:05:48 PM TSQL rookie, using SQL Server 2005 Enterprise.
Need to import several tables from a linked server (SQL Server 2000)
on a nightly schedule.
Question:
1) How to import a linked-server table into my local server?
(No need for checks - just SELECT INTO)
2) How to set up a scheduled job t...more >>
Help with dynamically declaring cursor column names Posted by pgouellette NO[at]SPAM fuse.net at 3/25/2007 8:24:50 PM in SQL Server 2000
I have a table defined as below:
CREATE TABLE [tblPFW_Data_Load] (
[Company] [nvarchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT
NULL ,
[PFW Account No] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS
NOT NULL ,
[Account Type] [nvarchar] (20) COLLATE SQL_La...more >>
Frustrated! Trying to compare student answers (Tbl1) to answer key (Tbl2) Posted by sans_spam NO[at]SPAM yahoo.com at 3/25/2007 8:13:21 PM I thought this was pretty simple but I'm finding it's not. I have 2
tables, 1 called tStudentResponses and 1 called tTeacherAnswerKey.
All I want to do is take the 10 columns from the tStudentResponses
table and compare them to the correct answers in the 10 columns in the
tTeacherAnswerKey tab...more >>
How can I find the best optimalization for the query performance? Posted by Oscar at 3/25/2007 5:48:50 PM In case I run any SQL query within my VB application for the first time
after that I started my application, the performance of SQL server 2005 to
create the recordset is the slowest. For example it takes 30 seconds to
process the following query :
"SELECT ID_wrn FROM tblArbCtr WHERE Contra...more >>
Decimal Precision limited to 4 digits to right of decimal? Posted by cpnet at 3/25/2007 5:14:37 PM I need to store some values in my SQL Server 2005 database with 4-5 digits
to the left of the decimal and about 14 to the right. I tried creating
columns with the type: decimal(38,19). I would expect this would give me 19
digits to the right and left of decimal. I've copied a value into thi...more >>
Date range check Posted by cpnet at 3/25/2007 3:40:08 PM I have a table that associates zip codes to towns. A zip code associated
with a town may change over time, so I'm also associating a date range with
the pair. I want to make sure that a given zip code is only associated with
a single town for any period of time. For example, 90210 may be a ...more >>
Saving a COPY of SSIS Package to SQL Server Posted by DickChristoph at 3/25/2007 3:16:50 PM Hi
I just installed Visual Studio 2005 Professional Edition which includes SQL
Server 2005 Developer Edition on my home machine. I have updated my SQL 2005
Dev. Edition to SP2. I have also updated Visual Studio 2005. I got these
updates from the Windows Update site.
I am trying to Save a...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
String Concat - An easy one! Posted by Monty at 3/25/2007 12:44:49 AM OK, it must be late at night.... why am I getting the error "Incorrect
syntax near '+'." on this line:
RAISERROR(' blah ' + ' blah ')
TIA...
...more >>
Ram size Problem Posted by Roy Goldhammer at 3/25/2007 12:00:00 AM Hello there
On the server i'm working with the ram size is close to 1.7 GB and the
server has 2GB ram.
No one is on the system right now. What i need to do to decrease the ram
size?
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |