Hi everybody, I want to read dataset records from other dataset before updatebatch process. Is this possible ??? If this is possible how can i do ??? -- all DataSets locktype is BatchOptimistic Thanks for advise ...more >>

Hi I have two tables create table product (product_id char (4), product_name char (36), price float ) insert into product ('1234','trouser',175.00) insert into product ('2346','shirt',75.00) insert into product ('7989','milk',3.00) insert into product...more >>

This is hurting my head. I have a table showing the historical status of refineries. They can only be open or closed and the period covered is from 1977 to still open (null) What I need to do is write a procedure that will insert into the table and will adjust any overlapping dates. eg 1977<--...more >>

I am a new programmer of SQL server 2000 via vb.net. When I change something in datagrid, the above error takes place. The program is list as follwoing: Does anybody could help me? Thanks a lot. cn = New SqlConnection( _ "Server=TEST; database=TEST; UID=sa; pwd=test") strSQ...more >>

I want to insert LastModify Date after insert or update.. Here is the trigger for insert: ------------------------------- CREATE TRIGGER [MODIFYDATE] ON [dbo].[AH_SubMaster] FOR INSERT AS Update [AH_SubMaster] Set [LastModify] = GetDate() Where Master_ID = (Select Master_ID From ins...more >>

Okay. I have this dataset, looks like this: propnum rundate genregroup totalcharges ----------- --------------------------------------- ---------- ------------ 16 2005-05-27 00:00:00.000 A 131.8800 16 2005-05-27 00:...more >>

I have created a stored procedure that reads e-mails sent by users and carries out the relevant actions dependant on the Subject line. Within the procedure I call upon xp_readnextmsg, xp_readmail and xp_deletemail using the prefix of master.dbo. The problem I have is that if I run the proc...more >>

Using SQL Server 2000... In support of a Web site's product catalogs; we will have at least two tables [Products] and [ProductCatalogs]. The application needs to show the Date/Time any given product catalog was last updated. For purposes of this "last updated date/time" value, we conside...more >>

Hi Would it still be currently regarded as best practice to use OPENQUERY to run remote queries? Regards Richard ...more >>

i wanted to store the output of my store proc in a temp table and i wsa doind this: INSERT #temp EXEC sproc and it turned out i cannot do this if my sproc has another insert...exec thing going on within it. Is there any way i can store the output of my sproc somehow ? thanks in advan...more >>

I'm stucked in a SQL query. I have: TableA (KEY_A, Name) TableB (KEY_B, Name) TableC (KEY_A, KEY_B) I need a query to display: KEY_A KEY_B Is_in_C --------------------------------------- A1 B1 YES A2 B1 NO whe...more >>

Hi, I get different values and a calculation from a query and need to bring them all together to make another calculation. @PRICE,@TIME,@CALC,@TOTAL @PRICE = 3 @TIME = 5 @CALC = '* .5' @TOTAL = (@PRICE @CALC) * @TIME I tried to use the exec command, but couldn't get it to work How can I do...more >>

I don't know why I never noticed this before, but in the code below, why can I ORDER BY an aliased column, but I have to use the *actual* column name or expression in the GROUP BY? I would really rather say "GROUP BY Column1, Column2" CREATE TABLE msl_T1 ( col1 INT, col2 INT, col3 IN...more >>

I have 2 tables - student and student_exam. Each student takes 5 exams, and I want to return the sum of the exam scores by student, counting only the top 3 per student. Using the example below, my desired results are as follows: Student B 246 Student A 236 I have tried countless SQL stat...more >>

how can I query a sorted view by rows - show rows 50 to 75 or show last 25 rows ? thanks ...more >>

how would you design a table that allows an item to belong to multiple parent categories. single parent example: select * from table1 where parentid = 5 in this case parentid is an indexable unique integer possible multiple parent: select * from table1 where parentid = '5,6' a problem is...more >>

Hi, I have a random password stored procedure, I need to update all the contacts without a password with a new random password. I need help on my update statement. My update statement below contain the EXEC command, therefore it failed. Please help. Thanks, Culam CREATE PROC dbo.usp...more >>

Hello, everybody, Can somebody tell me how I can query a field that has a date >1/1/2000? I don't want to be specific using a BETWEEN clause. Thanks, Antonio...more >>

Hi All, I have an xml file with a lot of structure and I want to import each part into a field. How can I do this taks? Here is sample of xml structure <?xml version=""1.0""?> <FieldTitle1> <Request> <Reference> <Customer>ABC</Customer> <XpciVersion>1.0001</Xpc...more >>

Is there a better more reliable or eaiser way to get what I'm looking for? I want anything that was created after Jan. 1, 2003 that was declined, the declined letter codes are as indicated, and created after Jan 1, 2003 Or, I want anything that was rated and created after Jan 1, 2003 Or, I...more >>

How can I count the amount of characters in a column that is varchar and how much space do I have left?...more >>

I am joining 2 tables and I would like to return records whose xdate > getdate() and xdate = null. My query below works but I was wondering if I could use a better way? like IsNull ? select name,department from table1 join table2 on table1.id = table2.id and active=1 and (xdate is null or x...more >>

OK... So I wrote the following stored procedure and it runs just fine but I can't seem to get the job to fail on a return of 1. Any ideas? CREATE PROCEDURE [dbo].[gs_VerifyImportLite] AS DECLARE @timeCheck datetime SET @timeCheck = DateAdd(hour, -1, GetDate()) if exists...more >>

I would like my C# dll to return a float (value) so that I can use that value within the SQL Server stored procedure. There seems to be a limitation on the return types from CLR (CLR methods return either SqlInt32, System.Int32, void.) I would appreciate if anyone can suggest a workaroun...more >>

I had a "fine" report for current year revenue, but of course that's not good enough :) I was asked to bring in 2 more columns of last year revenue and year before that. Yr2003, Yr2004, 2005-1, 2005-2,.. 2005-12, Yr2005 I did a union for the prior year(s) data as well as the total for c...more >>

We recently migrated one of our databases to a new server and now we have to manually modify all of our T-SQL scripts to use Fully qualified Linked Server Name in order to reference the new database on the new server. The problem is that this is a very slow update process because we have to be v...more >>

Hi all, How to delete one row of data from a table? -- TS...more >>

I have a situation where I am using Service Broker that sends an XML payload upon a DML action. On the recipient server I am consuming the XML payload and processing the request (please don't tell me this is what replication does...there are several reasons we need to use this method over r...more >>

Hello! In a doctor-patient table relationship, I need the patient to only have one doctor but the doctor can have as many patients as he wants. What is the easiest way to set this up? Thank you! ...more >>

Is there a way to change a column name in one of the tables? Say from XX to YY. What's the syntax for that? -- TS...more >>

Hi everyone! What's the difference between day and dayofyear in the datediff function? Thanks. Jaime Lucci ...more >>

Dear all, I have a single table, and have records for two toolkits - one for the actual scorecard with TOOLKITID =105 and a weighting scorecard with a TOOLKITID=104 RESULTS is the actual entries for the scores for both toolkits.For a particular actual scorecard abd weigting scorecard, the...more >>

Environment: SQL 2000 Sp4. I have a SQL job (Same Name) on two servers and based on some criteria, I want to run the job on one of these servers from a third server. Any sugestions on how to do it... Thanks in Advance. ...more >>

Hello, What would be good syntax to add to a DTS package to make sure that all of the records from a live system made it into a warehouse table? Would it be as simple as a COUNT(*) - and if so, how would I use that to notify or fail if all of the records do not make it into the warehouse? ...more >>

I have table TABLE1 with 101 columns ID - int Notes1 char Notes2 char Notes3 char Notes4 char Notes5 char Notes6 char Notes7 char Notes8 char Notes9 char Notes10 char .... Notes100 char I want to SET defaults values for all NotesX columns to "EMPTY" How to write scripts for that. ...more >>

Hi, I want add an additional filter to the following CASE statement and using NUM_VEH on Line 7 'determine when the product type is QMV and number of seats is greater than 4 then assign PRODUCT_TYPE value = 2'. What is the right syntax to do so? SELECT product_group = CASE WHEN PO_RSK_ITEM ...more >>

I have a piece of SQL that is giving me a bit of trouble. This piece of = code uses inner and outer cursors. Here's the chunk: --APPLY PRIVACY SETTINGS DECLARE PRIVACY_CURSOR CURSOR FOR SELECT DISTINCT USERID=20 FROM #USERS =20 OPEN PRIVACY_CURSOR FETCH NEXT FROM PRIVACY_CURSOR INTO ...more >>

Can anybody help me with this stored procedure? Basically I need to do something like do: Total = Premium + (WHEN AddOn1 != -1) + (WHEN AddOn2 != -1) + (WHEN AddOn3 != -1) To clarify, the value 'Total' needs to consist of a field called 'Premium' plus the AddOn1, AddOn2, AddOn3 IF they are ...more >>

Hi, I have a simple web application. It has a search feature which searchs the database for matches document based on what the user enters. The query just does a select ... where document like '%userinput%' . Document is just a text column. I want ot rank the results based on relevants...more >>

Hi ! I am programming in ASP against a SQL database, and have a little question I hope to get some help on here : I retrieve data about products to my .ASP page, with checkboxes if a product is active or not. The problem is to automatically name these checkboxes seperately, so it belongs to...more >>

i have 2 tables in a database one is recording all the fax-in to users, the another is recording all the fax-out by users. i wish to combine the tables (by JOIN?) so that the users can see its own fax-in and fax-out. After the join, then the new look is TableA.date, TableB.date in 2 colum...more >>

Hello, I would like to search one Key ( field ) and value in every tables of my Database. And i would like to get the List of the Tables and related rows. eg. I would like to search for intUserID and value = #value# in my Database ( every table ). Is there any method to ...more >>