Search results for query: *

I think what i want here is not possible .Thanks for help friend.Now I m using cursor for this purpose .

feherke frnd .. I have one select statement like select empcode,rate,PerVal,dbo.replacetokens((empcode+(rate*(PerVal*4)) )) as Total from <Table Name> In this select statement we are replacing the token in string by values . and then i need to get result same time when i execute the select...

right friend , but i need to get result in select statement.so, i cant use exec in select statement .

SELECT '(1+(2*(3*4)) )' AS x that expression data type is string .

i have some expression in string like (1+2(3*4) ) and i need to execute it in select statement to get corresponding expression result . can anyone suggest solution for this .

where condition is giving error when we use between date column and two input dates . when we are generating the date from concatinating of month,day,year in one select statement by using unpivot b'coz we have taken days as column D1........D31 like .. and then in next layer we concat that...

How to apply full join on xml nodes ..... we can apply cross join on xml files we can apply outer apply on xml files is there full join on which we can join xml files

Thanks for reply .... but i want to delete all the related tables with the master table to enter the valid to master and transaction tables

how to delete the table which has reletions to other tables and chain goes on..by input table name i want this for only one table .....dont give for all tables....