is it possible to create a friendly data input user input interface for user to key in data using SQL ? or what is the usual way to collect new data into SQL server ? something like a Field Name with a box to enter the data ? ...more >>

I need to pass a completely built SQL statement to a stored procedure as a string parameter and have the stored procedure execute it. Sort of like this: CREATE Procedure dbo.GetQueryRowsWithSQL @SQL varchar (500) As EXEC @SQL return @@RowCount GO Close, but not quite. Anybody d...more >>

I am trying to use a stored procedure to retreave some data acording to date the date comes in like '9/11/2003' however when i use this stored procedure it returns nothing. if i use this select statment in query analiser it works fine. if I remove the @RequiredDate string and insert the date dir...more >>

Hi, I just have a question for this group because i could not find any information about this: Can I use SQL-DMO to access a remote database? Do i need to do something special? Thanks in advance. Carlos Beltrán Vázquez ...more >>

Enough of banging my head against the wall! Maybe someone else has already been here and done it. The following code returns 535 records: SELECT * FROM [OrderDetails Temp] WHERE ((([OrderDetails Temp].OrderID)= 2104) AND ([OrderDetails Temp].CategoryID IN (1,2,3,4)) ) ORDER ...more >>

I'd like to know what's the sentence to display just duplicated fields. Example: I need to know where are duplicated mails in my database. Thanks. -- Marcelo Balgurevich balgurevich@2vias.com.ar Buenos Aires - Argentina ...more >>

Hi! I would like to write a stored procedure that can take a variable number of parameters (I know how to do this part) and update or insert a record from the supplied data... The part I don't understand is how to write the update/insert statement to deal with the optional variables... I cann...more >>

I have a report that produces a commission for our customers. Each row has details of a sale plus commission paid. In addition, each sale may have any number of notes. Each not on a new line. The notes are stored in separate table that is indexed by the sale id. In order to show the data I...more >>

How to do the multiple rows update within Access update quer where I need to update column CurrentCount in the table Cards wit values CurrentCount from the query countCards where cardId exist in both table and query So, I get the "Operation must use an updatable query." error when I tr some ide...more >>

Is there a website that has a list or table of all the sql commands and a description of them? I tried looking up on MSDN and Google, but I always end up with some irrelevent websites. Thanks in advance, Aaron...more >>

I am a new to sql and I'm interfacing with a large db that has SERIAL, P_SERIAL, LINKSERIAL fields at the beginning of every record. Is there someplace or a paper I can read on the function of these fields? Thanks, Bill...more >>

Need help with this query SELECT * FROM table1 WHERE FIELD2 is contained in FIELD1 ie. FIELD1 = "dfdf dsfdsf dfadfdf" FIELD2 = "dsfdsf" OK FIELD1 = "dfdf dsfdsf dfadfdf" FIELD2 = "erwerew" NOT OK both field1 and field2 are varchar type. thanks...more >>

Hello How do I change the owner of a dts package? I've tried sp_changeobjectowner in msdb but it can't find the object. Also, does the DTS pacakge execute under the credentials of the sqlagent account? or if you use DTSRUNUI and put in you logon credentials, does it use those rather? Than...more >>

Hi I've a table with 4000 records and following structure, and sometime I've got an error like below why? CREATE TABLE [ENPARTT] ( [ENPART_COD] [char] (6) COLLATE SQL_Latin1_General_CP1256_CI_AS NOT NULL , [ENPART_NAME] [char] (30) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL , [ENPART_...more >>

I'm trying to either insert a record from TABLE A if it doesn't exist in TABLE B or update a record from TABLE A if it exists in TABLE B. Thanks, JB...more >>

I can't be the only person who's ever tried to do this but I can't find an answer anywhere... How can I set up a column to hold duration in MM:SS format and then be able to add them together eg record the individual track lengths on a CD and then add them up to get a total playing time. Many t...more >>

Hi there, I have a table with training details, each record is a training that a member of staff as done, e.g. Training table tid: 01 Staff: Peter Training: MSOffice Done: Y tid: 02 Staff: John Training: Quark Done: Y tid: 03 Staff: Peter Training: Quark D...more >>

Hi have the sql program on the C drive I have all the data files including "master" on E. Sigh - must do maintenance If I copy everything from the E drive to a new drive, delete the E drive, then assign the letter E to this new drive, will SQL work? ...more >>

Hello I want to synchronise between two databases. Specifically between a list of tasks on a mobile phone and a table of Tasks in an SQL database. The fields are slightly different in the two database types and the common fields are task (text) and Priority (low, medium or high). I was th...more >>

Hey guys, The following code give me this error, "Must declare the variable '@numon'." I don't understand why, since I declare @numon at the beginning of the code. What am I doing wrong? Thanks, Paul Blaser declare @col varchar(10) declare @sql varchar(500) declare @numon dec(5,2) dec...more >>