Also, another approach could be
select a.name as your_name
, a.po_id as your_po_id
, b.name as your_fathers_name
from
tablename a left outer join tablename b
on a.po_id = b.id
This also may work.
In ASP, it would be possible to pass a value null as a parameter to storedprocedure.
Inside the stored procedure, it is possible to evaluate(instead of IF @Reason <> '') as below:
IF @Reason is not null
so is it possible to set null for parameter, in sp. If so, that may, take care of...
You may want to give the following a try(I have not tried it).
Assuming to determine the details of po_id for a specific @ID passed as a parameter.
Select a.name as your_name
, a.po_id as your_po_id
, (select b.name as your_po_name
from tableName b
where b.id...
You may want to try this.
Check the properties of sql server.
Right click on server click the properties.click the
security tab and and check authentication.Select sql
server and windows mode.
If the above works let me know.
Thanks.
I have a table named Job with columns Jobid, Industry & Wage. The measures I am interested are Count of Jobs and Count of Jobs with valid wage(ie. Wage > 0). The database is in MSSQL. How can I determine the number rows with value > 0 in Wage column?
Thanks.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.