Update a report Parameter with select Max(date) from table

FAQ

Profile

Update a report Parameter with select Max(date) from table

Database Forums (Home) -> Programming

Next: Read data from SQL Server 2008 (Windows) to Infor..

Author

Message

jm27102

External

Since: Jun 09, 2010
Posts: 2

(Msg. 1) Posted: Thu Jul 01, 2010 8:59 am Post subject: Update a report Parameter with select Max(date) from table Archived from groups: microsoft>public>sqlserver>programming (more info?)

I'd like to update a report parameter with something similar to the following: @parameter= select Max(date) from table so it may be displayed in a report header or a report footer. has anyone tried this? >> Stay informed about: Update a report Parameter with select Max(date) from table

Display posts from previous:

Related Topics:

update table with Max(date) value from another table - this is my code and i keep getting an error ( ',' on line 4) and I cannot figure out what is wrong with this code. Sql 2000 server INSERT INTO USR_COSTPRICE (ITEMID,DATEPHYSICAL,QTY,DATEFINANCIAL,QTYSETTLED,COSTAMOUNTSETTLED, VALUEOPEN,DATAAREAID...

Select Modified date - Hi All, I'm having a table with two colums namely CreationDate (datetime) and ModificationDate (timestamp). While generating report I need to show the last modified date. since the modification date is a timestamp datatype, How can I convert that into..

select earliest date - How can I do this from four dates in each record?

Update a table with data from another table. - Hi! I want to update a table with data from another table. Lets say this is how i do it. Update REGD0230 tIN set tIN.Field1 = (Select tOT.Field1 from REGD0200 tOT where tIN.CompareField=tOUT.CompareField), set tIN.Field2 = (Select tOT.Field2 from..

dts to update table - Hi, I am writing a dts package to update a sql table using data in a csv file. I know that dts updates all mapped columns regard less of the column's value has changed or not. I need to perform a special action when dts actually changes any column'...

	Database Forums (Home) -> Programming	All times are: Pacific Time (US & Canada)
Page 1 of 1

You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum