I am not sure of the best way to do this. I have a table that is a log for visitors. I want to return a record set where each row is a count of the hits for the day. Just one column is fine as long as the the order is correct by date or two columns date and hits would work. I would perfer this t...more >>

I need to convert an application (originally written for English users) to support both English and French. I want to minimize making changes to SQLs and table structures in the back end. What can I do? Thanks in advance. Adam ...more >>

In my application, we have a lot of metadata tables stored in the database. Our server first caches all this information at startup (and never queries for them again). The major problem with our server startup time is the SQL server round trip time. The first startup after a reboot is alwa...more >>

I am having problems with a union all sproc. In the sproc, I have to determine the value of a param and I am getting the value using an exec statement. When I run the sproc, it returns the value of the exec and the first of the union query. If I comment the exec statement and pass the value the ...more >>

I have a test project that I am trying to code to be as fast as possible. The project is a lottery speculation project that uses .Net web services to return an XML recordset. The goal is to accept any number of 5 possible balls, and return a recordset of all past draws and possible draws tha...more >>

Hi We have a SQL Server 2000 database with a run-of-the-mill customers table containing nvarchar columns for customer name and customer address. There's a clustered index on name and a non-clustered index on address. Users can search the customers from a web form using both name and add...more >>

Is it possible for SQL to automatically switch access to a database to be Single User only....more >>

I was doing exports to text files until I discovered that my text fields were being trimmed to 255 characters. (I was just about to re-import a text file too, as I had messed up a table. If I hadn't noticed that the fields were trimmed I would have been screwed! It doesn't tell you that it is tr...more >>

hi, i have just transfered my database to the production server, and i find now that i need to reference all the tables with dbName.tablename in the stored procedures, before i just had tablename to refer to the tables and it worked fine. my problem is i have a hundred sprocs and i'm doing r...more >>

We are experiencing a problem with Sql Server 2000 linking to an Access 97 file. We have two machines that link to this .mdb file, and we recently upgraded one to newer hardware, SP3a, MDAC 2.8, etc. The link on this upgraded machine no longer works, giving this message: Server: Msg 7399, L...more >>

I'm trying to figure out how do a particular query. It seems simple enough, but I can't figure out how to pull it off. Here's the set up. I have a table of clients (tblClients), a table of US states (tblStates) and 'linking' table (tblClientStates) to id which states a particular client opera...more >>

The patch installation for KB824146 venerability went eventless and SQL server 2000 and the Windows 2000 Adv Server Box are up and running, BUT All my linked servers pointing to ORACLE servers are returning error. >> Error 7399: OLE DB provider 'MSDAORA' reported an error. OLE DB error trac...more >>

Hello, I'm trying to figure out some SQL here and am wondering this: Is it possible to select data based on a sub-string of a text field? Say I have these values in a field called "ROOMS": |1|2|5|45|36|27| And say the ROOMS field in any record will always be pipe-enclosed numeric values. ...more >>

I am coding a large VB project, using Win2k, SQL Server 2000 SP1, COM+, and VB6SP5. We have been having some problems with transactions not being rolled back when an error was raised, and we have traced it to the following situation. I'm looking for strategies of error handling for this situat...more >>

Hi, I would like to know how to disable the identity column for an insertion and enable an identity column after the insertion. Is there a query that i can send, like USE_IDENTITY = NO or anything similar. Do i have to ALTER TABLE... Thanks a lot. ...more >>

I have a list of product id's that have a common name. In the database each product id is a seperate record. I want to roll these up into a display grid where each row represents a product name with a column consisting of a comma-delimited list of id's. I tried doing this with a function that ...more >>

Hi there, I'm working on SQL parser at the moment and want to create a set of tests for select statement. I'm too lazy to type all possible variants of select statement. Does anybody have or can point to the list of possible select statements (I mean a reasonable subset) examples? Thank...more >>

Anyone know how to count rows in a table depending on 2 columns, and different values within the second column. Basically i am trying to obtain the resultset example below from the table example below TABLE example: Date | Status ------------------------- 2003/07/01 ...more >>

thought my question was misinterpreted. actual table can be smaller or larger. but, within a procedure need to turn a created #temptable similar to(examid is in asc order): (id, p/f, examid, examname) 1 f xxxx xxxxx 1 f xxxx xxxxx 1 f xxxx xxxxx 2 p 3 ...more >>

#temptable (studentID,p/f,examid,examname): 1 p 2 f 100 bio 2 f 101 mTH 2 f 102 CHM 2 f 103 spts 2 f 104 LIT 2 f 107 geo 2 f 109 phys 2 f 110 eng 2 f 111 hist 3 p 4 f 100 bio 4 f 102 chm 4 f 109 phys 4 f ...more >>

dear all, i'm developing an application for hotel industry. the question is can sql2000 handle 2000 concurrent connection & what kind of best hardware requirement to perform the jobs. assistance are appreciated. tankQ. ...more >>

is it possible to do: (A) declare @numberofitems Int @numberofitems = select max(itemorder) from store, department, etc. and pass the @numberofitems to a #tempStore table, like: (B) (store, department, @numberofitems,...) I got itemorder but not the number of items in each department A...more >>

hi folks, i want to run several SELECT statements (from several tables), and I want all of the result sets to be returned in one XML document. It could be as simple as SELECT * FROM table1 SELECT * FROM table2 SELECT * FROM table3 but the thing is I need it all returned in one xml f...more >>

We just began looking into upsizing an Access 2000 database and applications to SQL 2000 at work and a question arose about whether we would be gaining any benefit if we upsize only the backend and just linked the tables to the current application front-end. Specifically: Wouldn't doing thing...more >>