If you are using OLEDB Connection, add an output parameter and change "ResultSet" property as "none"

Thanks for your reply,

sqlcmd -s servername -q "exit(exec testproc)"

@echo %errorlevel%

stored procedure returns an integer value with select statement

ex: select -1; return;

when i run the procedure using .bat file(bat file script...

By using SSIS we can do, but i want to do it using .bat file

Based on value of first procedure output parameter, I will decide to execute second procedure.

DECLARE @P1...

cast salesorderid as varchar in subquery

select customerid, STUFF ((select ', ' + CAST(salesorderid AS VARCHAR(50))

from #temp

where(customerid = results.customerid)for XML path ('')),1,2,'') as salesOrders

from #temp results

group by customerid;

Regards,

venugopal.rr

Replace "." with empty and cast it as int than compare it...

CAST(REPLACE(IP4,'.','') AS INT)

yes. you cannot return a string value using RETURN statement.

if you want it as out put can do it in two ways.

1. declare a out parameter and assign that value...

pivot will work only if each rid has given number of pids.

In your case it is 3.

if any rid having more then 3 pids it will fails.

Please check what type of variable u have declared for @PVC_APPLICATION_NAME.

I think u have declared as INT....

actually it is asked by an interviewer.......

The question is...there are two tables emp and dept has foreign key relation..

If we retrieve the result from emp using linked server.... what will...

Can you mention what type of non-clustered index you are creating....

How many indexes are there in that table...

can u check the params to the function....

i think first argument to the function is not smalldatetime......

Can't we use distinct............

Please check that DVD.....may be some files are missing...

Check the size of the all files with the given size in SITE.....

Hi, U can do it by using ranking function....

select a , b from (select a, b, dense_rank() over (partition by a, order by b) as rnk from tab) T

where...

Hi,

First disable the constraints on the table and run the delete command....