Simplifying a Filter Query

0

Please login or register to vote for this query.

(click on this box to dismiss)

Ask Different

Q&A for power users of Apple hardware and software

declare @pets TABLE(
	[cvtGUID] [uniqueidentifier] NOT NULL,
	[ClientAccountNum] [varchar](11) NOT NULL,
	[PetAccountNum] [char](5) NOT NULL,
	[Name] [varchar](50) NOT NULL,
	[Breed] [varchar](30) NOT NULL
)

insert into @pets values
('DB04CA28-CBE2-42B1-9502-FD9A583EC28E','10408','    B','Frankie','Mix Husky'),
('009B5945-8AEC-45F0-A451-AE7B40665F9D','10408','    C','Frankie','German Shepherd')

select * from @pets

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results