quote:

---

Originally posted by webfred



into bad_data

---

No, you're never too old to Yak'n'Roll if you're too young to die.

---

quote:

---

Originally posted by Idera

quote:

---

Originally posted by webfred



into bad_data

---

No, you're never too old to Yak'n'Roll if you're too young to die.

---

Why that name?


Limitations live only in our minds. But if we use our imaginations, our possibilities become limitless.

PBUH

---

quote:

---

Originally posted by velliraj

Hi

As per the below scenario i have to insert the data into a table

select empid,empname,dob,phone from employee
where
isnumeric(empid) = 0
or
empname is null
or
empname = ''
or
dob is null
or
isnumeric(phone) = 0

empid empname dob Phone
3 1900-01-01 00:00:00.000 2
4 NULL 1900-01-01 00:00:00.000 NULL

values having the empty spaces and null should be inserted into a table in the below manner

empid values columnname
3 empname
4 Null empname
4 Null Phone

please help how to insert

---

;with cte_bad_data  (empid,empname,dob,phone)
AS
(
select empid,empname,dob,phone from employee
where
isnumeric(empid) = 0 or isnumeric(phone) = 0 or coalesce(empname,'') = '' or dob is null
) 

select empid, empname as [value], 'empname' as [columnname]
from cte_bad_data
union all
select empid,dob,'dob'
from cte_bad_data
union all
select empid,phone,'phone'
from cte_bad_data