Search results for query: *

Can someone shed some light on this and tell me why when I do an 'exec rtd_voip_ret' in a query window that I do not get a return value? When I run it ouside the function it works fine. Create Function rtd_voip_ret () Returns varchar(20) as begin Declare @next_id varchar(20) set @next_id =...

Hiya Fellas, Can anyone shed some light on how I may backup/delete the LDF data file on my database that has grown to be about 1.4 Gig. I have tried serveral options but no go. Thanks in advance for the help, rtdvoip

Hiya fellas, is it possible, and I am somehow sure it is, to do an insert from a sql database on 1 physical server onto another seperate physical server? If so could someone shed some light on how it may be done. Thanks in advance for your help. rtdvoip

My problem is as follows, My sub query in the update of @rate_hier is returning multiple values. I only need on value returned at a time. If i try to do a simple join i still get multiple values. Any thoughts on how I can get around this? code... [code/] Create Function fn_AtoZ_Prices(...

What is the quickest procedure for setting a table to be read-wite? thanks in advance, rtdvoip

I did not set it up in a SP = SQL Procedure? just in a text query that I import into the query analyzer where I want to run it. If I try to create a procedure then the code after the first go is missing.

Hiya fellas, Is it possible to set a global variable that will remain until a second batch query is executed... delcar @@var int set @@var = <something> go query.. go query... It says that the var is not declared. Is there some way around this? thanks in advance for your help, rtdvoip

Here is how I was able to resolve my situation. Thanks for all the help. -- code follows below-- create procedure bill_amount as create table #temp (voip_id varchar(128), amount money); insert into #temp (voip_id,amount) select voip_id,sum (call_cost) from services,bt_test where...

I used a temporary table to handle the problem. so if you read this, when do temporary tables get released?

hiya fellas, Can anyone help me with this? I need to get current costs into the customer_record table. Three tables 1 - customer_record 2 - Services 3 - traffic Customer_record has a unique pin:voip_id and current_bill Services has: voip_id associated with multiple...

Is there anyway for this to be enhanced so that such a query will run faster in SQL? ----code below---- Insert Into bt_tmp(Clarent_pin, service_code, duration, bill_type, phone_number, start_time, disconnect_reason, extended_reason_code, ip_addr_egress...

It is all string compares not integer. I will look into the soundex as well. thanks.

Is there a way to use MAX in the following situation? I have a string '902124543456' I need to get the closest match in a table with a known index. ex. '902124543456' - compare value table values index prefix 1 90 1 90 1 90212 any thoughts...

Good Monday, AS I have shown the database program and the computing is correct, I greatly realize SQLSister's reply. I am running my program against 5000 records and it is taking 3 minutes. As I was going to now try a hash table, I am wondering if I can. If I create a hash table with Pin...

Ok it is late in the day but can someone help? declare @x int, @prefix char(30) declare @breakout_no char(10) set @breakout_no = '19999999' set @prefix = '' set @x = len(@breakout_no) print @prefix while @prefix <> @breakout_no begin print @x set @breakout_no = substring...

LogicalmanUs I just about have it working. now all i need to do is revisit my string manipulation problem from yesterday. It was not what I was thinking. It works ok if you set the @variables but I need to get the call_price from the rate_plan table by using the rate_plan_index that I have and...

dmhirsch It is almost exactly what I did...check this out. GO Declare @pin varchar(128) Declare @duration int,@r_r_indx int,@billing_factor int declare @duration_factor int, @duration_factor_comp int DECLARE clarent_cursor CURSOR FOR SELECT Clarent_pin, duration FROM b_t_cp2 ORDER BY...

Everything was steping through fine but now that I am trying to [code] update traffic [code] set duration=@duration [code] where CURRENT OF clarent_cursor I am getting the following error... Server: Msg 16929, Level 16, State 1, Line 51 The cursor is READ ONLY. The...

SQLSister, Thanks for the info on performance. I just need something to show on Monday. It is not on a live system but just an example of how the database will function. rtdvoip

LogicalmanUS Here is what I have put together so far. It is stepping through but now I need to do some other computations. I suppose I need to do these computations whhile in the while @@FETCH NEXT = 0. Any suggestions? /* Begin code for Fetch */ USE phase1billing GO Declare @pin varchar(28)...