I have a stored procedure what produces N number of rows. The rows are ordered by a cataegoryType as follows catA catB catC What is needed to do on the C++ code side is break these out into their respective categories by iterating through the rows and checking the category ...more >>

Dear Group I wonder whether you can push me in a direction on how to design the following statement. I'm looking for a SELECT with some tricky ORDER BY. The database table looks like this: MenuID TabText SubTabID TabOrderID ------- ----------- ----------- ----------- 1 ...more >>

Hello, Can someone point me to getting the total number of inserts and updates on a table over a period of time? I just want to measure the insert and update activity on the tables. Thanks. - Vish...more >>

Hi I've got many tables that has columns definition TrimTrailingBlanks = NO to all char and varchar columns. How can I set TrimTrailingBlanks to Yes without re-creating the tables. Thanks...more >>

I'd like to create a DTS package to update records within a table leaving other information stored in those records as is. For example, table a has a record with 5 columns where 3 are null. An external source has the non-null values for those 3 columns. Can anyone help with some general steps...more >>

I had a friend write a stored procedure to perform a function for one of my clients. What he wrote doesn't fully do what I need, and I hope to finish it myself. I have programming sense, but not so much with SQL. I'm trying to figure out the code, and he has used something called a "cursor." ...more >>

Can someone demonstrate a SIMPLE way to do this that does not require additional functions or stored procedures to be created? Lets say I want to execute the following simple query - "select * from clients" - and save the results to a text file, we will assume c:\results.txt How can I do this ...more >>

I have the tables tblEmployees and tblProjects. tblProjects has one column called Percentagetime, to hold the percentage of time by an employee for a project. My Question : Why should we introduce a 3rd table called tblProjectsAndEmployees? tblProjectsAndEmployees will have 1)EmployeeNum...more >>

I am using Maximizer Enterprise 8.0 as my companies CRM solution. Currently we are using the included Pervasive SQL that shipps with the product. Is there someone out that who could tell me if there are any performance benefits to switching the Pervasive Engine with a Microsoft SQL engine. ...more >>

I currently have 4 scheduled jobs which are all scheduled for 4 different days and was wondering if there was anyway these could be be stopped automatically in the event of a job failure, consider the example below Monday Job runs to produce a file requesting BACS Payments. Wednesday Job ...more >>

