Is there a question here? And why do you need a loop for this?

Try this one. http://bit.ly/IsUkqa

http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspx

For details about posting ddl and sample data see the first link in my signature.

I have to agree that I don't get the Excel element. It seems like it is adding an extra to an already overly complicated process that just isn't needed. If...

PLEASE stop posting these same questions over and over.

That error pretty much says it all. The link server is unable to authenticate. There are a lot of things that could be causing this. If this worked in the...

bitbucket-25253 (4/10/2012)

---

Here is a method, probably not the most efficient but it works for me

CREATE TABLE #C(Num INT,Nam VARCHAR(5))

INSERT INTO #c

SELECT COUNT(Cola),'Cola' FROM #Nepal WHERE UNICODE(Cola) > 127 UNION ALL

SELECT...

Building off the previously posted data.

create table #Nepal ( cola nvarchar(10),colb nvarchar(10), colc nchar(10), cold nvarchar(10))

insert into #Nepal

select N'????',N'AAA',N'ZZZ',N'PPP' union all

select N'???????',N'AAA',N'?????',N'PPP' union all

select N'TTT',N'BBB',N'DDD',N'????????'

select *

from #Nepal

I think something...

Of course I have no issue with asking basic questions.

I just tend to get annoyed at the same question over and over. Each time people all saying the same...

Murphy'sLaw (4/10/2012)

---

Sean Lange (4/10/2012)

---

Seems that the bigger question is what are hoping to do with this information? I have a feeling that you want to see if the data right...

Lynn Pettis (4/10/2012)

---

Sean Lange (4/10/2012)

---

Please stop posting the same questions over and over. These are all very basic questions and they continue to have the appearance of either homework or...

Please stop posting the same questions over and over. These are all very basic questions and they continue to have the appearance of either homework or interview questions.

Just need to add another case statement to make it work...not that this would be the preferred way given so many other solutions though.

create table #Address

(

id int,

addr1 varchar(25),

addr2 varchar(25),

addr3 varchar(25)

)

insert...

Yes Mike you are correct. The version that ColdCoffee posted just after mine is almost the same thing as the one I posted. It has the same issue too.

DECLARE @Example

TABLE...

And yet another way to skin this cat...

create table #Address

(

id int,

addr1 varchar(25),

addr2 varchar(25),

addr3 varchar(25)

)

insert #Address

select 1, '123', NULL, 'Main St.'

union all select 2, NULL, NULL, NULL

union all select 3, NULL,...