Search results for query: *

Dave Thanks for that, the vpn terminates at the Cisco. The Cisco is eventually going to host an ip telephone system, we are not 100% privvy to its set up and assume that it's DNS is required for this, but what you say makes perfect sense to me although external dns lookups seem to perfom a lot...

We have recently introduced a cisco 2800 router onto a small network with an out of the box SBS 2003 with pretty standard configurations for DC DNS DHCP RA. The Cisco router is now handling DHCP for VPN and Lan clients. It has a pointer to the SBS DNS Server and to the ISP DNS. The router has 2...

SQLDenis I got there but you cant have temporary tables in a function!

I'm trying to perform an NSlookup in a xp_cmdshell The following returns the required result DECLARE @Cmd varchar(8000) DECLARE @Ip varchar(8000) SET @Ip = '82.44.127.12' SET @Cmd = 'NSLOOKUP ' + @Ip EXEC master.dbo.xp_cmdshell @Cmd But can this be done in a function? I tried but I cant seem...

George Great that does the trick. Thanks Al

George The union returns one row from each table, this was by design thru unique keys but has been changed to a select top 1 which also speeded the query up. Al

Alex. The union only returns a single row from each table, maybe 15-20 results. However these results come from tables with up to 100k records and normally returns in less than 1 second. I can reduce the amount of fields in the union, currently it returns around 20 and I only require 2 of...

I have a function GetBestPrice that returns a table of values that are pulled from a union select query on 15+ Tables I then call the function to get SELECT * FROM GetBestPrice() WHERE Price IN ( SELECT Min(Price) FROM GetBestPrice() WHERE STOCK > 0 ) This does work, but I have a strong...

The MDI parent can be accessed using DirectCast Dim MDIparentForm As Formn1 = DirectCast(Form2, Form1) Dim FormINeed as Form3 = MDIParentForm.Activechild FormIneed can then be accessed directly.

Hi, I have an MDI form that can be opened many times in its parent as tabbed forms. I have a seperate form that loads as a dialog and need to access a control on the active MDI child form. I press a button on the dialog and need to pass a datarow to a grid control on the active MDI child...

I have two datagrids, both draw some of thier data from the same SQL table, and the rest from several others. I need to drag data from one grid to the other, in doing so, all I need to do is change a few fields in the row. the primary key in the shared table is unchanged. In the dragdrop when...

Johnwm, Excellent thanks for that, I was trying similar but got my path incorrect Fileserver\\file\filename.xls \\Fileserver\file\filename.xls works a treat Thank you

I have a DTS package that imports data from an Excel Spreadsheet, the file is located on the SQL Server and has a path D:\file\filename.xls The DTS works fine when run on the server. I am now trying to execute the DTS from vb. The DTS runs ok, but I get an error Additional information...

Hi there, I am trying to output a table with two nvarchar fields (500) and about 25 other fields, using a DTS transform. I am unable to load the output fields in the data transform without enteprise manager closing after pressing exec. It works when I export to an access type. Question: is...

Nice one thanks I learn a litle every day - problem is I forget a lot more!

I have an sp that gets product information from a table. I need to join all the results into one string Example Name Value Units Width 35.0 cm Depth 50.1 cm Weight 0.75 kg Height 0.7 cm Into Width 35.0 cm | depth 50.1 cm | Weight 0.75 KG | Height 0.7 cm I guess there is an easy way, but it...