Filter a list

0

Please login or register to vote for this query.

(click on this box to dismiss)

Ukrainian Language

Q&A for linguists, teachers and students of the Ukrainian language

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
)

declare @pets_ref 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')

insert into @pets_ref values
('82647C10-CFB9-47BF-9719-B38ADBE9C7F1','10408','    B','Frankie','Mix Husky')

select * from @pets
select * from @pets_ref

Enter Parameters

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