Access violation problem - Need Help

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

Database Design and Application Architecture

Access violation problem - Need Help

Author

Topic

hammadullahkhan
Starting Member

2 Posts

Posted - 2007-06-18 : 18:54:41

I have a task i.e. to make the following query work.
But it shows me syntax error. I dont know what this query is doing and I have no concerns about it. so if any body could help me out that will be a big help :)

SHAPE {

SELECT * FROM Leads
WHERE 1=1
AND ( ([Lead Quality] NOT IN (1,5,6,7) )
AND ( idVendors = '{ADF4406A-ACB7-4610-A03F-702D86CC259F}' )
AND ( idLeads IN (select idleads from [vendors history] where status = 3) )
AND ( [received datetime] between '6/18/2007' AND '6/19/2007' )
AND ( [Lead Type] NOT IN (7,8) )
)
ORDER BY idVendors, [Customer ID]

}
AS [Leads Detail]

APPEND

( { SELECT * FROM [Leads Borrower Information] WHERE [CoBorrower Indicator] = 0 } As [Borrower Information] RELATE 'idLeads' TO 'idLeads'),
( { SELECT * FROM [Leads Borrower Information] WHERE [CoBorrower Indicator] = 1 } AS [CoBorrower Information] RELATE 'idLeads' TO 'idLeads'),
( { SELECT * FROM [Leads Property Information] WHERE [Mailing Address Indicator] = 0 } As [Property Information] RELATE 'idLeads' TO 'idLeads'),
( { SELECT * FROM [Leads Property Information] WHERE [Mailing Address Indicator] = 1 } AS [Mailing Information] RELATE 'idLeads' TO 'idLeads'),
( { SELECT * FROM [Leads Mortgage Information] WHERE [Mortgage Indicator] IN (0,1) } AS [First Mortgage Information] RELATE 'idLeads' TO 'idLeads'),
( { SELECT * FROM [Leads Mortgage Information] WHERE [Mortgage Indicator] = 2 } AS [Second Mortgage Information] RELATE 'idLeads' TO 'idLeads'),
( { SELECT * FROM [Vendors] } As [Vendor Information] RELATE 'idVendors' to 'idVendors'),
( { SELECT * FROM [Lead Quality Reason Values] } As [Return Reason] RELATE 'Lead Quality Reason' to 'Value'),
( { SELECT [Batch ID], idLeads, idVendorsOrders FROM [Vendors History] WHERE STATUS IN (1,2) } As [Vendor History] RELATE 'idLeads' to 'idLeads'),
( { SELECT TOP 1 idLeads, DateTime from [Clients History] WHERE Status IN (3) ORDER BY DateTime ASC } As [Clients History] RELATE 'idLeads' to 'idLeads')

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-06-18 : 19:10:28

Which line produces the error?

Peter Larsson
Helsingborg, Sweden