Search results for query: *

I like a good Maths problem to solve and I've just written a little bit of VB code that may help get you somewhere on the right track. I haven't had a great deal of time so it may not work, but let me know how you go anyway, I'd be interested to see the outcome.. You need to create a form with...

Hi, I have a report in MS Access (a very simple column,row report) which on a monthly basis I export to Excel. All is fine. I now need to add a new field to the MS Access report. I add the field, say in column position 10, and now export the report. The field that I have just added in MS...

Me again... found what I wanted. Behbeh, It was actually a response to another one of your threads in SQL Server but for anyone else interested thread183-110119 bascially set nocount on at the beginning of the stored procedure... simple when you know how!!!

I'm having the same problem. I have the cause of it in my case but not the reason why nor how to solve the problem. In my case it is due to the fact that in the stored procedure I am populating a #temp table and selecting from it. I have found that if I do something like select * from #temp...

Hi, one of the outputs of a stored procedure I have written creates a text file. I have achieved this by using xp_cmdshell in conjuntion with a bcp command. My question surrounds security. Because of the mixed environment we have in our company I have found it easier for the time being to use...

thanks chuck, you're a legend... I obviously have to make a couple of changes to suit my particular database but it worked a treat.. eds

Assume I have a 2 column table. AlrmCode,AlrmText AlrmText actually contains data that I need to display as different rows. An example of the information that is kept in the table is: AlrmCode,AlrmText 2154,*alarm info 1 *alarm info 2 *alarm info3 2178,*alarm info 4 *alarm info 5 But I...

just some information for anyone reading this thread.. I have managed to import the data above. I essentially exported the data from excel to a tab-delimited text file and used the bulk insert command to import the data. (I did have some problems - tab characters within the excel spreadsheet...

Hi, I'm trying to import data from an Excel spreadsheet.One of the fields in the spreadsheet is a comment field which is often greater than 255 characters. On importing the data to SQL, this field concatenates at 255 chars. It doesn't matter whether I create the import table up-front with the...