Search results for query: *

I solved case sensitive comparison just the way you did but I do not understand chechsum. Thanx anyway

I was performing some case sensitive comparsions and as one of options was to use check sum, anyway I conluded that CHECK_SUM and BINARY_CHECK sum functions return same value for different inputs.As far as I know those functions are like hash functions and CHECKSUM applied over any two lists of...

No No proc I gave is just similar to my problem.As I said I have one procedure wich I can not change, then that proc returns two set, then I need second set for some calculations in my proc, than I need data from exactly that procedure wich returns two sets.

that is the problem.i can't make two procedures I need to use existing proc wich returns two sets.Then I need to insert second set into some temp table to make some calculations.It means I can't use front end apps or or create two procs.

that is not solution.orders table and Employees tabel do not have same shema.Besides all that how do you intend to substract data from Employees table using result of stored proc?????

Is there possible two fill table with second result set returned by stored proc.For instance create proc test as begin select *from orders select *from Employees end insert into sometable exec test So I want to fill table 'sometable' with result set 'select *from Employees'. There by...

I need to call rand functino within another function but server raises an error.For example I can't create followng function create function dbo.test() returns float as begin declare @i float select @i = rand() return @i end