Viewing 15 posts - 16,471 through 16,485 (of 18,926 total)
I think you'll have to find someone with strong maths skills to help you on this one. This one is not really about t-sql skills...
Could they accept a system...
June 21, 2005 at 9:16 am
I hope that the interviewer understands these questions, cause there are far more good answers than the ones posted. He might have to resort to : he seems to...
June 21, 2005 at 9:09 am
You can still use this function and specify the rank (where Elementid = 5). Then you can keep the original split function and use it for other tasks.
June 21, 2005 at 9:04 am
Still too complex. As a few members here have said, when the query is too complex, stop cursing at the query and change the form behing it. Simplicity...
June 21, 2005 at 9:02 am
I have 0 advanced maths formation... I'll let you handle this one
.
Btw, my number of combinaison was only for different combinaisons of...
June 21, 2005 at 8:58 am
Is the table permanent or temps?? Have you tried using the other version?
June 21, 2005 at 8:56 am
Hey govinn, even with only 20 numbers, you have
2 432 902 008 176 640 000
different possible combinaisons of numbers.
That's 2.4 billions million combinaisons. Do you really want...
June 21, 2005 at 8:49 am
Hehe. I've read a article with something like this a few days ago... was about a Whoops incident. Can't recall the circumstances
June 21, 2005 at 8:26 am
If it was for a prefix number of values, it could be done. but if the logic is find any match, with any qty of numbers, then I don't...
June 21, 2005 at 8:24 am
What fields need to be updatable in the form?
June 21, 2005 at 8:19 am
Just run my query and compare to yours... I'm just specualting on your needs. You know what you need more than me.
June 21, 2005 at 7:58 am
Please do not cross-post. I already answered that question here :
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=65&messageid=192379
June 21, 2005 at 7:52 am
Isnull is built-in. You can also lookup COALESCE.
June 21, 2005 at 7:44 am
Viewing 15 posts - 16,471 through 16,485 (of 18,926 total)