Often simply formatting a query nicely is sufficient to be able to figure out what's going on. The Simple Talk prettifier will get you most of the way there. I've...

SELECT mu.Id, mu.name, mu.Code,

Count(mu.Id) AS UnitCount

Into TN -- temporary table?

FROM Ref.MilitaryUnit mu

LEFT JOIN Person.DMDC dmdc ON mu.Id = dmdc.Id

LEFT JOIN Person.Military mp ON mu.Id = mp.UnitId

Group By mu.Id,...

Luis Cazares (8/1/2016)

---

Maybe like this? Why do you have different validations for names and other values?

UPDATE [MEMBER].[IMP_MEMBER_INT]

SET

[ContactLastName] = CASE WHEN...

Sean Lange (7/29/2016)

---

ChrisM@Work (7/29/2016)

---

It's Friday, you can get anything you like...

It's Friday, you can get anything you like 🙂

Reported as spam

The select...

The answer to your question is "there are no qualifying rows in t1 to update". You're mistaking NULL as a placeholder for NULL as a value.

bhushanbagul (7/28/2016)

---

tab1 contains only one column which is null in all records and tab2 also contains one column which is not null and having data. I want to update tab1.id...

BrainDonor (7/28/2016)

---

I would like to know why they even bother.

How many people out there are going to think "I could do with a new kitchen, where should I look? I...

JoNTSQLSrv (7/28/2016)

---

Thanks for your reply Sergiy, i meant...

Like this:

SELECT ReturnValue

FROM (

SELECT

ReturnValue = ISNULL(cast(replace(left(QueryValue,charindex('|',QueryValue)-1),'{','') as float)/1000,0),

rn = ROW_NUMBER() OVER (PARTITION BY SourceID, PcsAssmntDataID ORDER BY IdentifierID DESC)

FROM livefdb.dbo.PcsAssmntData_Queries

WHERE SourceID = 'BRO'

and QuerySetID = 1

and QueryNumberID = 1

and PcsAssmntDataID...

NineIron (7/27/2016)

---

Thanx but, in the meantime I came up with this solution..............................

alter function dbo.fnWeight(@VisitID varchar(100))

RETURNS float as

BEGIN

DECLARE @Return float

set @VisitID=@VisitID + '{A^VS.WEIGHT}'

select @Return=cast(replace(left(PADQ.QueryValue,charindex('|',PADQ.QueryValue)-1),'{','') as float)/1000

from livefdb.dbo.PcsAssmntData_Queries PADQ

inner join (selectSourceID,

PcsAssmntDataID,

max(IdentifierID) as...

You don't need the wildcard on the left-hand side of the variable because you're matching from the left. It's also not SARGable (cannot exploit seeks). Try this instead:

where PcsAssmntDataID LIKE...

How are the weeks defined?

Is the first day...