Hi,
I am having trouble figuring out how to retrieve the data I need from a SQL Server 2000 database.
My table looks like the following:
RecId Int,
EmpID Int,
StartDate datetime,
Description varchar(30)
There may be multiple records with the same EmpId. What I want to do is retrieve the...
Terry,
1) Yes. The user does have update permissions.
2) I believe the answer is no to this one on both databases.
I forgot to note that if the query is changed to the following:
"Select * from table1", the recordset.locktype on the production system comes back as...
I am developing a Visual Basic program that accesses a SQL2000 database. One of my queries is as follows:
"Select * from table1 where id = " & n
where n is selected by the user.
When I open the recordset on my local system using ADO, the recorset.locktype comes back as...
I have a stored procedure that I want to make a copy of a row in a table, except to change the key field and a couple of others. Here is what I have so far:
Create Procedure procCreateAndCopy
@smpId as int
@smpNewId as int
As
Select *
Into #tmpSample
From Sample
Where smpId = @smpId...
I have a Visual FoxPro application with several tables. These tables are created within the FoxPro application from other data sources, and will disappear when the FoxPro application terminates. I would like to use Crystal to report off of these FoxPro tables. Is there any way to use these...
Is there a way, in SQL 7, to build a result set using calls to a stored procedure? I have a stored procedure that returns a result set using a Select statement based on input paramters. I want to have the calling stored procedure return a result set using data from multiple calls to the first...
It looks like you might be missing a , after HumanRes.WeekHours.
_
"HumanRes.LostTime, HumanRes.WeekHours " & _
"ModuleTime.ModulesCount AS Mod_Qty, " & _
Windows in Enterprise Manager (SQL 7 and SQL 2000) forget their size on Windows 2000. This is especially irritating when editing stored procedures because the Ok button is off the screen and I have to resize and move the window to save. This is not a problem with Windows NT. Is there some...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.