Search results for query: *

Hi I am running a stored procedure which returns id's that I can loop through. my problem is if I try to use getrows to put the data into an array format the the array does not seem to be populated. anyone any ideas Thanks in advance

I am having Dificulty explicitly converting a varchar to numeric The table 'cost' has a 'value' column set to varchar the user is allowed to imput commas in the value. When I run my report to extract the cost values and try to convert or cast so that I can do sum arithmetic on it. It falls over...

I am trying to create a view on the server on the fly I use the following on one line to test if the view exists before creating it Connection.Execute ("if exists (select * from sysobjects where id = object_id(N'[dbo].[myview]') and OBJECTPROPERTY(id, N'IsView') = 1) create View...

When imputting values into Excel there are certain arrangements of numbers/letters which are taken by Excel to be Exponential. E.G. 15E20 actually represents a room number. But Excel insists that it is 1.5 +E21 To stop this happening it will have to be somthing in the set up because we bring...

I have a VB app. that puts a tab delimited text string onto the clipboard for pasting into Excel. e.g. Clipboard.SetText strData$ each row is terminated by a carriage return. This works fine on 99% of the machines it is run on. But one will not see anything on the clipboard for pasting. It...

I have a table which contains the following data :- loc_id id val 730 450 1 730 250 2 730 350 2 730 251 3 730 351 4 730 451 3 I need to show the data as for each loc_id dependant for certain id's The value contains the group and for others the val is to be added...

I am new to SQL and have a problem converting a varchar field into date. The data is in the form "01/01/2001", but is stored in a varchar field. I am trying to agregate the field at the same time. But that is another problem. What is the syntax for this? Thanks in advance. Dave c