SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-29-2008, 08:09 AM
| ||||
| ||||
 selective sql request Hi, I've got the following Stored Procedure CREATE PROCEDURE pr_Admin_GetCtrlFields --Get the control fields, detail or flow according to the ModeID parameter @QueryID int, @ModeID int AS SELECT FieldID, FieldName, EntryInfo, ControlTypeID,ViewFieldTypeID, ViewTable, ViewField, F.SortOrder, InsertField, UpdateField, FieldTabId, ModeId FROM Fields F, Queries WHERE F.QueryID = @QueryID AND ControlTypeID <> NULL AND ModeID = @ModeID ORDER BY F.SortOrder ASC GO [Fields] and [Queries] are linked by a field called {QueryID}. [Queries] contain a field called {RootTable}, and what I want to do is: If ViewTable is NULL then I select {RootTable} as ViewTable, otherwise I select ViewTable as I'm currentely doing it. So how can I introduce this condition in my Select statement? Thx      |
 |
« Sql Query with one column as the name to another column
|
Returning average of multiple rows in a table join »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 08:44 PM.
