Search results for query: *

Am trying to save multiple worksheets within a workbook as a tab delimited file. However with the following code it saves multiple files with the correct sheet name, but only the data from Sheet1 (i.e. doesn't save the data from all the seperate worksheets) Private Sub CommandButton2_Click()...

Am trying to clean up data. I am using LTRIM, RTRIM but also need to remove unnecessary spaces within the string. e.g. This is my string should be This is my string Any solutions?

I have a multiple store procs that are called from a 'controlling' store proc. This is working fine, however I am trying to introduce Error trapping. This is all fairly new to me and I need some advice as to what I should be looking for. So far I have been using: CREATE PROCEDURE Control AS...

I have the following code which returns "Incorrect syntax near the keyword 'THEN'." Please advise me on my errors! declare @ImportTblAP nvarchar (2), @ImportTblFY nvarchar (2), @FYSTRING nvarchar (10), @ModAPFY nvarchar (12) select @ImportTblFY = rtrim(max(FY)),@ImportTblAP = rtrim(Max(AP))...

I have a number of store procedures that run in sequence as part of data load process each month. Each one requires a common value to extracted from a table based on a criteria (e.g. Current Month). Can I create a variable in the first store proc and pass it to the remaining or do I have to...

Is there a way of picking up the details of a user i.e. their windows login name (which can be done through Excel etc)

Am attempting to update a table by adding a value from one table into a table that currently contains Null. current code is: UPDATE table1 SET NrofRows = a.NrOfRows + b.NrOfRows FROM table1 a, table2 b WHERE a.Key = b.Key The Values contained are table1 NrOfRows = Null table2 NrOrRows = 1000...