just a suggestion, but in the past i've used port 14330 (1433 x 10)

and also on my current dev machine, that has every version as an instance,

they use ports...

ugh; sounds more like a "Create a Blame-Thrower Tracking Device" to me;

I'd try to turn this into a list of the proactive things you've put into place to avoid disasters...

no;when you install MySQL, both providers(32 bit and 64 bit) are installed. there's...

jbulldog (4/15/2013)

---

Thanks Lowell for the quick reply. But when I altered the code as you presented it the query returned nothing. I would be satisfied if that were the case...

you are pretty consistently ignoring the possibility that values might be null.

You've got to bulletproof your code to consider datatypes (converting int to varchar, for example), where the data...

Sean's been very helpful here as well; when you ask strangers for help, you've got to put some effort and thought into it yourself. YOU are the one who has...

your sample data really needs to INSERT into your table you posted; all we will really have is whatever you post here; if we cannot simply run it in...

your outer query has Two WHERe statmeents; the second one should be an AND, i think:

SELECT

dbo.ACCOUNT.PORTFOLIO

FROM dbo.ACCOUNT

INNER JOIN dbo.SERVICE_JOIN

...

your question needs the same solution you can see in this link from a couple of days ago:

if you post DDL and sample data the way you see in that...

this thread on SSC is what i have saved, and has been working for me:

http://www.sqlservercentral.com/Forums/Topic340912-146-1.aspx

the example i provided actually works; so you will have to provide the specific details of whatever you did.

a user does nto have any more rights...

you must use CAST...

you'll have to make a user for each Windows group or specific login, the rest is the same you would do in any other database: create a role with only...

good god that is like the 200th post where we proposed the same solution with only minor differences between our code example!

you usually beat me to the punch anyway!

inside the trigger, you can capture the first 4000 chars of the command text:

inside a trigger, you can do this, (DBCC INPUTUFFER can be used by users agasint their own...