I have created a virtual cube in SQL2000. Then, I have generated a Calculated Member. When I did rollup into a higher level, SQL2000 did re-calculate the member. However, I want to summerize the Calculated member. The Solve Order could not be worked in this situation since a measure, which is us...more >>

hi all this is my first post to this group, so pls bear with me while i try to make some sense. i am trying to create a sproc which uses dynamic sql to target a particuar table eg. '[dbo].[' + @tableID + '_articles']' and perform some actions. i am using @tableID [int] as a passes parame...more >>

Hi Everyone, I've got a question and I think the answer can be a single SQL statement. In fact, I think I might've done this before, but I can't find the SQL. I've got a table with names and different bugs and status ids. I'd like to get a query that totals the various statuses. For instance...more >>

I need to run a query which will pull data from two tables and append it as one when it displays the result. The data are in two tables. But the result set will be identical in terms of number of columns. I want to display it one set below the other. This is for pay history. From 2003 we have ...more >>

Hi. I am quite new into stored procedures written in t-sql. (MSSQL server) I have three different tables in my DB. Two of the tables (with different data) are updated regularly and need to be joined into a third table that works as the basis for an application in ASP. The two former table...more >>

Hello: I'm new in the SQL server world. But I need to copy one SQL database on machineA to machineB. By looking at the tool bar, I think export will do the job for me, is anybody can provide the detail info? DO I need to create an empty database on MachineB first, any documentation repository I...more >>

Dear All, I would like to know whether I can create a distributed database by using SQL 2000 Server? If possible, any reference? Thanks alot!! ...more >>

If I copy a Database backup to a CD; can I resotre to a different server? Thank you ...more >>

I cannot seem to find a group where this question would fit so I am posting it here. I have what I believe is a unique situation. I am using SQL Server Analysis Server to build a cube of "snapshot" month-end type of data. This data is from an instance of Microsoft Navision and I have successf...more >>

If connection properties and global variables are set from an INI file, how can a DTS package be made truly portable? If the INI file pathname is hard-coded in the package, it must be edited when you copy the package to a new environment; otherwise your packages in multiple environments will a...more >>

Hello, Can anyone recommend good SQL Server 2000 book/material that is comprehensive yet an easy read that also serves a good background to the 70-228 and/or 70-229 exams. I'm not a DBA (more of systems/network admin), so I want to concentrate on 70-228 first. I also want to KNOW SQL Server, ...more >>

HI all, This has puzzled me all morning. I have a int field which reads 19691124 (UK dates) this is actually a date 24 November 1969 I need to add 28 years to this making it 19971124 but I’m stumped! Any ideas anyone? Cheers Sean *** Sent via Developersdex http://www.developersdex....more >>

Is it a good thing to do? what are the cons? Are there any risks? (this is an ISP database running 24 hrs) I have sql 6.5 on Win NT with 256 MB Ram (64 MB reserved for SQL Server). tempdb size is 10 MB. Currently i'm experiencing slow response for large queries and sometimes users have problems ...more >>

We're building a company wide network monitoring system in Java, and need some advice on the database design and tuning. The application will need to concurrently INSERT, DELETE, and SELECT from our EVENT table as efficiently as possible. We plan to implement an INSERT thread, a DELETE t...more >>

How can I insert values into a table based on the fetch I do. The examples I have been able to find all shows how to use "print" to show how Cursors work. I want to read through a table, and only insert values into another table if some conditions on the row is true. Can this be done, if s...more >>

Hello, I have this peculiar problem concerning MS SQL Server. My company works with an mailing application (ASP) which uses SQL Server as it's repository. What I want to do is send data directly from my own application to this SQL Server in order to feed the mailing application. To test ...more >>

Hello I have a case where Partners are some kind of Super-Users and are stored in a SQL Server database. Best is IMO to put both in the same table: table Customers: CustomerID[pr.key] [blabla] PartnerID But of course I have to reference the partnerid from another table and I want SQL ...more >>

What methods are people using out there to keep their stored procedures under CM control? We are using CVS for our CM system. Looking for an easy way to get stored procedures scripted out as text so we can check in/check out of a CM system. Thanks! -- Mike Brown...more >>

