Hi All, Thank you for the support. Here I've learned many things. Thank you very much! I'd like to ask you something... I'd like to CREATE VIEW among these tables: UsersTable ------------ UserID(PK) | UserName | Password | Name | Addr | E-mail | UsrType | Role | LastLogOn EstatesTbale -...more >>

Perhaps it's just too late at night but I just can't seem to get this right. I'm trying to create a UPDATE trigger on a table which will update another table. What I would like to do is declare an INT variable in the trigger and then assign it a value retrieved during a select statement. In gen...more >>

I'm designing an application that will be sold to multiple customers, each of which is a small business. The database behind this application will be accessed via the Internet, and will be shared by *all* customers. Each business is permitted to access only its own data. For a variety of reasons,...more >>

Dear Sir, Can you just help me, how can I get the number of fields present in a adodb.recordset Regards RSRK ...more >>

I have 5 measurements that I enter into my table every day. I like to calculate the STDev for these measurements: ID1(PK) ID2(PK) Date loc1 loc2 loc3 loc4 loc5 standard_Deviation 2221 1 7/17/04 2.5 3.2 2.4 2.8 2.5 ...more >>

Hi All, I have a SQL table called Test containing two fields :YearDate (int) and Value (float). That table contains several years and, for each year, sevaral values. I have to write a SQL statement allowing me to get the n (n=5,10 or 15) greatest values per year. I wrote a procedure to solv...more >>

I was wondering if someone could please help me with what I'm sure is a very easy thing to do...reference back to the current record during a select statement for validation and accurate results. I am trying to write a stored procedure that returns a few fields from two tables. A (hopefu...more >>

I have this query: Select * from openquery(myOraDB, 'Select * from myOraTable') Is possible to create a view with this query? ...more >>

I am not sure whether i am wrong of misusing this excellent newsgroup. Well i am not very good at sql (rating 6/10), But i have a 2 yrs exp in MS Access. I am lookig for job in sql. i am presently located in Mumbai. So any one from Mumbai !!!! Panks ...more >>

Sometimes, when I made a mistake in table definition, my stored procedure will produce error complaining about data type conversion. COuld I make SQL server to report the column name that cause the error? It's very time-consuming to debug this kind of error without knowing the exact colum...more >>

I just want to avoid the possibility of creating an application that works most of the time, but periodically chokes because the planets aligned in a way that resulted in an invalid text pointer. Specifically, my objective is simply to enable users of an application to store large strings of t...more >>

e.g. I want to import data from "another_table" in "another_db" to "my_table" in "my_db", which "my_db" and "another_db" may belong to SAME or DIFFERENT database instance in MSDE 2000, or even more, "another_table" belongs to Access database. I know I cannot use these in MSDE 2000: select ...more >>

Hi all, I hesitate what to use SPs or triggers. I would like my queries to be as fast as possible. My data base is something like this: UsersTable ------------ UserID(PK) | UserName | Password | Name | Addr | E-mail | UsrType | Role | LastLogOn EstatesTbale ----------- EstateID(PK) Ci...more >>

I have created a stored procedure that returns a single value, a calculation for stock items manipulation over some period of time. When I run stored procedure from QA, it takes some 15 seconds to execute. But, when I run it via ADO, using Microsoft Fox Pro, even when I set .CommandTimeout prop...more >>

When entering ' or ''=' as login and password SQL generates a query that grabs the whole recordset from the queried table. sql = "select * from Users where UserName='" & request("login") & "' and Password='" & request("password") & "'" will result in select * from Users where UserName='' or...more >>

(SQL2K, Access 2003) I'm getting an error: "Syntax error (missing operator) in query expression 'xr.ours ..." Here is the script that works fine in SQL2K update fx set fx.ours = xr.ours from tcaFix_IT fx inner join tcaXref_IT xr on fx.courts = xr.courts Any ideas? Is it related to Al...more >>

I´m trying to do something like this: CREATE PROCEDURE [dbo].sp_SelectTopNcities ( @qty int ) AS SELECT Top @qty * From Cities But the syntax is wrong ... any tips?...more >>

Hi, I have a stored procedure that inserts items to invoice into a table, first checking there is not already an entry (for that week) already there (using a NOT IN clause). If I run the query contained within the stored procedure directly in QA it takes 1-2 seconds. However, if I execute the s...more >>

I want to write a query that allows me to get a full list of all the roles that a user is a member of within the SQL sysusers and sysmembers tables. My principle obstical are the subroles, sub-subroles, etc type situations. In other words: User Z is a member of Role C which itself is a m...more >>

What is the Difference between SQL7 and SQL 2000 --Panks ...more >>

What is the difference between Truncate and delete Statements Eg DELETE from table1 -- deletes all the rows , so does TRUNCATE table table1 ...more >>