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

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

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...

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...

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...

Hiya fellas, Is there a way to go through a table step by step. I need to grab a pin number and a duration. Then using those two identifiers I need to access other objects in seperate tables to compute values and return the values to the row associated with the pin and duration I just picked...

Hiya fellas, Is there a thread out there giving any hint or information on string compares. I need to find the nearest match on some numbers and using it do one other computation. for example : breakno = 1234 next breakno = 12346 using an index (known) and having a number...

hiya fellas, any suggestions on how I may take out some '-' from a phone number using a string function in sql? for example phone_number is '777-777-777' i need it as 777777777 on my version it tells me that ltrim and rtrim only takes one argument. thanks in advance

I have just started learning sql and although I have books a good example is not available for my current question. Please help.... I have a duration of type int in seconds I have a start_time of type datetime how do i compute the end_time of type datetime using the start_time and duration...