Topics
Started by
Posts
Last post
In the testscores table, i am first looking for people with a test_type of 'lsatot' IF, they dont h…
2 replies
Hi All: I'm trying to zero out quanties on order in Inventory for a certain vendor. My first SQL i…
3 replies
I have an account and contact table. An account may have 1 or more contacts. How do I identify acc…
4 replies
I want to know how I can run a trigger that will activate another store and at the same time send p…
4 replies
Example: -- drop table tbl_test create table tbl_test ( order_name char(30) not null, constraint …
5 replies
I have question about TRIGGERS. I have (4 example) VEHICLE_TABLE with VEHICLE_TYPE column and CAR_T…
1 replies
Hi Everyone, I need some help from a SQL guru! I have a table that consists of 10,000's of records.…
2 replies
I have a requirement where for a given student I need to generate a comma separated field of the co…
11 replies
Hi Guys, Im pretty new to SQL and I need to perform a task where I have to replace the leading 0 w…
3 replies
I am finding difficult to translate the below query to replace *= with LEFT OUTER JOIN Syntax. Idea…
1 replies
I need to find a students final grade from the transcriptdetail table, and i need it formatted usin…
20 replies
Hi there, I'm trying to force some output from a query to come out how I want and not being overly …
7 replies
Hi Guys, I have a table with the following structure and data: ID ParentID 1 0 2 0 3 0 4 …
1 replies
I want to do this: SELECT Num = 1, Name FROM Employees : : where Num…
2 replies
I am getting stuck here, and am not sure how to finish this. Basically i just need to find everyone…
1 replies
Viewing 15 topics - 3,316 through 3,330 (of 17,082 total)
You must be logged in to create new topics.