glad I could help a little bit; post your scalar function here if you need help converting it to an ILTV;

yes and no;

javascript in and of itself can't do it alone; it requires a postback to the server;

so you need to either use a form post (submitting the whole aspx...

Dan's right where whenever GUID's are generated with a newId() function, they are unique, but if the business process was using them for FK equivilents, you can find out easy...

a clustered index does not have to be unique. it just stores the data in the order of the index for the fastest retrieval of the data.

you are confusing a...

management expects you to use your professional expertise...

don't you have to set both the connection timeout and your command object's command timeout?

this works fo rme for example, waitng 45 seconds to make sure it lasts longer thna...

heck i'm throwing all sorts of numbers out there; i think i made my numbers extra huge to kick up some dirt so people would say "no! that's too much"

ok...

I think you are supposed to use SUSER_SNAME() in most situations.

i believe the difference is SUSER_SNAME() would return a domain\username for those people who are not explicitly on...

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...