Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
haydn
Starting Member
5 Posts |
 Posted - 2007-09-04 : 03:42:14
|
| Hi,I have a table in my database that consists of sets of 6 lottery game numbers. I would like to know how to write a script that will compare the winning numbers from an actual lottery draw with the numbers stored in the table, so that I can return a result of my lottery draw winners. The numbers in my table are stored as a String i.e (02,08,12,32,36,40). Each row in the table holds a set of 6 numbers that are relative to a particular lottery draw.If there is anyone in this forum who is willing to assist me here I would be mucha appreciative.Haydn. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-09-04 : 03:44:29
|
Where do you store the "winning" numbers?Where (and how) do you store the numbers drawn by the public?Please post full DDL for both tables.And moderator, please move this post to either 2000 or 2005 forum depending in which DBMS OP is using.
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-09-04 : 04:57:43
|
| moved. assumed it's SQL Server 2005._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
|
|
|
Lottery Number Checker