skilly2 (6/27/2014)

---

Thanks for the compliment on the sample and explanation... However, I still didn't explain it 100% correctly :-). The query you gave is exactly what I asked for,...

Thank you for the nice sample and well formed question!

You are slightly over-complicating the query, check the parenthesis in the where clause.

😎

SELECT

AR.InternalAuditRequirementID

,AR.AuditTeamID

FROM tblInternalAuditRequirement AR

LEFT OUTER JOIN tblInternalAuditAssignment AA

ON AR.InternalAuditRequirementID...

Evil Kraig F (6/26/2014)

---

The crystal ball is malfunctioning. Sorry, I'm sending it back to the shop. The next person who wants to try using it is welcome to...

My 2 cents on this, GUI generated code is not always forward compatible, I.e. the semicolon termination is missing.

😎

TomThomson (6/24/2014)

---

Luis Cazares (6/24/2014)

---

On a completely different subject, I'm taking 20467BC course this week and found some surprises like using while loops to create sample data, recommendations to use...

Quick question, why the nolock hint?

😎

Doctor Who 2 (6/21/2014)

---

I've got SQL Server 2008 R2 Developer Edition on my desktop. I'm trying to upgrade it to SQL Server 2014 Developer Edition. I've run the Update Advisor...

geo123abram (6/21/2014)

---

I have multiple parameters for a sp, where I am executing a dynamic sql statement using sp_executesql. Now the parameter definitions can be dynamically set. However, all the parameters...

Sachin Nandanwar (6/22/2014)

---

Eirikur Eiriksson (6/21/2014)

---

Those would...

Don't think there is a need for a cursor

😎

UPDATE E

SET E.ActiveRoles = dbo.udf_GetRoles(P.pkPerson)

FROM dbo.tEmployee E

INNER JOIN P

ON E.pkPerson = P.pkPerson;

The correct cursor code

DECLARE @pkPerson...

Those would then certainly be valid...

deepu chan (6/21/2014)

---

i have a table like below

create table #temp

(

valid_id int not null,

valid_no varchar(50)

)

10001

20002

30011

40012

i need to select the valid no without '0' lie 1,2,11,12, how do i?

someone please clarify me...

sstomp (6/20/2014)

---

We are getting this error message when attempting to connect a linked server to an ODBC data source logged in with SQL authentication:

OLE DB provider "SQLNCLI10" for linked server...

Appreciate the effort! Thanks!

😎

Prefer...