Search results for query: *

SQL 2008 R2 Hi All, I have this data below, I have a unique ID. There are mutiple contract numbers with a transaction date. My end goal result is to have 1 record, the criteria to have one record is that I need to have the max transaction date. So what I would like to achieve is have a delete...

SQL 2008 R2 Hi All, If I have a query like so: select contractno, Address1,dateJoined from tableTest where datejoined between 2012-12-01 and 2015-12-31 and my results are: Contractno,address1,datejoined 387, johnroad, 2013-06-01 267, bobroad, 2015-12-01 267, bobroad, 2015-12-01 578...

Hi All, I have a table with circa 720,000 unique member numbers, I have a second table with multiple member numbers which has spans for each member. Member spans are defined by a date range (a start member date and an end member date). Each member can have any number of spans. These spans...

Hi All, I need to export data out to a txt file with the date format of MMDDYYYY - the source date is a datetime (2015-09-01 00:00:00.000) format - below is the solution I have: select replace(convert(varchar(10), getdate(), 101), '/', ') My question is, is this the best solution for this...

Hi All, I have a winform with a multi-line textbox- the user pastes in 1 column of data - example firstname - therefore there could be 10 names in a row. I would like to capture this data and pass it to a sql stored procedure. I have managed to go about it with code below - but this runs the...

Hi All, Access 2007: I would like to import xml files into an Access table using VBA. Below is the structure of the xml file: <?xml version="1.0" ?> - <V55 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="/smmt_share/v55_schema/xmlschema.xsd"> -...

Hi All, SQL Server Business Intelligence Development Studio 2008 I am trying to use "Execute Process Start" to fire up a certain application (that has a UI). The process works fine when I execute the process with in SQL Server Business Intelligence Development Studio itself, it opens the...

Hi All, SQL 2008 I have 2 tables, I would like to update the second table with results from the first table. Currently I am doing it like, using a temporary table: select column1 ,COUNT(*) as vol into #temp1 from table1 group by column1 UPDATE table2 SET column = vol FROM...

Hi All, --Using SQL 2005-- I am trying to import an xml file into SQL, below is a sample of the xml file: <V55 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="/blah/blah_schema/xmlschema.xsd"> <V55Header> <UniqueIdentifier>1</UniqueIdentifier>...

Access 2007 Hi All, I have recently set-up my first adp. Is it possible that once a procedure is called, that the database can still be navigated? I have a procedure that takes about 20 minutes to run, so when this is running, there is no access to any other forms etc until the procedure is...

SQL 2008 Hi All, I am calling a SQL stored procedure (from a Access db), is there a way in the SQL database to know if the stored procedure has executed successfully? Any info appreciated. Michael

Access 2007 Hi All, I have the code below that runs a stored procedure on an SQL 2008 database from Access. This bit works great and the stored procedure runs, but now I would like to use the results from the stored procedure in the Access database. I am stuck at what to add to this VBA code...

Access 2007 Hi all, I am exporting a table to excel then formatting from access in excel like so; Dim xlApp As Object Dim xlSheet As Object Set xlApp = CreateObject("Excel.Application") Set xlSheet = xlApp.Workbooks.Open(sFile).Sheets(1) With xlApp...

MS Access 2007 Hi All, I have a datasheet form with one of the fields that when "space, space" (i.e. hitting the spacebar twice and creating 2 blank characters) get's typed, it needs prevent this. Or, not even that important to be done while a user is typing, it will also suffice to have a...

SQL 2005 Hi All, I have a table with the following data: ID,Make 1,Ford 2,Ford 3,Ferrari 4,Ferrari 5,Ferrari 6,Ferrari 7,Mazda 8,Renault 9,Renault 10,Renault ID column is a primary key. The result I world ideally like from the above is: ID,Make 2,Ford 6,Ferrari 7,Mazda 10,Renault I have...

SQL 2005 Hi All, I have 2 servers each located on differnt locations. They both are not on a domain and they both connect to the net via a std router. Each server has a static IP. I am trying to set-up mirroring on a very small db. I run through the mirroring wizard, all seems fine, but the...

SQL 2005 Hi All, I have a unicode csv file, the first 3 characters are-  -. I try import this file directly into SQL (using the wizard) it does not import. If I manually remove these 3 characters(in a editor), then I am able to import in to SQL (via the wizard). We receive this file...

Access 2003 Hi All, I am running the following code - it inserts data from a combobox and a textbox into a table. Dim pid as Integer Dim infotodo as String pid = combopid.Value infotodo = txtboxtodo.Value DoCmd.RunSQL "insert into info_todo(Priority,info)values ('" & pid & "','" &...

Access 2003 Hi All, I have a table in Access that a field with vehicle descriptions. I would like to identify all records that have any chracters other than an alpha and \or numeric with in the description. e.g. Description Ford 14 Saloon S-A Mazda 3 Porsche 911 Turdo + From the...

Access 2003, Hi All, I have a table named VehCodes with the following data: MakeCode, ModelCode MA , 6 MA , 7 MA , 9 PR , 1 PR , 2 PR , 6 etc I would like to find the missing seqeunce ModelCode numbers for each MakeCode - from the example above the results would...