Database

declare @sql nvarchar(500)<br />
set @sql = '<br />
SELECT<br />
a.ID AS 'refNumber',<br />
c.Description AS 'Area',<br />
d.Description AS 'Region'<br />
from<br />
tPty_Property a<br />
INNER JOIN tLkp_PropertyGuideDistrict c<br />
ON a.lkpPropertyGuideDistrictID = c.ID<br />
INNER JOIN tLkp_PropertyGuideSection d<br />
ON a.lkpPropertyGuideSectionID = d.ID<br />
WHERE <br />
a.ID IN (' + @refNumber + ')<br />
ORDER BY<br />
a.ID'<br />
<br />
exec sp_executesql @sql<br />

lav naphade wrote:

How to register custom dll into report.rdlc(report viewer)?
and how to custom function in to report.rdlc ?

Mark J. Miller wrote:

So as far as I can tell you need to explicitly grant ALTER permissions for each table and you will need to do it every time you add a new table.

SELECT TOP 2 FROM ... WHERE ... ORDER BY Price<br />

declare @max int<br />
<br />
-- get the maximum value<br />
select @max = max(call) from table<br />
<br />
-- get the highest value below the maximum<br />
select top 1 * from table where call < @max order by call desc

pmarfleet wrote:

Is Google[^] broken in India today?