I have a web form (ASP) that imputs into a sql database. I need to return a value based on the values a user enters. The user would choose a "size" and then choose a "packaging" I have a table that has three columns "size" "packaging" and "cost" I need to have the cost value returned base...more >>

This is a request for help with a SELECT within SELECT. The following returns open occurances (no END_DATE) and selects the associated appointment with the highest APPT_ID. I want to imbed another SELECT that will 1) read back to the Appointment table (joining back on the APPT_ID) and return t...more >>

Hi, Iam looking a good solution for wrapping around records in the table. The requirement is to keep only last n (eg. 20000) number of records in the table. After inserting the n+1 record the first record need to be removed from the table. so on... Is it better to place the logic in th...more >>

Based on the value of a variable I want to be able to create columns dynamically. i.e. if @n=5, I want to generate T-SQL statements that creates 5 columns. Could I generate the T-SQL statements, store it in a variable and pass the value of the variable for achieving this? Many thanks Sh...more >>

Hi, Win XP Pro, VB6, SQL2K. I am trying to code the SQLDMO Backup2 object to provide notification when the backup media is full but I can't get the NextMedia event to fire. I am using a floppy as the backup target in order to get the desired insufficient space. I have event handlers for ...more >>

The reason some people don't know for sure if they are going to Heaven when they die is because they just don't know. The good news is that you can know for sure that you are going to Heaven which is described in the Holy Bible as a beautiful place with no death, sorrow, sickness or pai...more >>

Dear all, I've got this table with this fields: id, yn, intUnitsMonth1 intUnitsMonth2 intUnitsMonth3 intUnitsMonth4 intUnitsMonth5 intUnitsMonth6 intUnitsMonth7 intUnitsMonth8 intUnitsMonth9 intUnitsMonth10 intUnitsMonth11 intUnitsMonth12 intUnitsMonth13 According the values...more >>

Hi, Problem inserting time stamp 24:00:00.000 to an SQL 2K database. App code(EJB-SQL JDBC) constantly receives reading and it calls add procedure to insert reading datetime. So, if reading comes exactly at midnight, the insert fails. Any help is really appreciated. thanks ...more >>

Hi All, SqlComand.ExecuteNonQuery() gives the following exception: Incorrect syntax near '1.', .Net SqlClient Data Provider, at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) Would anybody be able to tell me th...more >>

I am using SQL Server 2000. How best I can synchronise some of the tables of DataBase (say AAA) with the tables from Database (say BBB)?. Tables are identical in both the databases. That is I want to Delete all the rows of a table in DataBase (say AAA) then insert all the rows of a table fro...more >>

i have 3 tables 1-->products 2-->models 3-->brands on three table my primary key is the same name which is *id* models table includes brandsid products table includes modelsid i have a relationship between these tables... when i query with innner join in sql all fields return me as i...more >>

Hi, I need to use REPLACE function to replace a word in the all of the records for one field. Something like this: UPDATE MyTable SET MyField1=REPLACE(MyFeild1,'Old one','New one') My problem is that MyField1 is nText and REPLACE does not work on that. I'm thinking of using UPDATETEXT but it ...more >>

SELECT markalar.id , modeller.id , urunler.id FROM (markalar INNER JOIN modeller ON markalar.id = modeller.markaid) INNER JOIN urunler ON modeller.id = urunler.modelid WHERE (((urunler.id)=1)) it returns (in sql) id id id 1 1 1 it returns (in access) markalar.id ...more >>