Deepak, let me tell u this, this was one of the longest ask i had worked on :-D, not cos' of the code, but for importing data into my machine!

Here...

To learn more about the CASE syntax, please go through the following BOL link, especially the Examples part of it

CASE (Transact-SQL)

😎

NewBee, replace all of your ELSE IF to WHEN.. That syntax u used is not supported..

Hope this helps you!

Deepak, the excel was a good one.. but we need DDLs to work on man.. creating 35 column table, some 100 rows and then working on the request will take...

I guess the column data-type for the column u are tryin to replace is NVarchar.. Can you please show us the REPLACE statement u tried?

And as our Jeff said, please go through the article in the first link of his signature line! 🙂

Hi there, i am slowly understading your requirement.. got a doubt here, will there be only 3 entries per person per day?

Nitesh, here is a function that i coded for your requirement. I have used WHILE loop which is RBAR practice. There are lot of set-based code for this, which i...

Another variant of the code. This will also perform the same

;WITH Master_CTE AS

(

SELECT

Emp.EmpID, Emp.EmpName, Emp.Salary ,dep.DeptName

FROM

[Empmaster] EMP

LEFT JOIN [EmpMapping] Map

ON Emp.EmpId = Map.EmpId

LEFT...

malleswarareddy_m (5/17/2010)

---

I thought that want to put insert scripts but the table is available.that's why i copy & pasted.sorry for wasting your time.next time i will put complete script...

Please revisit the code i had given, i have...

You have provided the DDLs, alright, but what about the INSERT INTO scirpts for the sample data! It took me about 15 mins to format the data u had given...

Malli, this will get you there

;WITH CTE AS

(

SELECT Map.EMpId, Dep.deptName

FROM [EmpMapping] Map

LEFT JOIN [DeptMaster] dep

ON Map.DeptId = dep.DeptId

),

Concat_Data AS

(

SELECT dep1.empid, ...

Nitesh, another question, does your pattern always start and end with underscore ( _ ) ?

If '_x0020_' and '_x002f_' are going to be the only patterns that need to be replaced, then this following code with do the trick for you!

First, check out how i...