Mike Levan (3/9/2009)

---

from select @@version

Microsoft SQL Server 2005 - 9.00.1399.06 (X64)

Oct 14 2005 00:35:21 Copyright (c) 1988-2005 Microsoft Corporation

Enterprise Edition (64-bit) on Windows...

After a couple of minor changes to your code:

CREATE PROCEDURE sp_TransferData_Compare

(

@StartDate varchar(10),

@EndDate varchar(10)

)

AS

BEGIN

...

DavidB (3/9/2009)

---

I...

Is the actual code being run inside a stored procedure? If so you are probably suffering from parameter sniffing. Please post the code for the stored procedure.

Okay, I just went sarcastic in this thread.

I'm sorry, would you like me to come to your office and do it for you?

Yes, there can be issues when you apply the service pack, yes, you might have...

I am not an employer. I dislike like Unions because the promote mediocracy. They are more concerned about the number of Union members, not the membership itself. ...

Yes

Would you care to elaborate on this? You did ask for...

And, of course, when doing this you will...

And Gail, its easy to see why you leave Mike to others to answer. I mean, really.

NO. It means you haven't had any service packs or updates applied to your current installation of SQL Server 2005.

I suggest that you look into getting your system updated.

Try this:

(DT_STR,10,1252)[LIC-NO] + "," + (DT_STR,10,1252)[SSN]

And yes, those are double quotes not two single quotes on either side of the comma.

angel41_23 (3/9/2009)

---

hi..........

i have LIC-NO and SSN fields for all the customers in the database 1 and i have to send them to database2...

And you know why? You are one of the top 3 people on SSC, so they figure if anyone knows the answer you are sure to be the one...