Hi All, I am very new to SQL, and for all my reading I can't find an answer to my query scenario. The context is a database of locations on images, where each...
3684
koilavijay
Aug 5, 2008 3:04 am
example code for all the joins available in sql?...
3685
Arnie Rowland
arnie1568
Aug 5, 2008 3:11 am
I would try something like: SELECT ImgFileName, XPos, YPos FROM YourTable WHERE abs( XPos - YPos ) <= @d_Param Depending upon the data structure and volume, a...
3686
Arnie Rowland
arnie1568
Aug 5, 2008 3:11 am
Try SQL Server Books Online. Regards, Arnie Rowland, MVP (SQL Server) "I am a great believer in luck, and I find that the harder I work, the more I have of...
3687
Bob Filipiak
bobfilipiak
Aug 5, 2008 10:50 am
Is this correct: Image Xpos Ypos pic1 2 4 pic2 2 3 pic1 3 2 pic1 5 4 You want to get all of the pic1 rows and...
3688
John Warner
john@...
Aug 5, 2008 11:45 am
The irony is doesn't SQL 2008 have a data type to solve this problem? John Warner ... rows ... more I have ... intended solely ... email. Any ... and ... ...
3689
darrylgreig
Aug 5, 2008 1:11 pm
Thanks for all your suggestions - actually got a very good suggestion from another quarter, for those that are interested: SELECT a.imgFname, a.centreX AS...
3690
Arnie Rowland
arnie1568
Aug 5, 2008 2:32 pm
Yep. (SQL Server 2008, that is...) Regards, Arnie Rowland, MVP (SQL Server) "I am a great believer in luck, and I find that the harder I work, the more I have...
3691
Noman Aftab
noman17pk
Aug 19, 2008 3:12 pm
Dear All,  I have the following data:  <CASH_ACCOUNT_NUMBER> USD00001 USD00002 USD00005 AER00003 AER00004 GBP00002  What I want is, if I give USD as an...
3692
Arnie Rowland
arnie1568
Aug 19, 2008 4:37 pm
There are several performance reasons why trying to 'backfill' a sequence is problematic. Usually, it is not a good idea to attempt to do what you desire....
3693
Noman Aftab
noman17pk
Aug 20, 2008 4:56 am
Thanks Arnie, I only expect a few hundred records...say 500  Noman Aftab Software Engineer ... From: Arnie Rowland <arnie@...> Subject: RE:...
3694
nikunjbhatt84@...
xyz912525402516
Aug 25, 2008 7:58 pm
suppose i have the following database tables in ms access (course, batch and student) data of course table: cnum? cname 1???? vb 2???? java 3????...
3695
scottfisheruk
Aug 26, 2008 2:22 pm
I have a table with the following structure: PersonID ProjectID 1 12 1 15 2 12 3 12 3 15 I need to do a...
3696
John Warner
john@...
Aug 26, 2008 2:34 pm
This might require a bit of non-standard/ANSI SQL, what DBMS are we talking about? John Warner...
3697
Arnie Rowland
arnie1568
Aug 26, 2008 3:35 pm
If you are using SQL Server, I suggest that this resource will guide to you understanding and using the PIVOT command. How to PIVOT Data Using T-SQL ...
3698
Scott Fisher
scottfisheruk
Aug 26, 2008 4:40 pm
SQL Server 2000 Thanks From: SQLQueriesNoCode@yahoogroups.com [mailto:SQLQueriesNoCode@yahoogroups.com] On Behalf Of John Warner Sent: 26 August 2008 15:35 To:...
3699
fireplace_tea
Aug 26, 2008 9:53 pm
Hi Everyone, I have 12 years of IT support and am currently doing software testing. I have started to learn SQL using MySQL 5.0, have downloaded the free ...
3700
John Warner
john@...
Aug 26, 2008 10:37 pm
SQL Server certification would be a good step/idea. Amazon or your local Barnes and Noble would likely have a study guide. I suspect the Oracle crowd gets paid...
3701
Arindam
e_arindam
Aug 27, 2008 10:31 am
Hi All, How can i see the detail status report of my SQL server ? .. i mean how many userlogged in ..how many trnsaction going on etc. Â Thanks in advance for...
3702
Arindam
e_arindam
Aug 27, 2008 12:12 pm
Hi All, How can i see the detail status report of my SQL server ? .. i mean how many userlogged in ..how many trnsaction going on etc. Â Thanks in advance for...
3703
PRAKASH
sweet_home321
Aug 27, 2008 1:16 pm
Friends kindly help me, I have installed SQL Sever 2000 and restored my databases While i am executing the below procedure in Master Database the following ...
3704
vigoudhaya
Aug 27, 2008 2:41 pm
using sp_who2...
3705
peternilsson42
Sep 3, 2008 5:29 am
... with Person_Projects as ( select 1 PersonID, 12 ProjectID from dual union all select 1 PersonID, 15 ProjectID from dual union all select 2 PersonID, 12...
3706
peternilsson42
Sep 3, 2008 6:05 am
... Recent versions of Oracle allow... with cash_accts as ( select 'USD00001' acct_no from dual union all select 'USD00002' acct_no from dual union all select...
3707
aks_0910
Sep 3, 2008 7:26 am
Hi... Can anyone tell me how to find age between two dates? soppose 1st date is 02-apr-90 and 2nd date is sysdate...then how to find age between sysdate and...
3708
John Warner
john@...
Sep 3, 2008 12:26 pm
DateDiff(yy, '04/02/1990', getdate()) http://doc.ddart.net/mssql/sql70/da-db_6.htm John Warner...
3709
Stephen Russell
lotmate
Sep 3, 2008 5:22 pm
Looks like homework time again. Look up datedif() _________________________________...
3710
Arnie Rowland
arnie1568
Sep 3, 2008 5:30 pm
Or even DATEDIFF()... ;) Yes, it is about the end of summer term... But really, didn't you learn in college that 'only when everything else fails, look in the...
3711
John Warner
john@...
Sep 3, 2008 5:58 pm
Fall term at all the colleges 'round herah. This looks like a SQL Server II early in the term question. First quiz is coming up. John Warner ... fails, look ...
3712
pulverizers73
Sep 3, 2008 8:40 pm
Does anyone know a quick and dirty way to calculate a PERCENTAGE value within a range of two columns. For example. Value 2800 25% percentile 1400 50%...
