Hello Prof. I am on SQL Server 2000 with VB6 and I made My stored procedure on SQLServer 2000 With no any SP but when i installed SP3--SQLSP3-- All Stored Procedure worked on Good way only the delete Stored Procedure didn't work by the way they where working in greate way befor SP3 and the ...more >>

I want to get the common records of 2 tables. However, it turns out the count of the common records of 2 tables is even larger than the count of table TB1. It is so weird and I have no idea why. Here's the inner join statement I use: SELECT TB1.* FROM TB1 INNER JOIN ...more >>

Hi, I want to see wether a given time is between another 2 time parts. In my table I have two fields StartTime and EndTime. I have a stored procedure which accpets a time value which checks wether its between the StartTime and EndTime. I have tried it as below select ..... where @...more >>

Hi, I want to implement a search engine but I don't know how to add an index = to my temporary table in order to delete unnecessary rows preceding and = succeeding the current presentation frame. What I have is a temporary table filled by the content of other tables, = something like: CR...more >>

Hi Experts: I use the 2 lines below to replace the contents of table: "action_table" with full contents of table "data_table". (1) TRUNCATE TABLE action_table (2) INSERT INTO action_table SELECT * FROM data_table The problem is that the after the 2 lines is executed, the number of...more >>

i have another problem to submit you, this time is not access VS AS/400, but Acess Vs Sql2000. I have in sql's table linked in Access (XP but also 2000) linked via ODBC, when i use a from with source type Snapshot and i apply a filter to the form all the records returnes are locked by sql, id th...more >>

We have a simple web form (method=post) that was processing text comments into a varchar(500) field through VBScript in ASP. Unfortunately in the version that went to production, no error handling was performed on form input that exceeded this 500 character database limit. As a result we...more >>

Dear All I would like to program a user-defined function, let's say that my function looks as follow CREATE function get_number_five() returns tinyint as begin return (5) end I have saved this function without errors, I'm just wondering why I cannot display the result of this func...more >>

Hi, Is there a way to check if a scheduled job is running using TSQL? I read lot of messages, But I cant find out perfect Answer! Can I Use sp_help_job?? how can I store the result Set returning from sp?? Please Help..... Regards Dishan ...more >>

Hi everyone, I have no idea how feasible this query is, so please bear with me. There are three tables I need to query against: call them Table1, Table2 and Table12. Table1 has a column named "PartNumber", while Table2 has one named "MachineNumber". Table12 contains both "PartNumber" and...more >>

I wanted to know how to do the following in SQL. I have a table with a column (of text) called "Answer" In answer is an XML substring that I'd like to be able to update, for example: If Answer was equal to: "This is my answer <SOME TAG>Stuff</SOME TAG> and that was my tag" and I want...more >>

If you are doing a inner join on two tables and it produces multiple rows for a unique key, because other field values are different is there a way to grab the first row only?...more >>

is there code that will grab 'textfile.txt' and import it into 'tablename' of sql server 2000? what is it or where can i find it please? thanks, Trint ..Net programmer trintsmith@hotmail.com *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...g...more >>

Hi all, In Sql Server 2000 I am having one master table in myMaster database and detail table in myDetail database as I can not have references across the databases, but I can implement logic in front end. I am having the mythird database where I am having these two tables. I wanted to ...more >>

hola, me pueden ayudar con el manual de T-SQL gracias ...more >>

BOL states that the Lock:Acquired data column uses the Mode field to = indicate the lock mode (type). What BOL fails to mention is what the = various mode numbers correspond to. Does anyone know? J.R. Largo SQL Tools The Finest Collection of SQL Tools Available http://www.largosqltools.com...more >>

Hi, I believe I am over using T-sql, and would appreciate some help with SQL I have the following fantasy portfolio MyInvestments Month Value Jan/02 36,000 Feb/02 42,500 Mar/02 32,400 Apr/02 29,600 I want to return the following MonthlyPerformance% (compared with p...more >>

Mission: To pull images off the D:\Kelly\Images drive where SQL Server is and send to user using a vb.net windows app(internet application). I created a table called images3 which consists of: 1 ITEMNO varchar 50 0 0 IMAGEPATH varchar 50 1 ImagePath is where the images are stored on th...more >>

Dear Concerned, When I hit the DB with a Query and if it encounters to be an Unique Key violation, then I need to format the message into a Custom Message stating which Column of the Insert Query is been violated. I mean instead of showing the DB Error something like.. "Vi...more >>

Dear All I am new to SQL Server so this may seem like an obvious question, but why does running the stored procedure below come up with the error "error in trying to convert varchar to smalldatetime". I would presume that the error is (@StartDate = '1/1/03', @EndDate = '31/12/03') in the use o...more >>