Hi; I need some help in writing a query and the following is what I am trying to do. SELECT VALUE_ID FROM CC000.VVALIDITYVALUE WHERE (CATEGORY_ID = 2) The above Query will give will every Value_ID where the Category_ID =2. Then SELECT VALUE_ID FROM CC000.VSCREENVALUE WHERE (SCREEN_ID...more >>

When I run: select * from testtable I get this error message: Invalid object name 'testtable'. However, if I run: select * from testuser.testtable It works. I'm logged in as testuser, and testuser is the database object owner and tableowner. This was a restored database from a diff...more >>

Suddenly in one database we have a lot of errors, it seams some things are corrupted. I tried to start maintanance / database repair, but this fails too. When selecting in Query Analyzer a range of records from a table I get the following message: Location: p:\sql\ntdbms\storeng\drs\includ...more >>

Hi, I had this problem in version 7 and dont remneber How I solved it!! I have installed a local SQL Server (2000 aka version 8) on my Worksation (W2K), I have picked NT authuntication. Everything was fine untill I changed my password. Now SQL server can not start because it fails to login. ...more >>

Hi All, We have started to get the strangest errors with our SQL Server. We use Windows and SQL Server authentication, and have done successfully for the last year or so. However last week i had trouble connecting to the enterprise manager with my domain credentials. Users connecting to Query ...more >>

A format file provides a way to bulk copy data selectively from a data file to an instance of SQL Server. This allows the transfer of data to a table when there is a mismatch between fields in the data file and columns in the table. I take it this assumes the number of fields in the data file wi...more >>

Hi, I have a pretty simple problem for a SQL programmer regarding GROUPINGS: I have two tables tblShoppingCarts and tblProducts. The first table stores all shopping cart data. I would like to retrieve all this data (cart and all related product information) BUT need to GROUP BY tblShoppingC...more >>

I am trying to transfer with dts a table of As400 into a db sql-server. But i receave un error (2147217865) With Access i can import the table with the same ODBC. You have some suggestion ??? thk by Logan bye bye ...more >>

I am a SQL newbie! What is the correct datatype to use, if I want to record a checkbox from a web form? Thanks, Darren ...more >>

In the hereunder written message I talk about point in time restore. It is now based upon the fact that there are no hardware problems or what so ever. I just would like to roll back to a situation of some time (minutes, hours or what ever) ago. Used to the ingres database a point in time res...more >>

I am trying to implement a very fast queue using SQL Server. The queue table will contain tens of millions of records. The problem I have is the more records completed, the the slower it gets. I don't want to remove data from the queue because I use the same table to store results. The que...more >>

I have a problem within a procedure I am working on. I would like to process every column in a table in a cursor. Now to my problem, I can't save a column of type text into a cursor variable. It's not allowed to use datafields of type text in this context. I also think that I runned in to a simu...more >>

Hello Im am a sql newbie who has a question concerning triggers. Ive made this trigger: create trigger check_if_already_exists on users for insert ,update as begin begin transaction Declare @Username varchar(20) Declare @Username_exists varchar(20) select @User...more >>

I am trying to run a free-text search across a database of 59000 records, with maybe 2k of text per record. This data is stored in an ntext field. However, the search I am doing is extremely slow, taking about 30s to return, say 100 records on our intranet. I have created a "full-text" ind...more >>

How to generate a seq number in TSQL. My need is for every record insert ,I need to insert a seq number paded with letter 'I'. Please help me. Adv Thanks mate -- Posted via http://dbforums.com...more >>

Hi, I have a text file that contains a date column. The text file will be imported to database in SQL 2000 server. After to be imported, I want to convert the date column to date type. For ex. the text file look like Name date Smith 20003112 Jennifer 19991506 It would be conv...more >>

I have a table as follows: - user_id (key) - user_email_address (text) - user_request_date (text) - user_sent_date (time/date) An automated macro will run every 5 minutes and needs to run a SQL UPDATE that: - finds the FIRST (ONE ROW ONLY) (yo...more >>

Got a tough one here for you SQL junkies. I'm working on a website (in ASP) for a national greek/college organization. All it's college chapters have greek chapter names, i.e. Alpha Chapter, Delta Chapter, Delta Iota Chapter, Gamma Phi Chapter, ect. ect. I need the SQL to return the chap...more >>

Yesterday I received a response to my CI/CS Collation problem and the recommendation was to try and restore a CI Collation database to a CS Collation database. After creating a blank CS database a full restore (Force restore over existing database) does change the Collation to CI. I'm unsure a...more >>