I need to run this update Update Cases set archived = 2 But only on records found with this query ... Select * from Cases Inner join processstep ON cases.PROCESSSTEP = processstep.ProcessstepID where processstep.Processtep LIKE '%closed%' How can I do this ? Aleks ...more >>

Dear Experts, I have a log file that is stored in a nested tree format. The logical record is this: int datetime int eventid int deploymentid int recipientid int templateid If the data were stored in a typed file it would be 20bytes/record which would be a problem because we add about ...more >>

All, What's the easiest way to add a few new parameters to this sql string? I need to retrieve data from one table, add a few new values in the same script and save this data in a remote database table. For example: INSERT INTO tblRemoteTable Value1, Value2, Value3, Value4 (SELECT Value1, V...more >>

I have three tables I need to relate to each other in a query. The PE table relates to the PRP table by ST_NUM and COURSECODE. The PRP table, in turn, relates to the PREP table by PRPCODE. There is no direct relation between the PE table and the PREP table. The data entry query I need to wr...more >>

I'm getting error "Command Execute Insert Multiple step OLE DB operation generate error..." when inserting a new record into the following table: CREATE TABLE Profession ( SeekerID INTEGER NOT NULL, SkillName NVARCHAR(30) NOT NULL, JobType SMALLINT, SubType SMALLINT, Prime BIT N...more >>

Hi all gurus If I want to count the size of a Table that how much space the table will contain after filling the table with some millions of data how can i count it from an empty table. Thanks and Regards Amish M Shah ...more >>

I got a "description" field in my tables with char(40) Now, How I can I Trim(descprition) by using sql statment ??? thanks in advance ...more >>

When using "Set Rowcount" in a stored procedure that is executing a SQL select statment that contains a sub-query in its where clause, does the rowcount get applied to the sub-query as well? If so, how would effect my results? For example: SET ROWCOUNT 1000 SELECT Hdr_VdrNbr, Hdr_Inv...more >>

(Sql2K) In QA, I would like to automatically send the results of a script to a filename. Now I have to select 'Results to File' before I run the script then specify the filename afterwards. Is there a way to do this? Or ... can you tell me a better way to do what I am trying (see below) d...more >>

Hi, I'm using Sql 2000 Enterprise. I've setup a couple of instead of triggers that put the value returned from GetDate() function in one of the table fields. I've inserted serveral records and non of them has saved the miliseconds portion of the time, all the have is up to seconds. Is ...more >>

Does anyone know if Microsoft has an article that compares dynamic and static sql queries, and when it is appropriate to use each? I have found several other articles from IBM and Oracle, but would prefer to see what people from Microsoft have to say. Thank you!...more >>

Hello, I have a number of Pass-Through queries to an SQL-Server backed. The ODBC connection string property of Access report is set to the following: ODBC;DSN=testDsn;UID=sa;PWD=;DATABASE=testDb 1. Is it correct to say that each time I open a query a new connection is created? 2....more >>

Within a stored procedure, I need to retrieve XML over HTTP from an external URL, then load some stuff into a recordset and return as such. Like this, sort-of: -- ******************************* create procudure queryremote (@param) declare @xmldoc varchar(2000) set @xmldoc = (GET ...more >>

Is there a way to use the execute method to retrieve data from a single field. I use... sqlStr = "INSERT INTO Table (data1, data2) Values(1, 2)" con.execute sqlStr to insert info into the db Is there a similar execute method to retrieve it without opening a recordset? any tips or po...more >>

Hi all, I am a newbie to SQL programming and I was hoping that someone can provide me an optimized (leaner) version of this code: ALTER PROCEDURE dbo.quo_Whos_Update @UpdateWhoID INT = 0, @UpdateWho VARCHAR(10), @UpdateWhoValue VARCHAR(10), @UpdateWhoNameValue VARCHAR(10), @Result I...more >>

Hello all, I have a table Boxes and a table Products with a 1:n relation. 1 Box can have N Products. And I have a third table that is a non-normalized version of these 2, with BoxName and ProductName fields. My Boxes and Products tables are empty, the third table is filled. I want to conver...more >>

Hi I want to read my user logs . my users are sql server users , i want to know which one of my users insert-update-delete on which one of my table , or execute a stored procedure , how can i know which user do what? thanks...more >>