sk.panda (2/11/2010)

---

Dear Sir,

While executing procedure i want the output should display like

0000001005 1900-01-01 0010 SPLM 6800 ERR MSG 247387 //Desired output

But now i am getting output(wrong output)

0000001005 1988 0010 SPLM...

If you can't change it, you can do an explicit conversion e.g.

SET NOTES1 = CONVERT(VARCHAR(50),NOTES2)

What is the problem you're still having with the modified code?

Do NOTES1 and NOTES2 have the same datatype definition and length?

Please check BOL (update statement) and Google before posting your question.

Try this

UPDATE t

SET NOTES2 = s.NOTES1

FROM TABLE2 t

JOIN TABLE1...

The reason why you go from 121 to 8129 is called the multiplication effect and is indeed caused by joining the inventory table with the order(details) table. If you have...

Ok - let's see if this helps.

Create a staging table (similar to your final table).

Load it with the flat file using a data flow task.

Use an Execute SQL Task to...

Where and when do you get the error? Can you post your package or some screenshots?

To make the package successful, raise the MaximumErrorCount property at the package level.

You may also...

I'm a bit confused as you use SQL 2005 and DTS in one sentence. Hope you mean SSIS?

Personally I would solve it as Jeff describes, but if creating the staging...

Paarthasarathy,...

Jeff Moden (2/10/2010)

---

Nabha (2/10/2010)

---

That would give the records even if the employee is not active now.

...

There's probably many ways to solve this, but a straightfoward one is to put the line breaks in the ISNULL like this:

select isnull(@a,'')+ char(13) + isnull(@b+ char(13),'') + isnull(@c,'') +char(13)+...

I can't reproduce your error unless I execute the statements one by one. Do you execute all three of them as a single batch? By this I mean either select...

dateadd in BOL

and a great post about dates in T-SQL

Just for the sake of completeness, here are two more alternatives:

- Create a view that combines the master and detail table into 1 and use an instead of insert trigger....