Help with script to merge two statements

[fabien]

Hi!

I have the following statement:
update grid_hdr set datum = XX where grid_id = XX;

I get grid_id by doing:
select grid_id from grid_hdr where (map_data_set_name = 'blbla' and geo_name = 'blibli')

Could someone please help me:

1) merge those two statements into one
2) make a script that will ask map_data_set_name, geo_name and datum and then search the grid_id to make the update statement.

Thanks a lot!

 

[JamesLean]

UPDATE grid_hdr
SET datum = XX
WHERE map_data_set_name = 'blbla'
  AND geo_name = 'blibli'

--James

 

[fabien]

Thanks I should have thought of that!

And how can I make it a general script asking for blbla and blibli?

Thanks again!

 

[JamesLean]

Use a stored proc:

CREATE PROC myproc
  @datum datetime,
  @map varchar(20),
  @geo varchar(20)
AS

UPDATE grid_hdr
SET datum = @datum
WHERE map_data_set_name = @map
  AND geo_name = @geo
GO

--James