hi, i had a small doubt , i have a table xxx with two columns (a int,b int ) and i have inserted 5 rows my query is to add the two colums using a stored procedure and the result has to be displayed in an separate column --this has to be done only stored procedures ---i know how to solve the pro...more >>

> This is a common problem with some solution > > /*********************************************************************************** * * Problem: * Determine the Duplicated Records in a table using single SELECT. * * We shall be using Northwind database, add some duplicate recor...more >>

How would i add order by to the syntax below: "Select * Into ETCLog_holding from etclog where box# BETWEEN " & Box1 & " and " & Box2 i have tried adding it after Box2 but it doesnt work. Any ideas? ...more >>

Hi, I need to lock a database (prevent users from connecting) in order to update it. I already know how to kick everyone out with their spid but i can't figure how to prevent them from reconnecting. Thanks ! ...more >>

Hi, I'd like to reverse engineer the schema definitions in the SQL Server on a daily basis and store them in a version control system. Could anyone please let know if there are any tools to reverse engineer the entire schema definitions in the SQL server. I'd like something like the perl sc...more >>

I have a problem... Data transformation rounds or truncate decimals! I have an ODBC source in witch is a table with float numbers (ODBC Driver publish it as float). If I build a query form access or from excel with Query Analizer, I see all decimal places, but when I try to insert data using ...more >>

Hello everybody. Unfortunately I am pretty new to sql-server 2000 I need some help with a Trigger I created. I created a trigger witch takes the id of the affected row and does a update on a other table with that ID. The trigger works fine with one affected row. But when there are more then ...more >>

Having a brain cramp here and don't know where to start. I have 2 tables: vehicles and vehicle_useage. What I would like to do is this: For each distinct vehicle in the vehicle table, I want to make entries for each day of the month taken from a given date. This routine will be scheduled...more >>

We have two applications (1 on two servers and 1 on another). Every so often, we 'lose' the connection to the SQL database which in effect takes these applications down. One app is a service (written in Delphi) , the other is a web page (ASP). >From what I can tell, both different methods use ...more >>

Hi, I have a DB where I would like to maintain a fixed size and control it by myslef. I do not have the options: "Auto-Grow" and "Auto-Shrink" enabled. >From time to time, without a notice, or any logging, the database files gets shrinker and this causes a database full error. As I wrote, ...more >>

I apologise if this is a stupid question, but I would appreciated any help on this subject. I want to create a view (VIEW_1 in example below) where I take numeric values from a field in one table (DEPTH_FROM in TABLE_1) and find the closest matching values from another field in another table (...more >>

I have an accounting database which contains data from various years. The frontend is a VB.Net program. At the year end, the program creates new voucher and transaction tables and creates new stored procedures for them. I just append the 'new year' at the end and create them ie, Vouchers200...more >>

Hello all, I need help with sql server which i was wondering if someone can shed some light on my problem The problem: Hello all, I need help with sql server which i was wondering if someone can shed some light on my problem The problem: i am using .net 2.0 membership provider interface ...more >>

Hi. I have a multiplier that multiplies 2 floating point numbers with 7 bits exponent and 10 bits mantissa.so its output has 7 bits exponent and 20 bits mantissa. now its output must return to its input in order to compute another multiplication.on the other hand its output must be truncated to...more >>

I'm looking into a problem a friend is having, and I'll say right off the bat that I work with with php and MySQL, and not MS SQL. What he is attempting to do (in MS SQL) is take two database fields from a table (string fields), multiply them together, and put them into a third field. This th...more >>

Hello All I get stuck in one problem , Please help me and excuse me on the poor Knowledge in SQL Server Store procedure Q1...I want to return a string type value from store procedure , Is it possible to do it.if posible then Please guide us how we can do it . Q2...I search a lot on net...more >>

I am going mad with this Query. I need to join 3 Tables. Their Formats are Vouchers [VoucherID] [uniqueidentifier] NOT NULL , [VoucherTypeID] [int] NOT NULL , [VoucherNo] [int] NULL , [VoucherDate] [datetime] NOT NULL , [VoucherNarration] [varchar] (255) CONSTRAINT [PK_Vo...more >>

I've never really setup or used MS SQL Server (just a couple hours, one day, several months ago). I think MS SQL Server has the ability to use "linked tables", like MS Access does. Is this correct? What I want to do is have an MS SQL Server setup, which compatible applications can talk with, ...more >>

env: sql server 2000 objective: add a formula for an INT column to the FORMULA field or the DEFAULT VALUE field in DESIGN VIEW. all of the following attempts failed IIF (columnName = 0, "1", columnName + 1) IIF (columnName = 0, 1, columnName + 1) IIF (0, "1", columnName + 1) caveat: ...more >>

I've been trying to copy tables from a linked server to a SQL Server Express database. Express seems to have no direct/automatic way to do it, so I've been looking into doing this by hand (i.e., with a T-SQL procedure). I've discovered some system stored procedures that seem relevant (like sp...more >>

kind of a tough one i think but any help is appreciated. please try to stay away from T-SQL... I have a table with products and closing dates for each of 4 quarters and annual for several years back. (Earning_Dates) I have another table that has those products with dates and closing prices. (un...more >>

Hi, Is there a way to catch every select comming to sql and change it to select with nolock? or how to make database READ UNCOMMITTED permanent? any ideas? Richard ...more >>

I am new to sql and require some help on cursors? what are they and how and why are they used for??? it will be kind enough if anyone helps me in this regards.. regards vishal jain. ...more >>

kind of a tough one i think but any help is appreciated. please try to stay away from T-SQL... I have a table with products and closing dates for each of 4 quarters and annual for several years back. (Earning_Dates) I have another table that has those products with dates and closing prices. (un...more >>

I would like to attend a conference/seminar/educational presentation on SQL Server. I don't know what types of qualifications to use in evaluating these types of events, nor do I really even know how to discover where they are held. I'm not sure what my companies budget is, but I am relatively...more >>

Hi SQL fans, I realized that I often encounter the same situation in a relation database context, where I really don't know what to do. Here is an example, where I have 2 tables as follow: ________________________ __________________ | PortfolioTitle | | Portfol...more >>

http://www.testyourabilities.com/it/ IT tests. SQL, XML, ASP.NET, C, C++, C#, VB.NET, HTML... ...more >>

I have been spoiled by some report writing tools that have intrinsic functions like Last Year Month-to-date. I'm looking for a way to emulate this in SQL Server now with my fields that are date/time. I'm thinking I need to develop a user defined function to accept a date input parameter, but ...more >>

First of all apologies for posting this again but I posted it in the wrong place the first time. Can anybody help me with the post below? http://groups.google.com/group/SQL-Server/browse_frm/thread/f84e353c41d788f1/35ec9f04d978d0de#35ec9f04d978d0de Thanks, Paul ...more >>

Hello, I've follow problem - thing to consider. SQLServer 200 sp3a, ms win 2003 server db simple recovery There is a production database, wich is around 20gb big. Db is backed up each day completely, but it takes up to 30 minutes. Because there is a simple recovery model, there is no t...more >>

Hello everybody, First: SQL Server 2000 sp3a, HP cluster server, MS 2003 server, database recovery model simple Torn page detection: When I have this option turned on, processes conected with updating and writing in database, was MUCH more slower, than if I've this option turned off. It...more >>

Hi When trying to create an SqlServer job, clicking OK' I got the message "Error 823: I/O error (torn page) detected during read at offset..... in file 'd:\sqlserver\MSSQL\data\msdata.mdf'. The job was not saved" I asked about the problem a little to find out that I need to restore a backup...more >>

Hi, I have a very simple question. In what cases are relational databases necessary? Are they really necessary in cases where only a single type of query is to be performed based on one unique field or can we just put all fields together in a single database and just access them through that u...more >>

I have a form that I turned off the nav buttons. I then create my own. The reason I do is that I cna then move the nav buttons any where I need to on the form. The only thing I can not figure out is on the default ones, it shows the total records. I can not figure out how to do this. The form ...more >>

Is there some kind of way to limit the resources (CPU, number of sessions) per user in MS SQL 2000 database. Some kind of resorce manager thing... ...more >>

I am redesigning an application that distributes heldesk tickets to our 50 engineers automatically. When the engineer logs into their window a stored procedure executes that searches through all open tickets and assigns a predetermined amount of the open tickets to that engineer.The problem I am...more >>

1. In c++ (or any other language) I'm copying bit by bit to a double variable dob_var. 2. If I copy dob_var to dob_var2 which is also a double I do not lose information. 3. This implies that the same would be when copying to a data base, but when I write dob_var to an sql server float field (sa...more >>

Hi Group! I am having a problem of using SUM under UPDATE statement. I understand that SQL does not allow me to use SUM in UPDATE, but unfortunately, I can not find a way to get around it. Can someone please give me some idea? Thanks a million! --Here is the criteria: Under the same PORTFO...more >>

Dear MS SQL Experts, I have to get the number of datasets within several tables in my MSSQL 2000 SP4 database. Beyond these tables is one table with about 13 million entries. If I perform a "select count(*) from table" it takes about 1-2 min to perform that task. Since I know other databa...more >>

I have a table with data that is refreshed regularly but I still need to store the old data. I have created a seperate table with a foreign key to the table and the date on which it was replaced. I'm looking for an efficient way to select only the active data. Currently I use: SELECT ...more >>

Hello all, I know that this is a long shot, but I have a problem which someone reading this group *may* just be able to shed some light on. We have a new internal personnel planner/attendance system in place. It uses a web interface to allow members of staff to select their site location fo...more >>