Sup Adam

thanks for the links. read thru them and the devx article is quite good. been messing around with cross tab queries today without any success.

i can achieve what i...

Hi Adam

thanks for the help so far.

the code you provided will not group the TotalSales into SalesThisYr & SalesLastYr and the issue with grouping these by the date parameters i...

Hi thanks for replying.

here's my current View in code:

===

SELECT TOP (100) PERCENT dbo.JobDetails.Weight AS TotalWeight, dbo.JobDetails.ExtPrice AS TotalSales, dbo.Jobs.InvoiceDate

FROM ...

hi guys

many thanks to all that responded to my request for help. i rec'd not only a solution but also alternative methods of a solution.

i'm gonna throw in another here,...

Hi Jon

thanks for your help mate.

i shall give it a bash later on today.

yes, i needed the first row insert to be zero for @i otherwise the MaintStartDate will be...

Hi Grasshopper

actually you are correct with the Extra Begin, i forgot to also add the extra End. the code executes now updating the original table with user inputted data &...

Hi Grasshopper

adding the extra Begin causes an error.

any other suggestions? anyone?

regards

jerry

hi john

got it sorted, found that there was a missing closing 'end'.

thks again for your help.

Hi John

after a rest from this, i took another look at the problem i'm having. executing an insert into directly from sql server revealed my problem. there was a conflict...

hi john

thks for the procedure, you've been a great help.

i'll get back to you tomorrow (thurs) as its late here on wed night in australia.

regards

jerry

Hi John

could you guide me thru how to run a profile on sql server 2005? this is way beyond my knowledge now so a step by step procedure would be...

i've tried a direct insert into from sql server, code below but rec'd this error;

===

Insert into dbo.Equipment (EquipmentNumber, ProjectID, DrawingID)

Values (T57777,18,NULL)

=====

error is "The name "T57777" is not permitted in this...

hi andras

thanks for your tips.

how do i handle multiple updates row by row? i'm not a trained programmer so excuse my ignorance.

regards

jerry

hi thanks for responding.

my front end is on asp/vbscript and its a standard insert into routine. i've tried including and excluding the DrawingID field on the record form but it...

hi chirag

Equipment table with fields (equipid, make, model,serial, vendor,date,purchcost)

Maintenance table with fields (maint_id, equipid[fk], DateStart, description, frequency, PeriodType, NoOfRecurrences,ScheduleDate)

once data is populated into both tables, i'm not sure how to...