Please do not cross-post.  We monitor all boards.

Finish the thread here pls : http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=325058

Please do not cross-post.  We monitor all boards.

Finish the thread here pls : http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=325058

Please do not cross-post.  We monitor all boards.

Finish the thread here pls : http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=325058

Because NULL is not equal to 1900/01/01.  NULL is not even equal to NULL.

May I suggest a default value of the parameter in the proc?  That would simplify the case...

Can't think of anything else at the moment... not without the plan anyways.

Updated the stats?

Any differences in the execution plan?

Any convert_implicit in the 2nd plan?

Tried to clear the proc cache?

How can a whole application depend on a single SUB?  I mean it's not like we're asking him to change the MAIN() FUNCTION!!!

Anyways as long as it works and no one...

How about import in 2 columns. Clean his cold call list then return is list?  Maybe there would be a need to concat but I guess you know about the...

What rewirte??? Takes 2 minutes to write this and test!

Err sorry : in YOUR application .

Why not keep them separated in the DB and merge them in his application and reports?

I wouldn't call that a proof but it would be a good start toward it :

SET STATISTICS IO ON

Go

SET STATISTICS TIME ON

GO

SELECT COUNT(*) FROM master.dbo.SysColumns

-- I would assume this...

Cool, good luck with the rest of that project!

If that doesn't help him, it may help someone else someday. .

What topic do you have in mind (that hasn't been covered 10 times over already)??