Stack Overflow
Stack Overflow

Questions tagged [sql-server-2000]

Use this tag for questions specific to the 2000 version of Microsoft's SQL Server. Note that as of April 9, 2013, Microsoft no longer supports this version of SQL Server, to the point that even security patches are no longer created.

SQL Server 2000 (codename Shiloh, version 8.0), released in September 2000, is the successor to SQL Server 7.0.

2588 questions
0
votes
2 answers

Multiple sub queries

Is it possible to get the result as below from the same table date-wise records: Enrolled Enrolled as Email Enrolled as Text Deals Redeemed 7 5 2 6 9 …
Vishal Suthar
  • 17,013
  • 3
  • 59
  • 105
0
votes
3 answers

Data not coming to ListBox after query

I have a ListBox on .aspx web page in which I am trying to fetch the data from the DB. The query is in the form of a stored procedure and the following is the ListBind(string queryPart) method that I am using. private void ListBind(string…
Cipher
  • 5,894
  • 22
  • 76
  • 112
0
votes
1 answer

ASP.NET 1.1 Transaction Spanning Two Databases

How can I use an ADO.NET Manual Transaction to remove records across two databases (on same server)? I came across this: TransactionScope in .NET 1.1 But would still like to use .NET 1.1 Manual Transaction if possible.
IrishChieftain
  • 15,108
  • 7
  • 50
  • 91
0
votes
4 answers

How to avoid duplicate values

Table1 ID fromdate todate 001 23/02/2012 27/02/2012 002 23/02/2012 27/02/2012 003 28/02/2012 09/09/2013 .... Condition: I don't want to show duplicate values, so from date validate with other from date, if it's equal then it should not repeat,…
JetJack
  • 978
  • 8
  • 26
  • 51
0
votes
1 answer

SQL parameterization

I'm writing a sql query for an SSRS report and wanted to paramterize the @startdate and @endate fields for the user to specify. Yet when I put my query into SSRS, the user input is ignored. I was wondering if it had to do with the fact that I wasn't…
jsmith
  • 565
  • 3
  • 14
  • 28
0
votes
2 answers

SQL Server 2000: Updating one table with values from another table

I have a form that displays a list of systems along with their current status. The user can change the status and the date of that status change is stored in a history table. The user can also change the name of the server as a status changes (for…
HPWD
  • 2,232
  • 4
  • 31
  • 61
0
votes
1 answer

Date read from SQL database seems to be different on another machine

I have meet a very weird situation. I use Eclipse to connect to a remote SQL Server 2008 database, and I get the correct date. But when my colleague copies the code and runs it, all the dates are 2 days earlier than they should be. For example, I…
user1224913
  • 13
  • 3
0
votes
3 answers

MS SQL Datawarehouse performance improvements for non-unique key table

We recently updated our DataWarehouse (a MS SQL 2000 database) to include a new table to control the level of access users had to information in all of the other tables. Without going into too much detail, the new table has a user ID, and a list of…
David
  • 77
  • 5
0
votes
1 answer

cakephp SQL Server error

I have the following database connection configuration: var $default = array( 'driver' => 'sqlsrv.DboSqlsrv', 'persistent' => false, 'host' => 'localhost', 'login' => 'sa', 'password' => '', 'database' => 'prospect', …
Sindhu13
  • 97
  • 1
  • 1
  • 8
0
votes
1 answer

Synchronization between Two SQL Server Databases, Online and Offline

We have a local intranet based Project Management tool, we built it in asp.net .net 4.0 and sql server 2008. We cannot access this system online as it is lan based, neither we want its files to be appear online. But most of the cases we and other…
Muhammad Atif Agha
  • 1,535
  • 3
  • 33
  • 74
0
votes
1 answer

how can i get rows with similar column value

how can i get rows with similar column value
saurabh
  • 271
  • 1
  • 6
  • 18
0
votes
1 answer

Connecting PHP5/Apache2.2 with SSPI Auth on MSSQL Server 2000?

Well, basically thats the scenario: I need to reach a MS SQL Server 2000 database where I was granted access using the NT(LPAD) authentication to my user. But, my plattaform is a PHP5/Apache2.2 on Windows XP and I got no way to make my…
Paulo Bueno
  • 2,499
  • 6
  • 42
  • 68
0
votes
3 answers

Retrieve the latest value from an Auto-Incremented id-field?

I am from this link Suppose I have a Table: FieldWorker{ ID, Name, WorkingArea} And, ID is an auto-incremented field. Now, suppose, I am using the following code to insert records: sqlComm.ExecuteNonQuery("INSERT INTO [FieldWorker] ([Name] …
user366312
  • 16,949
  • 65
  • 235
  • 452
0
votes
2 answers

Generate datetime range SQL Server 2000

I am trying to generate dates for the whole year of 2012 in datetime format to store in a SQL Server table in a datetime column. How is that done? So start date would be 1/1/2012 until 31/12/2012 but in the correct format. I am assuming I should…
sys_debug
  • 3,883
  • 17
  • 67
  • 98
0
votes
7 answers

How to find all fridays and holidays between two dates

The table: hDate Holiday 17/12/2011 National Day 01/01/2012 New Year .... From the table, i want to find the total number of holidays between two dates: A query like: select count(hdate) from table1 where hdate between '" & start_date & "'…
JetJack
  • 978
  • 8
  • 26
  • 51
1 2 3
…
99 100