In this manner, but only for those tables who has column of varchar types.....

Good explanation Kingston 🙂

Good question....

Thanks twin 🙂

You can also put the COLLATE to the column names where you are getting collation error like this:

Column1 Collate collationname = Column2 Collate collationname

Can you please post what you tried?

Also, post the sample data and what would be your desired output from that

If you are not making mistakes, you are not learning anything new 😛

masoudk1990 (8/5/2013)

---

Thank you very much but 'N' character in condition is critical because i search none English.

I need something like:

DECLARE @name VARCHAR(20) = '?????'

SELECT * FROM Person.Person WHERE LastName LIKE...

Try in this manner-

DECLARE @name VARCHAR(20) = 'S'

SELECT * FROM Person.Person WHERE LastName LIKE '%'+@name+'%'

I have solved myself_

Changed the query to this--

DECLARE @projectId int

SELECT @projectId = ProjectId FROm Project with(nolocK) WHERE ProjectNo = '61N24643'

SET IDENTITY_INSERT DC1..DMAuditHistory ON

INSERT INTO DC1..DMAuditHistory (ProjectID,ProposalID,SolutionID,RequestID,AuditFieldTypeID,SrNo,Dateaudited,

AuditFieldvalue,DrawingStatus,CommerceId,DeleteFlag,AddedBy,DateAdded,ChangedBy,dateChanged,GlobalUniqueID)

SELECT * FROM DMAuditHistory...

Actually I didnt see the outer query and was just focused on correcting Case statement...

I read query and see that case can return multiple values and this can lead to...

🙁

Thanks Chris for correcting........

Teee: I apologize you for not providing the proper solution!!

Welcome :hehe:

+1

First have to BOl about it before answering 😛

Teee (8/2/2013)

---

Select

jc.intJobCardId

,b.vchBarcodeas [Barcode]

,i.dteIncidentDateas [IncidentDate]

,ISNULL(ISNULL(p.nvcDisplayName, p2.nvcDisplayName), '')as [ServiceProvider]

,dteAssignedDateas [AssignedDate]

,dteCompletedDateas [CompletedDate]

,DATEDIFF(Hour, dteAssignedDate,dteCompletedDate) as [TimeToComplete]

,ISNULL(lb.TotalHours, 0)as [TotalHours]

,lb.TotalHours/DATEDIFF(Hour, dteAssignedDate,dteCompletedDate)as [Efficiency]

,''as [Productivity]

,l.vchLocation

,typ.vchType

From dtlIncident i

Inner Join dtlJobCard jc on...

what I understand with ur prob is that you can write CAsE statement in this manner-

SELECT

Case when 1=1 THEN 'Yes' ELSE 'No' END

WHERE 1 IS NOT NULL