duplicate post. please don't post the same question multiple times, it makes it hard to follow and fragments replies.

users click Recent Posts>>Posts Added Today to see all recent activity.

follow the...

what details...

tomy1980 (4/12/2011)

---

Dear All,

I just want to take ur kind attention to one of our client's requirement which u can find below,

Machine Name = A

Default Instance Name .....They want it to...

pretty straightforward code; I'm still guessing that your table dbo.tblChangeRequestResources has multiple emails for the same person, so i'd suggest adding a DISTINCT clause to your procedure:

-- spu_CHS_SendEmail_AllResources '00003I','ENS -CR-2010-000102'

ALTER...

in your example, you are using a SCALAR function, which will degrade performance, especially with large data sets.

you could change that same function to be an inline table valued function,...

ok, because of the complexity, what you have to do is export the results to a global temp table, then BCP the the results;

Adding this to the very end of...

BCP supports changing the default field terminator (default is tab ) to anything else;

here's a simple example: see the delimiter in the dbl quotes after the -t command

EXECUTE master.dbo.xp_cmdshell 'bcp...

i believe the toAddress requires a semicolon delimited list of recipients, not a comma delimited one., so you'd need this for the variablbe, right?

[string] $toAddress="user1@abc.com;user2@abc.com"

and yet another option:

SELECT

DATABASEPROPERTYEX(db_name(),'Collation') AS Collation,

DATABASEPROPERTYEX(db_name(),'ComparisonStyle') ...

boy that MS document is really scarce on details and guidelines... "calculate it yourself based on details" is my take on it.

I can't say whether this is right or not,...

first: ALWAYS treat datetime as datetime . converting them to int, varchar or anything else just makes you have to re-convert them back again later, so your DateId should be...

can you pre-process the file by replacing Null with String.Empty? then you could continue using bulk insert

i think the issue is BULK INSERT cannot differentiate between a string between two commas and the keyword NULL;

I'm not sure how to tackle that, other than putting it...

ichiyo85 (4/11/2011)

---

Hi Lowell,

It is possible to have ID1=ID2. Would I be sure to know I am joining by ID1 fist, and if not ID2 with your code?

Thank you so much...

is it possible that Table1.ID1= Table2.ID2?, or that Table1.ID2= Table2.ID1?

wouldn't it be more correct to join with an OR?

select * from table1

left join table2

on (table1.ID1 = table2.ID1)

OR (table1.ID2...