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
Its in SQL 2000 Reporting services. Could you please elaborate on your answer .. may be that would help me in getting closer to the solution
I have developed reports in SQL reporting services.
They have to be send via ASP pages with some predefined formats like (WORD, EXCEL, PDF ETC)...
I have a report calling method in SQL reporting services which should only generate the reports but without viewing the report it should convert the...
I was using Crystal reports 8.5 for reports. Where to call reports for multiple Coordinators the crystal syntax is "coordinators IN [ ''...
I have a table called as [tbl-LoginDetails] and I updated a old tables values where all the data went in the field named 'First'.
Will go through n let u know.
This is a very good tool for getting our solutions. Keep it up.
I have implemented the SQL Reporting services from the asp based...
I am new to this topic. We have converted our clients Crystal Reports based reports to SQL server reporting services based reports....
Separate names with a comma.