Search results for query: *

Hi, We have SQL Server 2008 Standard Edition installed on our DB Server. Following an attempt to purchase SQL Server 2008 Developer Edition I was informed by MS that this is no longer available, but I could buy 2012 Developer and downgrade to 2008 R2 as we have volume 2008 licence. Does...

Hi, I have a problem with some reports where charts get shown twice (sometimes more). It does not occur on all reports with charts. They all show okay in the Visual Studio design environment and if I view them directly on the report server, so it appears to be an issue with the .net report...

Hi, I have a function that returns data from cells in Excel workbooks using ExecuteExcel4Macro Function GetCellData(cellRef As String) Dim wbPath As String Dim wbName As String Dim wsName As String Dim result As String wbPath = "C:\TEMP\" wbName = "[Values.xlsx]" wsName = "Sheet1" result...

Hi, I am a SQL Server developer. I have the following T-SQL script that needs to be converted to run on Oracle. I don't have access to an Oracle system and have no experience of PL/SQL. I would be grateful if anyone could highlight any other things that look like they won't work in Oracle (I...

Hi Please bear with me I've been using SSIS for two days now. We have a data migration routine that is currently a set of stored procedures that pulls data from multiple databases and consolidates it in one database for reporting purposes. I have been asked to move this into SSIS. One of the...

Posted in ASP.Net but may be a browser issue, any help gratefully received: thread855-1366935 There are two ways to write error-free programs; only the third one works.

Hi, I have a folder which is secured using forms authentication. I have a hyperlink on my menu that points to a form with-in this folder. When I click on this link my Login.aspx form pops up, credentials are validated against a database and then it redirects to the initial requested page...

I am running IE6 SP2 on Windows XP. Every time I go to a site that requires an ActiveX control (e.g. Microsoft Update) I have to install the ActiveX control if I have rebooted between visits. I have been unable to find anyone with the same problem or anything on Google / Microsoft. Any ideas...

Hi I have set up anonymous merge repliation on a SQL Server 2000 database. I need to be able to replicate with Access 2000 database subscribers. I have created a console application (code available if required) to run at the subscriber that uses SQLMERGXLIB. The replication to Access 2000...

Hi, I am very new to C# (started today!). There seems to be two ways to convert an integer variable (in this case x) to a string: i.e. MyString = Convert.ToString(x) MyString = x.ToString() Can anyone tell me if there is any reason for using one or other method, or are they essentially the...

We quite often play the following word game. Works best as a spoken game (requires more concentration). You can play with any number of people. 1. First person says a letter. 2. Going round in order people add one letter at a time which must form the start of a word with the previous...

Hi, Is there a Delphi equivalent for the VB Like operator. I want to be able to check to see if strings are in a particular format. eg. if StringVariable Like '[A-Z][0-9][ ][0-9][A-Z][A-Z]' then //Do whatever translates to... if StringVariable is of the format Capital Letter, Number...

Hi, I have a ListView that I am adding columns to using... for i := 0 to ADataSource.DataSet.FieldCount - 1 do begin ListColumn := lvSchemes.Columns.Add; ListColumn.AutoSize := True; ListColumn.Caption := ADataSource.DataSet.Fields[i].FieldName; end; NB. ListColumn is a...

Hi, Counld anyone tell me the Delphi equivalent of Visual Basic DoEvents. DoEvents: DoEvents switches control to the operating-environment kernel. Control returns to your application as soon as all other applications in the environment have had a chance to respond to pending events. This...

I would like to know if it's possible to make a stored procedue that can reference fields by position rather than by name. I have a number of tables to update/insert into etc. All are of the format KeyID, Description. But the actual field names are different. I would like to use one stored...

I would like to change this BULK INSERT tblImportTest FROM '\\CHATS-FS1\ENERGY\FENSA\SQL\TEST.TXT' WITH ( FORMATFILE = '\\CHATS-FS1\ENERGY\FENSA\SQL\bcp.fmt' ) So eventually I can pass the File Name. I have tried this as a test.. DECLARE @FileName VARCHAR(50) SET @FileName =...

Hi I have some sql that bulk inserts from a text file to a table using a format file. USE FENSAOLD DELETE FROM tblImportTest BULK INSERT tblImportTest FROM 'F:\SQLDATA\MSSQL\DATA\TEST.TXT' WITH ( FORMATFILE = 'F:\SQLDATA\MSSQL\DATA\bcp.fmt' ) This works fine while the text file and...