...bulk inserts or truncate/indexes will neither insert take place and the truncate table crmuser.cad_base_table won't happen ?
thank you
so
/*
SQL CRM_load_LPG.sql
Date Written 11 October 2005
Purpose To populate CAD table information on
Amendments
23/11/2005 R.G.HUGHES include...
Hi
I'm new to IIS - we have version 6.0
a new 3rd party software package has been loaded on - a new website created under web sites, called customertest.
today the application seemed to hang, and i did a iisreset /restart and it worked ok then !
it seemed to be talking about lack of memory - I...
thanks
i get an error now - I know there is an error within the 2nd bulk insert, but using query analyser i get
The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION.
Server: Msg 50000, Level 16, State 1, Line 6
Error in inserting llpg data.................
The ROLLBACK...
...to continue. Does my code look ok or have i over/under complicated ? (I don't think i need to rollback if the drop indexes fails)
thanks
kim
/*
SQL CRM_load_LLPG.sql
Date Written 11 October 2005
Purpose To populate CAD table cad_base_table with combined LLPG data Amendments
*/...
i have the following sql statement which I'd like to add another inner join to. I have a table called cts_enquiry_services which has two columns I'm interested in, EnquiryTypeID and ServiceID. ServiceID links back to the
ServiceID in cts_services, so i want to add an inner join for...
Hi
I'm using a 3rd party software package and doing an insert with 2 columns (neither are identity columns but just numeric) the identity column is columnID (primary key int(4))
the insert statement is
ExecQuery_X "CONN_Z","00010::insert into tblComplaint_ISB (crmCallID,CustomerID) Values...
thank you everyone - works a treat
Rekcor - I have given your earlier post a star also because once i rewrite them completely i will take that into account
thanks again
thanks rekcor
I'll take note of that for the future, problem is I've inherited this 3rd party software product and I don't want to (and haven't the time) at this early stage to re-write the whole thing, so that code is their's - I just can't seem to add validation for my custom fields...
Hi
I have an existing form which I need to mofidy - I have 2 new checkboxes which i want to validate for if they are both checked = false
I have tried fitting in this check within the existing validation below but it doesn't call it ?
the html for the checkboxes is further below also
any...
thanks everyone
I eventually have got it working using my code below
Dim dbs As DAO.Database
Set dbs = CurrentDb
Dim stra, strupdatea As String
Dim rst As DAO.Recordset
stra = "SELECT intStratID, Min(ReviewDate) AS NextDate FROM dbo_tblStratReviews where ReviewDate >= date() GROUP BY...
Hi
I've got a main table called tblRiskMain with an identity column called intRiskIDcalled and a column called NextReview (type smalldatetime)
sample data
-----------
10, 01/01/2004
11, 01/01/2000
i have another table called tblStratReviews with
columns intStratID, intRiskID, ReviewDate...
Hi
i've got the following code. I won't know how mnay items will be in List0, because it gets added to frequently. therefore i can never say how many cases I require (in the example below i have used 5) but it might be 12, it might be 14 etc. How can i match the number of case statements to the...
yeah I've given up with conditional formatting....is there any way you can say to move next on the OnFormat detail event procedure, as in move to the next record ?
thanks
Hi
I have a report rptFormA containing 2 subreports
[dbo_tblStratRecords subreport]
which has a field intNewID (primary key)
and
[dbo_tblKeyComponents subreport]
which also has a field intNewID
the [dbo_tblStratRecords subreport] may have 2 records with the intNewID's being 1 and 10 for...
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.