<div>
select ps_tbl.DESCR <br />
from PSDB..SYSADM.PS_PRODUCT_TB<wbr />L ps_tbl <br />
where ps_tbl.PRODUCT = &nbsp;substring(ccontl.gl_type_i<wbr />d,7,4) &nbsp; --- no quotes here 
</div>


select ps_tbl.DESCR
from PSDB..SYSADM.PS_PRODUCT_TBL ps_tbl
where ps_tbl.PRODUCT =  substring(ccontl.gl_type_id,7,4)   --- no quotes here

<div>
Thanks. &nbsp;I got &nbsp;the following error after putting the modified Clause<br />
<br />
Can not resolve teh collation confliect between<br />
&quot;SQL_LATIN1_GENERAL_CP1_CS<wbr />_AS&quot; &nbsp;and<br />
&quot;SQL_LATIN1_GENERAL_CP1_CI<wbr />_AS&quot; IN the equal to operation<br />
<br />
any idea about that?<br />
<br />
thanks<br />

</div>


Thanks.  I got  the following error after putting the modified Clause

Can not resolve teh collation confliect between
"SQL_LATIN1_GENERAL_CP1_CS_AS"  and
"SQL_LATIN1_GENERAL_CP1_CI_AS" IN the equal to operation

any idea about that?

thanks


<div>
<br />
select ps_tbl.DESCR <br />
from PSDB..SYSADM.PS_PRODUCT_TB<wbr />L ps_tbl <br />
where ps_tbl.PRODUCT COLLATE SQL_LATIN1_GENERAL_CP1_CS_<wbr />AS = substring(ccontl.gl_type_i<wbr />d,7,4) COLLATE SQL_LATIN1_GENERAL_CP1_CS_<wbr />AS
</div>



select ps_tbl.DESCR
from PSDB..SYSADM.PS_PRODUCT_TBL ps_tbl
where ps_tbl.PRODUCT COLLATE SQL_LATIN1_GENERAL_CP1_CS_AS = substring(ccontl.gl_type_id,7,4) COLLATE SQL_LATIN1_GENERAL_CP1_CS_AS

<div>
thanks, it works. Can you tell why it's working? also why do I need to punch the<br />
COLLATE SQL_LATIN1_GENERAL_CP1_CS_<wbr />AS?<br />
<br />
Hui<br />

</div>


thanks, it works. Can you tell why it's working? also why do I need to punch the
COLLATE SQL_LATIN1_GENERAL_CP1_CS_AS?

Hui


<div>
<div class="content wysiwyg-content">
Hi there:<br />
&nbsp; I have a query which requires the liked server in sql server . Below is the query.<br />
However,it always returns NULL data...<br />
<br />
Anyone has seen this before?<br />
<br />
&nbsp;thanks<br />
<br />
&nbsp;Hui<br />
<br />
<br />

<pre><code id="code-318090">select ps_tbl.DESCR from PSDB..SYSADM.PS_PRODUCT_TBL ps_tbl 
where ps_tbl.PRODUCT = ' substring(ccontl.gl_type_id,7,4)'
</code></pre>
</div>
</div>


Hi there:
  I have a query which requires the liked server in sql server . Below is the query.
However,it always returns NULL data...

Anyone has seen this before?

 thanks

 Hui



Using Linked Server in SSRS 2000 Reports( Linked Server Query returns NULL)

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.