After Re-Reading the Section in BOL on SET_QuotedIdentified I decided this probably wouldn't work for you.  I believe the real solution will be to use a format file.  This way...

Do you have any control over the way the import file is created?  If so, can you change the delimiter from a ',' to something that won't be included in...

You need to use it once for each date...

WHERE created_date BETWEEN DATEADD(mm, DATEDIFF(mm,0,'08/01/2006'), 0)  -- Eq to {d '2006-08-01 00:00:00'} or 08/01/2006 00:00:00  

      AND DATEADD(mm, DATEDIFF(mm,0,'08/02/2006'), 0)  --Eq to {d '2006-08-02 00:00:00'} or 08/02/2006 00:00:00

It drops any time portion from a date...

Depending on the size of the table yyou are querying the cast may begin to perform poorly...  Another Alternative that you'll actually be able to pass a datetime to as...

Since you're writing out a file anyway, why not use DTS?  You can call your DTS Package through DTSRUN, since you're already using XP command shell I figure this shouldn't...

So you just want to copy all of your records from table b to table A?  If that's the idea have a go with this...

INSERT INTO tableA

Although my title is 'database analyst', I spend a decent portion of my time as a VB developer and general IT lackey as well.

Are you setting variables inside of your sproc?  I've seen issues where if you have a statement like

DECLARE @MyVar

SELECT *

FROM tblMytable

WHERE col1 = @Myvar

If the variable doesn't have a value,...

Could you please be a bit more specific about the errors you are receiving?

They wouldn't tbe talking about this powERPro would they??

http://www.powerpro.co.in/indexpage.htm

Yes, absolutly. 

Sorry for the typo.

It seems to me the answer to your qurstion would be... It Depends...

What are you trying to do?  What kind of code are your attempting to do this in?

Don't know if this will help with your True/false issues , but it may.  Try using NULLIF to help get the proper data.

NULLIF(AT_Active, 'False') <> 'True'

So if the value is...

I dont' know if this will help or not, but 01/01/1900 is what you get when you cast '' as a datetime.  You get 01/10/1899 when you subtract 365 from...

I agree about the RS bit.  Also how many apps out there already consume way more memory than they really need to.  I could see some companies deciding that they...