Is this what u want

create table #tblResponses (Resp int, ProdName char(1), Value varchar(3))

insert into #tblResponses values (1, 'A', 'Yes')

insert into #tblResponses values (1, 'B', 'No')

insert into #tblResponses values (1, 'C',...

Are you saying

1 A Yes

1 B Yes

1 C Yes

produces

A 1

AB 1

AC 1

BC 1

and

1 A Yes

1 B Yes

1 C No

produces

A 1

AB 1

How about this for a wacky & crazy solution

create table #tblResponses (Resp int, ProdName char(1), Value varchar(3))

insert into #tblResponses values (1, 'A', 'Yes')

insert into #tblResponses values...

Can I ask some qualifying q's

How do you get 8 combinations from 3 products? If you want unique combinations then there are only 6

select a.ProdName,b.ProdName,c.ProdName

from prodx a

cross join prodx b

cross...

Since you are naming each server in turn then

INSERT INTO ##all_logins

SELECT name,'jupiter'

FROM jupiter.master.dbo.sysxlogins

WHERE name like '%Ivanov%'

INSERT INTO ##all_logins

SELECT name,'saturn'

FROM saturn.master.dbo.sysxlogins

WHERE name like '%Ivanov%'

Select into will always create a temp table.Try

CREATE TABLE

tempdb.##all_logins

([UserID] [int] IDENTITY (1, 1) NOT NULL ,

[UserName] [varchar] (100))

Then try to add records to it:

INSERT INTO ##all_logins

SELECT name

FROM jupiter.master.dbo.sysxlogins

WHERE...

Sorry, cockup on quotes (could'nt test)

DECLARE @search VARchar(3000)

DECLARE @scop VARchar(20)

DECLARE @sql nvarchar(1000)

set @scop='C:\'

set @search='ilan '

set @sql = 'SELECT TOP 10 *

FROM OPENQUERY(NTindex,

''SELECT DocTitle,create,path,filename, rank,VPath,Contents,characterization

FROM SCOPE ('''''+@scop+''''')

WHERE FREETEXT(Contents, ''''"'+@search+'"'''')'')'

exec sp_executesql...

Nice one Jay, did not think of that one. Probably make cleaner code as well.

Try this

DECLARE

@SearchField VARCHAR(100),

@A varchar(5),

@Temp VARCHAR(100),

@Output VARCHAR(100),

@counter INT

SET @SearchField = 'select1 select2 select3'

SET @Temp = @SearchField

Print @Temp

SET @Output = ''

SET @A = ''

WHILE (@Temp <> '')

BEGIN

SET @Counter = CHARINDEX(' ',@Temp+'...

The problem is you are sending the query with @scop and @search not the contents of the variables. You need to create the whole query (inc variable values) in a...

Why not user a join, it is faster and you do not need an top/order by in the subquery.

SELECT a.* FROM t_Retail a

FROM t_Retail a

INNER JOIN (SELECT Pcde6P

FROM t_Retail

WHERE LEN(RTRIM(Pcde6P))...

Don't really know if there is a best way. It depends on volume and type of data. You only gave example of 3 rows with one character data. The only...

In EM right click on the server (the one you are linking to) and select properties. Select the Connections tab, click on ANSI warnings and ANSI nulls (to put tick...

declare @c int,@sql nvarchar(1000),@table varchar(20)

set @table = 'tablename'

set @sql = 'select @c=count(*) from '+@table

exec sp_executesql @sql,N'@c int output',@c output

select @c

Have you tried setting them on the linked server for connections? (providing it does cause problems elsewhere!)