Search results for query: *

I have the problem: "List all details about software records. Sort the output by package ID within tag number." I'm a little confused about what they mean "within tag number" Is the following sql right or wrong, if wrong can you help me fix it? Thanks. Select * from software order by PACKID...

Hey, Let's say we have two table both the fields "first name", "last name", and "address". Which of these fields intersect? I mean don't all three intersect since there common to both tables? Or is this some special property for two tables to intersect other then them having the same field...

As for I know this is a valid sql statement, but for some reason access gives me a syntax error. How can I fix it? Thanks. SELECT SUM(CASE WHEN City = 'Sandnes' THEN 1 ELSE 0 END) as FieldNeeded1 FROM Persons;

Why is this illegal and how can I fix it? Thanks. SELECT COUNT(*) AS NumberOfHistory FROM Enrolls WHERE COURSENUM = 405; SELECT COUNT(*) AS NumberOfScience FROM Enrolls WHERE COURSENUM = 605;

How can I do https(ssl3) in c# without using the mentalis control? Thanks!

what is wrong with the following code? WHERE Ratings.Rating = (Coffee.Rating AND Country in('Dominican Republic', 'Jamaica', 'Colombia', 'Venezuela', 'Mexico'); country is in a table called Coffee if that helps. Thanks for any help!

Ok lets say I have an area for STATE, AGE, and SALARY. And I want it to be like this: 1. state = new york 2. age = greater then 40 3. and salary greater then 20000 Do I need 3 actual if statements? or 3 ands? thanks for the help!

Hey Again, How would I go about doing this? Lets say I have data like this: 0000abcd123 0001efgh123 0002ijkl123 0003mnop123 And I want to lay it out like: Code Letters Numbers 0000 abcd 123 0001 efgh 123 0002 ijkl 123 0003 mnop 123 I know how...

Ok I'm trying to add the after advancing constant in the write command to double space my output. Here are all the write commands in the code: WRITE PRINT-LINE FROM OUT-REC AFTER 2 WRITE PRINT-LINE FROM HEADING1 AFTER TOP-PAGE. WRITE PRINT-LINE FROM HEADING2 AFTER 2. how do I add double...

Whats wrong with this? // JOB // EXEC ASMGCG //ASM.SYSIN DD * PRINT NOGEN PRINTOUT START STM 14,12,12(13) BALR 12,0 USING *,12 ST 13,SAVEAREA+4 LA 13,SAVEAREA OPEN (READER,INPUT,PRINTER,OUTPUT) CLEAR MVC...

What do i put in a critera that wants something that is more then 1000 but not more then 2000?

Hello, I am taking a course in college on COBOL. What we use is the hummingbird software to telnet into our account on the schools server. The server is using or prehaps emulating a IBM 360. So the book we are using is "COBOL for the 21st Century" Eleventh Edition. However I find the book to...

I'm taking a beginners assembly programming class. The book we are going to use is "Assembler Language Programming for IBM and IBM Compatible Computers [Formerly 370/360 Assembler Language Programming] (Formerly 370/360, Assembler Language Programming)" The link to it is...