I've a table with ID & MSG columns. ID is unique identifier & msg is NVARCHAR MAX.
abc><poc><tna name="a" value="abc" /><tna name="b" value="def"...
I think I have put it vice versa
I know this works in SQL
But I want the exact query to work in Access
How would it frame in Access?
I have a query which is in Access works in SQL but not in this
The following is the query
SELECT E.[ID], [InitialEnquiryDate], [lkpTitleID],...
Could someone let me know when does SQL Server fires the following SET Statement?
SET FTMTONLY ON
SET FTMTONLY OFF
We are finding these...
Hi,<br /><br />I donno whether I have come in the proper forum ...<br />But still may be near by the area of the problem<br /><br /><br />I have a...
I had a modification in a query where a new table tpty_PropertyPhotoStatus was been created along with the existing table tpty_PropertyPhoto.<br...
Thanks ... thats the solution I needed
Thanks you again Adriaan
>>I tried with this
MultipleIDs LIKE ''%' & p.[ID] & '%''
but the error remains the same
>>But then tried with
MultipleIDs LIKE ''%'' + p.[ID] +...
The following is the SP
CREATE PROCEDURE GetClientMatchingPropertyList
--, @ExcludePropID INT
Separate names with a comma.