This is because the table table1 does not have any rows matching the WHERE filter.

I don't know why you're grouping on a filtered column:cool:

I'm glad, i could help...

The code which Jeff has posted is for T-SQL and not for VB. T-SQL uses single quotes to delimit strings (can be changed with QUOTED IDENTIFIER set option) whereas...

Check the the below queries...

Solution 1

UPDATEt

SETt.total_fee = ( CASE WHEN COALESCE( n1.Fee, 0 ) = 0 THEN COALESCE( n2.Fee, 0 ) ELSE COALESCE( n1.Fee, 0 ) END )

FROMtrg t

LEFT JOIN...

Hey Jeff,

Just to correct you that we don't need SA privileges to use sp_oa* procedures, we just need execute permissions on these.

Is this want your looking for?

SELECTS.BASE_ID, S.LOT_ID, S.START_DATE,

( CASE WHEN R.R.BASE_ID IS NOT NULL THEN 'YES' ELSE 'NO' END ) AS SUFFICIENT_OHQ,

'YES' AS STARTED

FROMWORK_ORDER_SCHED S

LEFT JOIN

(

SELECTR.BASE_ID, R.LOT_ID

FROMREQUIREMENT R

INNER...

Me too, still looking for such work-around.....:cool: And couldn't able be find till now!!!;)

1. What are the steps i need to follow.

... MSDN is the right place to guide you on this.

2. I do not want to tamper my sql 2000 in...

This isn't the case what you saying. This is the default but discouraging behavior of the designer.

When you open a view in design mode, though it is...

Nianz,

This information is not available in any versions of the SQL. I wish this could be added as an enhancement in the next release, may be in SQL 2K8.;)

SELECTP.ProductNo, C.Description, COALESCE( SUM( O.QtyOrdered ), 0 ) AS [Total Ordered]

FROMProduct P

INNER JOIN Category C ON C.CategoryID = P.CategoryID

LEFT JOIN OrderLine O ON P.ProductNo = O.ProductNo

GROUP BY P.ProductNo, C.Description

I think you need to specify the type of parameter as both input and output in the .net code when adding parameters.

What exactly do you mean by sp column outputs?

Right click on the job and select view history. A viewer will open, from which select the most recent execution and collapse it to view the step executions. ...

I searched the relevant objects from master and msdb databases but couldn't find the relevant information?

Does anyone knows where these configurations are stored?