GSquared (2/6/2009)

---

Iay amay uenflay inay igpay atlinay. And speak/write attrocious Spanish. My French is worse than my Spanish. My English is abysmal, but I speak extremely fluent...

What have you tried so far?

Please post table structures and sample data. You may find it helpful to read the article in the link below.

Please read the link below. People will be...

What have you tried so far?

Please read the link below, it will show you how to create sample data.

KSB (2/5/2009)

---

ChrisM,

Here is my code.

SELECT DISTINCT prof_sec.profile_skeyAS profile_skey,

acct_sec.account_skey

INTOdbo.profile_assoc_security

FROMdim_account_secureacct_sec, dim_profile_secureprof_sec

--INNER JOINdim_profile_secureprof_sec

--ONacct_sec.account_key > 0

--ANDprof_sec.profile_key > 0

INNER JOIN #TempAssociateObjectstemp_assoc_obj

ONtemp_assoc_obj.assoc_object_skey = prof_sec.profile_skey

WHERE EXISTS (SELECT 'X' FROM project_securityproj_security

WHERE proj_security.account_skey = acct_sec.account_skey

ANDtemp_assoc_obj.object_skey= proj_security.project_skey

)

AND NOT EXISTS...

Thanks for the feedback eddy. Please be advised that this type of construction can cause performance problems if the cached plan is a poor match for the parameters received when...

SELECT * FROM [BASISREL] AS b

WHERE PAR_ID_FIRMA = @FirmaId

AND [PAR_ID_TYPE] = CASE WHEN @var < 20 THEN @var ELSE [PAR_ID_TYPE] END

Thanks for the feedback Suresh. Participants in this thread, including myself, would be interested to see exactly how you implemented the changes which solved your problem - can you post...

Without seeing the code you are using now and the code you were using...

Suresh, your statement is syntactically correct but almost certainly won't give the results you are expecting.

This...FROM dim_account_secure acct_sec

INNER JOIN dim_profile_secure prof_sec

ON acct_sec.account_key > 0

AND prof_sec.profile_key > 0

isn't an INNER...

Hi

Put it in brackets, like this:

AND NOT (Server = 'SQL005' and Drive = 'G')

Cheers

ChrisM

Top work Trinny, I was just about to post this one in.

Chuck, run a search (on this forum) on parameter sniffing. If this is the problem, which seems likely, then the solution can be pretty straightforward.

Cheers

ChrisM

Lowell (2/3/2009)

---

Noted a strong theme among the high posters that everyones shifted to a Star Wars Avatar...

It even affects How people post, what with the Yoda grammer.

i broke down and...

Commendable philosophy, David. Not only that, it's now beertime! 😀