I need to use SET CONCAT_NULL_YIELDS_NULL OFF before I execute an SQL query that concatenates columns that contain nulls. The only way I have been able to do this is in an Execute DTS 2000 Task. I have tried using an Execute SQL Task, but I can't get the SET option to work there. I would prefer not to use the Execute DTS 2000 Task, how can I do this
Thanks,
Greg
setting database options (CONCAT_NULL_YIELDS_NULL)
Hot Topic
- cannot view
- Very slow GROUP BY with SQL 2005 on 64bit Multiprocessor Server
- Problem whit Logshipping Error 952
- Connectivity issues
- Gettint error "product level is insufficient" - did full re-install of SQL 2005 Standard Edition
- How to suppress the subreport when there is no data in it?
- Global Temp tables
- Change Column Order in Report
- Best way to handle License issues
- A/Synchronous execution of SSIS ETL packages
SQL Server
- creating a database, tables, records, and fields in a Sql server 2005 express
- OLEDB command gets compile errors but works in Query analyzer.
- Error 14421 log shipping
- Problem with Client Side Printing
- output to text file
- How is the metadata of the result of a UNION determined?
- how to define a parameter in reporting services to choose to show/hide not null/null values?
- Connecting in the Analysis Services using DSO and IIS
- Printing report produces .25 inch horizontal offset
- How to encorporate IF
setting database options (CONCAT_NULL_YIELDS_NULL)