select SUM(IsNull(s.Sales,0)) Sales,

s.[Type],

p.Period

from #Period p

LEFT OUTER JOIN #Sales...

I just tried it... you can't combine them.

Not sure what you're wanting.

Is the problem that the print statements (status messages) aren't coming back until the procedure is finished? If so, replace the print statements with the...

You're welcome

So, I guess the question is - which is the most efficient, and places the least stress...

Leave it to Jeff to find another way with less code.:rolleyes:

anjana.maganti (4/23/2009)

---

Hi Again,

i have made changes and deployed it to live server ad now i received a error like...

'A column insert or update conflicts with a...

It sounds like you have quite a few of these columns, so I'd have to concur that using a FK to a new table of those acceptable values would be...

something done on a different OS?

Windows uses CR+LF,

Mac uses one (CR?), Linux the other (LF?).

Try this (you'll need to change the hard-coded path to your text file to import):

-- the final results end up in this table variable

declare @Import TABLE (

ID int,

...

This would work IF all of the columns are used to create the uniqueness. Usually,...

That's the point. He turned his frustration into a positive. By pointing out an issue in a positive way, he has potentially opened the door for himself.

In the suggested reply,...

-- build a CTE of the rows that need to be added (not already in Table2)

;with CTE AS

(

select column1, column2 from Table1 -- use the columns that determine uniqueness

EXCEPT

select...

if exists (select 1 from DestinationTable where PKField(s) = value(s) from CSV)

insert into ErrorTable

else

insert into DestinationTable

I don't think so... I couldn't get a default or check constraint on the type. But, as shown, you can still implement those on the fields in your table.

I suggest you look at: http://msdn.microsoft.com/en-us/library/aa258277(SQL.80).aspx and http://msdn.microsoft.com/en-us/library/aa258242(SQL.80).aspx to get an idea of your specific storage requirements. Add up the storage requirements for all of the columns, and multiply by...