SQL Server Forums - How to code this ?

Home | Weblogs | Forums | SQL Server Links

Active Forum Topics | Popular Articles | All Articles by Tag | SQL Server Books | About

SQL Server Forums

Register Now and get your question answered!

Username:	Password:
Save Password
Forgot your Password?

All Forums

General SQL Server Forums

New to SQL Server Programming

How to code this ?

New Topic

Reply to Topic

Printer Friendly

Author

Topic

sadbjp
INNER JOIN

41 Posts

Posted - 05/14/2007 : 10:41:00

Hi,

How can write this in a query:

If @maxLastUpdate is later than LastUpdate, call stored procedure usp_RubricReportUpdate @DataYears, @County, @Distirct to update the report.

khtan
In (Som, Ni, Yak)

Singapore
16746 Posts

Posted - 05/14/2007 : 10:43:12


If @maxLastUpdate is later than > LastUpdate 
call stored procedure exec usp_RubricReportUpdate @DataYears, @County, @Distirct to update the report.

madhivanan
Premature Yak Congratulator

India
22461 Posts

Posted - 05/14/2007 : 10:44:55

If exists(Select * from table where @maxLastUpdate > LastUpdate)
exec usp_RubricReportUpdate @DataYears, @County, @Distirct

Madhivanan

Failing to plan is Planning to fail

SwePeso
Patron Saint of Lost Yaks

Sweden
29138 Posts

Posted - 05/14/2007 : 10:53:10

SADBJP, don't keep wasting our time!
Please state a real world problem and we will help yousolve it.

It all started here
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=83479

continued here...
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=83482

and last here...
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=83546

Peter Larsson
Helsingborg, Sweden

Edited by - SwePeso on 05/14/2007 10:54:24

Topic

New Topic

Reply to Topic

Printer Friendly

Jump To:

SQL Server Forums

This page was generated in 0.05 seconds.