Hi, I tried to create a simple view as follows CREATE VIEW V_ALL_USERTABLE_COLUMNS AS ( SELECT OBJ.NAME as TableName, COL.NAME as ColName, TYP.NAME AS TYPE FROM SYSOBJECTS OBJ, SYSCOLUMNS COL, SYSTYPES TYP WHERE OBJ.TYPE = 'U' AND OBJ.ID = COL.ID AND COL...more >>

I have the following query that has been working so far. I modified it slightly to work from another source table (new_products). Now, SQL Server complains that the identity is inherited already: "Cannot add identity column, using the SELECT INTO statement, to table 'dbo.my_products', which ...more >>

Hello, I wonder if anyone can help, I am trying to track down information on a product called Kaleido. Apparently it is a database/data warehouse reporting system written by Shell, which then spun-off the company and sold it into a lot of other companies. They don't seem to have a websit...more >>

Hi. I have a table (websitehits) which holds statistics about websites. This table has a date field (datecounted). What I need is to create a query which returns a list of dates between two date ranges (say a year ago from today and a year from now) which only shows dates that haven't been us...more >>

Nel database "master" ho mappato, per errore, l'utente "guest" su un utente sql "XXX" creato in SQLServer. Questo tipo di impostazione non permette più di aver accesso con l'utente anonimo "guest" (mappato su null) al db (con autorizzazioni limitate al ruolo public). Ho provato sia da EM che ...more >>

Hi, When I copy tables in a database from one server to another using enterprise manager, everything copies ok, except for field defaults. Has anyone seen this, and what is the solution? -- http://www.dbForumz.com/ This article was posted by author's request Articles individually checked...more >>

Hi , This is related to datawarehouse , data mining . We are told that data mining tools such as spss or sas , need a large table which has lots of columns inside . Based on our project , out final table which will be used in data mining , has lots of computed values . The final number of col...more >>

Is there a way to use a column alias in an another calculation within the same query? Since I am using some long and complex logic to compute total1 and total2, I don't want to repeat the same logic to compute the ratio of those two columns. I know that I can do a nested query, but that seems too...more >>

Hello all, I'm new in this newsgroup and I apologise if my question has already done. Let me knwo if FAQ is avaible somewhere. I use msSQL server to manage data for a B2B portal. Orginal data comes from as400 db2. I need to update msSQL data from db2 source. I used MetaDataService exec...more >>

Hello All I'm a bit confused about collation settings so needed some info. on it. My database server is currently using SortOrder as Latin1-General, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 52 on Code Page 1252 for non...more >>

I have a table with only one row to get unique ID-numbers. To get the next ID-number I have to increase the number in the row: first, get the number from the database, and then do the update. Some ASP-code: Set rs = db.execute("SELECT id FROM tbl_id") id = rs("id") db.execute("UPDATE...more >>

Hi, I have 2 queries that I need to join. I have the following tables: attendancelog : headerid reportmonth attlogstuds: headerid sid class: sid class status yearcode logdate cdate mid The result must return all the classes that appear in query2 but not in query1. I am no...more >>

I have setup an email notifications system, that basically takes each row from a table and sents out an email according to the data in that row. The emails get sent, with the subject being filled as expected. Only problem is that sometimes there is no message. Here is the stored procedure that...more >>

I am developing a SQL database to cover operations that were previously handled in a spreadsheet, and need to create a view or procedure that presents data into a matrix format similar to what the users are currently working with. There must be a way I can create this using Transact SQL but I c...more >>

Hi, I got a new SQL Server database and are in the process of porting my Access databases to my new SQL Server. I have worked with Access and Oracle in the past but I am new to the SQL Server environment. I have a tool called ConVersion that is helping me rewrite my queries in Access into SQL...more >>

I'm trying to make a site work for japanese characters. It works fine except for the alerts in javascript. The characters are stored in unicode, as this; 'コミック全巻配' Those unicode characters are translated by the browser, but not in the alert. ...more >>

I'm just starting to use triggers in my databases and find the support in Enterpise Manager lacking. Using Enterprise Manager and Query Analyzer you can maintain the triggers, but it's cumbersome. Are there better tools for creating and managing triggers? Mark Flippin ...more >>

i'm new to sql server.. i have searched google / help, but can't find what i need.. basically i just need a "how to" on creating an sql view in an sql database using an access.mdb how do bring an access.mdb table into an sql view so i can create links w/ other sql tables ...more >>

Hi, Could some please tell me whether Microsoft provides Type 2 and Type 4 jdbc driver ? For Type 4 MS provides com.microsoft.jdbc.sqlserver.SQLServerDriver driver. What is the cofiguration required for type 2 driver and what driver class files required ? Its very urgent to me please reply....more >>

While I debugging a SP, I try to catch the value of local variable ( DECLARE @ls_where VARIANT(8000) ) but I see that is not completely, but truncate. The SP works correctly ... how can I catch the completely value of the local variable ? I have The same result if I Print the variable. Thx ...more >>

Hi... A much lamented question, I guess.. I'm trying to create a simple audit trail. log the changes to an SQL 2000 table, so that they are written into a mirror table. The entire record, only the updated one, i.e. if say only one field changes, the audit table will be inserted with one rec...more >>

I've been asked to turn our single-user database system into a multi-user system. At present, each user has a copy of the MSDE on their desktop machine and uses our program to access it. In future, we would like to centralise our MSDE instance and allow multiple users to access it. In ord...more >>

hi, I have a question. Maybe You know the equivalent to command LIMIT from MySQL I couldn`t find something like this in MS SQL PS I try to display 10 records begining form e.g. 4 sort by id something like: "SELECT * FROM table WHERE name=... LIMIT 4, 10 ORDER BY id" in MySQL thanx, Urb...more >>

Anyone, I have a user "john" whose machine is part of the "job" domain. He is trying to establish an odbc connection to an MS SQL 2000 server on the "school" domain. He uses Windows authentication to establish the odbc connection however it gives the error "Login failed for user '(null)'. ...more >>

Hello! 1. How can I know exactlly what row is locked? Is data in "resource" column of sp_lock usable? For example, resource = 03000d8f0ecc 51 14 0 0 DB S GRANT 51 14 277576027 1 KEY (03000d8f0ecc) X GRANT 51 14 277576027 1 PAG 1:1112 IX GRANT 51 14 277576027 0 TAB IX G...more >>

Hi, I have a sql query with cases. I need to add a condition that if hasamafactor=5 then display only cases m11-m14 else display the rest. Of course sum ( kamut) as total4mosad has to be only for the relevant cases and not all of them. CREATE PROCEDURE [dbo].[MisgeretMosad_Sum] (@...more >>

Im trying to access a sql200 database from a sql7 hosted stored procedure and this is not working. I know that SQL7 is not compatible with the MDAC for SQL 2000. Does anyone know if this is what is causing me my problems and if so is it possible to upgrade the SQL7 MDAC without breaking it? T...more >>

The UPDATE table FROM syntax is not supported by Oracle. I am looking for a syntax that is understood by both Oracle and SqlServer. Example: Table1: id name city city_id 1 john newyork null 2 peter london null 3 hans newyo...more >>

Im doing a select that should retrieve a name from one table and display the number of correct bets done in the betDB (using the gameDB that has info on how a game ended) I want the "MyVAR" value to be used in the inner select statement without too much hassle. As you can see im trying to get ...more >>

Hi, I have my create statments for tables, procedures, views, etc in individual Transact-SQL script files (.sql). I wnat to write another script file that executes these scripts in the correct order to create the database. What is the syntax for executing script files from Transact-SQL? ...more >>

i'm in a bit of a bind at work. if anyone could help, i'd greatly appreciate it. i have a web app connecting to a sql server using sql server authentication. let's say, for example, my login/password is dbUser/dbUser. the web app however, is using windows authentication. so if I am logged...more >>

Hello, I am designing a table of vehicle types, nothing special, just a list of unique vehicle types such as truck, lorry, bike, motor bike, plane, tractor etc etc For the table design I am proposing a single column table with a field name called vehicle_type and this will contain the vehic...more >>

Hi all. I need to set a oneway replication of some data from MSSQL (running under Windows 2000 server) to MYSQL (running under Linux). Do you have some ideas to solve the problem? Thank you Luca ...more >>

What's the difference between the rowcount column returned by: DBCC SHOW_STATISTICS('table_name','primarykey') and SELECT rows FROM sysindexes WHERE id = OBJECT_ID('table_name') AND indid < 2 Is the second query always accurate, whereas the 1st may not be if the table stats are bad? ...more >>

I have a table like this order_id price 1 -1000 2 2000 3 3000 4 4000 I want to know the total of the order amount, I use this query SELECT SUM(price) FROM MyTable and I get 8000 instead of 9000. The negative value seems to be read twice! ...more >>

Hi all, I have a challenge (not a problem). Simplifing it as far as i could, i have this situation: Table Persons Id (PK) Name Table Scores FK_Person (PK) Period (PK) Value Now, i want to make a stored procedure that returns the scores for all people in a certain...more >>

Hi I am hoping someone might be able to help me out with this. I am writing a helpdesk system which records agents logging in and out of the system. I need to write a stored procedure which will show the peak number of agents logged in concurrently during a specified time period. Within ...more >>

Hi, I am seeking the help of volunteers to test some software that I've developed which facilitates distributed two-phase commit transactions, encompassing any resource manager (e.g. SQL/Server or Oracle) controlled by Microsoft's Distributed Transaction Coordinator in a Windows2000 environme...more >>

Hi You can do a select top 1 * from <table>, my question is how does one delete the row whithout having to do lots of where clause ? Is there a equivelant delete top 1 from <table> Thanks ...more >>

How to make view based on two different databases.How do i access table in other database.. Thanx...more >>