Firstly your relationship is incompete, what you are asking for is all DETAILS for bookId and all STAFF for a bookId and that is what you got. You need to clarify...

How about this

CREATE TABLE tblLocationGradeTeacher (Location2 int, Grade int, T_id int, TeacherID int)

INSERT INTO tblLocationGradeTeacher VALUES (371, 2, 1, 10371)

INSERT INTO tblLocationGradeTeacher VALUES (371, 2, 2, 121371)

INSERT...

All the update does is to set Z_Id to an incrementing number starting at 1 for each Booking. The order of the data is done by the INSERT statement, add columns to the ORDER...

aw shucks, Antares beat me to it, this is my explanation

SQL Server stores its dates in binary and the lowest value allowed is 0. Any time you use a number...

You will need to put a loop around the fetch, create and insert statements to do each row selected.

But why are you using a cursor, this should do the same

Create...

SELECT (CASE WHEN seq = 1

THEN CAST(job_id1 as varchar)

ELSE '' END) AS job_id,

job_desc

    FROM (SELECT job_id AS job_id1, 1 as seq, LEFT(job_desc,500) AS job_desc

    FROM...

What wizard? How do you want to store the values. Are they numbers (some locales use comma instead of full stop as decimal separator).

If you want to store the values...

The inserted table will contain 1 or more rows depending on how many rows are being inserted.

with this staement

INSERT INTO dbo.myTable (IDField, IDField) VALUES ('A','B')

the trigger will have an inserted...

Check the contents of gintSite to make sure it contains a value. You will get this message if no value is put in the parameter. Can be a result of...

To quote Microsoft

'Because SQL Server Service Packs are cumulative, SP4 includes all fixes from previously released Service Packs, and can be applied to an original installation or to one where...

The column headers are an intrinsic part of the recordset output and cannot be removed. Only the application that receives it can  choose not to display them. wz700 is correct...

SELECT REPLACE(REPLACE(STR(col1,15,2),'.',''),' ','0')

SELECT REPLACE(CONVERT(varchar,col2,103),'/','')

UPDATE p

SET PriceName = (CASE

WHEN p.Price IS NULL THEN CAST(FLOOR(a.Price) AS varchar) + ' & Above'

ELSE CAST(FLOOR(ISNULL(a.Price,0)) AS varchar) + '-' + CAST(FLOOR(p.Price) AS varchar)

END)

FROM...

CREATE TRIGGER AfterInsertSysData

ON SystemDataTest

AFTER INSERT

AS

INSERT INTO Books (rid,fname,book_date)

SELECT s.rid,s.fname,s.book_date

FROM inserted i

INNER JOIN SystemData s

ON s.rid = i.rid

INNER JOIN res_test r

ON...

Thats OK Frank,

Thought there was an echo

there was an echo

was an echo

an echo

echo

echo