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],...
Hi, 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...
The following is the SP CREATE PROCEDURE GetClientMatchingPropertyList ( @ClientID INT, @FirmID INT --, @ExcludePropID INT ) AS /*...
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...
Hi all, I was using Crystal reports 8.5 for reports. Where to call reports for multiple Coordinators the crystal syntax is "coordinators IN [ ''...
Hi all, 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'. The...
Hi all, This is a very good tool for getting our solutions. Keep it up. I have implemented the SQL Reporting services from the asp based...
Hi everyone, 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.