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 >>