Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kid_le
Starting Member
4 Posts |
 Posted - 2008-04-11 : 11:16:21
|
| I recieve this error when trying to create my sproc:Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be set for the connection. This ensures consistent query semantics. Enable these options and then reissue your query.Here is my sql code: INSERT INTO OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=\\dmhc\dfsapps\Clarify\Reports\Generated\ADT007DUMP.xls;', 'SELECT [Case ID], [HC Rec''d Date], [Case Type], [Patient/Provider Last Name],[Method Of Contact], [Complaint Category], [Complaint Type], [Complaint Details], [Health Plan],[Medical Group], [RO Determination], [Close Reason], [Close Details], [Compliance], [Summary Resolution] FROM [Sheet1$]') I'm able to create the sproc when I turn the ANSI_NULL ON but that will cause the return to drop any records that have a null value. I would like it to return all records even if there is a null value in the fields. I don't know if this helps, but I'm also creating some temp tables in this sproc.Any suggestions would be greatly appreciated. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-04-12 : 04:14:58
|
| What fields you are having NULL values and where are you comparing them? |
 |
|
|
kid_le
Starting Member
4 Posts |
Posted - 2008-04-14 : 11:14:53
|
| Thanks for the quick response vsakh16. Null values can exist in many fields, (i.e. Close Reason, Close Detail, Compliance) anywhere where the field is null, it doesn't get returned. I'm not comparing the null values at all. I'm just doing a Select from multiple tables. Your help is greatly appreciated. |
|
|
|
|
|
|
|
|
Heterogenuous error when using OPENROWSET