This produces the result set required.

create table #quotedetail (QuoteNum int, Brand varchar(10))

INSERT INTO #quotedetail values

(10047,'NISSAN'),

(10048,'TOYOTA'),

(10049,'TOYOTA'),

(10050,'BOBCAT'),

(10050,'JOHN DEERE'),

(10050,'KAWASAKI'),

(10050,'MANITOU'),

(10050,'POLARIS'),

(10050,'SKYLARK'),

(10051,'DOOSAN'),

(10051,'MITSUBISHI')

select * from #quotedetail

Select distinct QD2.QuoteNum,

substring(

...

Can you post screenshots of your TCP/IP configuration

The transfer logins task can copy the logins and SIDs, but not the passwords. It copies the logins with a random password and it also disables the login.

The best...

Not a problem

Your probably best getting in touch with Microsoft directly, I can't find no reference on the datazen website in relation to licensing.

Are they all in the same filegroup or different filegroups?

If different might be done for piecemeal restores.

Base

How are you changing the service accounts? Services.msc or SQL Server Configuration Manager?

My 2 cents

declare @stemp varchar(50) = 'fl,ca'

create table #csvtest (name varchar(5), states varchar(10))

INSERT #csvtest(Name, States) Values('Joe','CA,FL,HI')

INSERT #csvtest(Name, States) Values('Mark','FL,MI')

INSERT #csvtest(Name, States) Values('Greg','MI,AR,AL')

INSERT #csvtest(Name, States) Values('Mary','AL')

INSERT #csvtest(Name, States) Values('Frank','AL,AR,WI')

select * from...

Or you could try this aswell

http://www.sqlservercentral.com/scripts/T-SQL/69207/

Care to post the solution for others who may have the same issue?

To get Nexus to import trace file on my system I have to disable event requirement checks

johnwalker10 (11/2/2015)

Fix the statement to read like this:

ALTER...

Is this what you need?

create table #customer

(id int, name varchar(10))

create table #logs

(custid int, checked datetime)

insert into #customer values

(1,'cust1'),

(2,'cust2'),

(3,'cust3')

insert into #logs values

(1,'2015-11-01'),

(2,'2015-10-01'),

(3,'2015-01-01')

select

*

from

#customer c

left join

#logs l

on

c.id = l.custid and l.checked <=...

Sounds vaguely like a catch all query, where parameters can be null and not all need to be specified to execute the stored proc

Maybe Gail's article will help http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/