set nocount on
go
--function to convert multiple integers to a binary value
--each integer is assigned to a pre-designated position in
--the binary value
create function dbo.fnSetPolygon(@p1 int, @p2 int, @p3 int)
returns binary(12)
as
begin
	declare @polygon binary(12)

	select @polygon = convert(binary(12), 
		convert(varchar,convert(binary(4), @p1))
		+ convert(varchar,convert(binary(4), @p2))
		+ convert(varchar,convert(binary(4), @p3)))
	return @polygon
end

go
create table Polygons_t
	(polygonid int identity(1,1) primary key
	,Polygon binary(12))
go

--a view extracts the individual parts of the binary value
create view dbo.Polygons_v
as
	select	Polygonid
		,convert(int,substring(polygon,1,4)) p1
		,convert(int,substring(polygon,5,4)) p2
		,convert(int,substring(polygon,9,4)) p3
	from	Polygons_t
go


insert Polygons_t (polygon)
select dbo.fnSetPolygon(100,100,100) union all
select dbo.fnSetPolygon(200,200,200)

select * from Polygons_t
select * from Polygons_v

if object_id('dbo.fnSetPolygon') > 0
	drop function dbo.fnSetPolygon
go
if object_id('dbo.Polygons_v') > 0
	drop view dbo.Polygons_v
go
if object_id('dbo.Polygons_t') > 0
	drop table Polygons_t
go

quote:

---

Originally posted by X002548

OMG

There must be some slack time out in redmond...or is that redrum?



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

---

/* Store these polygons */
POLYGON(0 0, 100 0, 100 100, 0 100, 0 0)
POLYGON(25 25,33 33,55 55)

/* In a table like this */
POLYGONS
(
	PNBR INT
	,XCOORD INT
	,YCOORD INT
	,PRIMARY KEY(PNBR,XCOORD,YCOORD)
)

/* Like this */
PNBR	XCOORD	YCOORD
1	0	0
1	100	0
1	100	100
1	0	100
2	25	25
2	33	33
2	55	55

quote:

---

Originally posted by TG

I had assumed Ryan was Paul's mild mannered alter ego.

Be One with the Optimizer
TG

---

quote:

---

Originally posted by desi_nerd

Thanks for the help.
I have decided to use MySQL instead which has the inbuilt data types that i need.


---
Iam not real any more
Iam just an Illusion
---

---

quote:

---

Originally posted by ryanston

quote:

---

Originally posted by TG

I had assumed Ryan was Paul's mild mannered alter ego.

Be One with the Optimizer
TG

---

Yeah, Paul is my manager. Now that he's a big-time dev lead, he doesn't have a lot of time for DBCC, so I took it over from him. I'm not sure mild-mannered is exacly an apropo description, but I guess in comparison to Paul...

----------------------
Ryan Stonecipher
Developer, Microsoft SQL Server Storage Engine, DBCC
(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)

---

quote:

---

Originally posted by ryanston

quote:

---

Originally posted by TG

I had assumed Ryan was Paul's mild mannered alter ego.

Be One with the Optimizer
TG

---

Yeah, Paul is my manager. Now that he's a big-time dev lead, he doesn't have a lot of time for DBCC, so I took it over from him. I'm not sure mild-mannered is exacly an apropo description, but I guess in comparison to Paul...

----------------------
Ryan Stonecipher
Developer, Microsoft SQL Server Storage Engine, DBCC
(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)

---

quote:

---

Originally posted by X002548



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

---

quote:

---

uncharacteristically ego-centric so I stuck with the one I had.

---

quote:

---

Originally posted by robvolk

quote:

---

uncharacteristically ego-centric so I stuck with the one I had.

---

MSSQLGOD?

---

quote:

---

Originally posted by spirit1

meaning you're 6 feet 5 inches with hair all over your body??

Go with the flow & have fun! Else fight the flow

---