using conditional split how to load from source to destination table where the condition is null or blank to a particular column

Question

using conditional split how to load from source to destination table where the condition is null or blank to a particular column

jyothi_siri2000

SSC Enthusiast

Points: 111
More actions
January 27, 2011 at 4:18 am

#233416

using conditional split how to load from source to destination table where the condition is null or blank to a particular column

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 1

jyothi_siri2000 (1/27/2011)
using conditional split how to load from source to destination table where the condition is null or blank to a particular column

Use 2 conditions:

one that checks if the column is null.

One that checks if the column has zero string length.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Red8Rain Hall of Fame Points: 3312 More actions · Answer 2

where col1 is null

and col2 = ""

-----------------------------
www.cbtr.net
.: SQL Backup Admin Tool[/url] :.

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 3

Oberion (1/27/2011)
where col1 is null
and col2 = ""

The original requirement was to check for the same column, not two different columns.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

parthi-1705 SSCrazy Eights Points: 9277 More actions · Answer 4

jyothi_siri2000 (1/27/2011)
using conditional split how to load from source to destination table where the condition is null or blank to a particular column

Hi ,

Is this you are looking for

declare @Temp table (i int null)

insert into @temp values (1),(null),(''),(2)

Select * from @Temp where (i is null or i='')

Thanks

Parthi

Thanks
Parthi