Search results for query: *

I have been trying to setup a running date difference (DAY) query for this table that resets on StockCode Change but with little luck as I have been trying to modify a running sum one I use... Can anyone help SELECT RowNum, StockCode, ReqDate FROM temp6 Data example 47 E0038...

I need to setup something to synch a master folder to all clients.. We have an accounts package that uses Crystal Reports and for some stupid reason the Invoice, credit etc.. templates need to be on the local computer and cannot be shared from a central point. Currently when I make a change to a...

I am trying to group some quantities together but I keep getting stuck on the last stage.... SELECT SM_STOCK_CODE, sm_type, YEAR(SM_DATE)AS smyear, CASE WHEN sm_type = 'P' THEN SUM(CASE WHEN sm_status = 'O' THEN 0 - sm_quantity ELSE sm_quantity END)ELSE 0 END AS Bought, CASE WHEN...

Starting from scratch on this one. Our production team use a spreadsheet to manipulate data pulled into it from our SQL Server and they then want to send the updated data back to the SQL Server. Luckily for me it is just the Production Date they want to update. All they need from the...

ref thread958-1119077 I have one machine that throws up this error when trying to access an adp over the network, googled and found nothing an anyone help

Before we start this is not my database.... We have a Time and Attendance System that stores all the clockings in seperate tables depending on the year and month i.e. DT102006 = Oct 2006 DT112006 = Nov 2006 What I am trying to achieve is to extract out of the tables certain information and...

I'm trying to ressurect an IBM Netfinity 5500 server and I get beep codes that aren't in the book beep beep beep beep beep beep No display is shown either Can anyone help ?

Wonder if anyone can help a HTML / PHP Newbie How can you change the row result font and size ? --------------------------------------------------------- $msresults= mssql_query($msquery); $i = 0; while ($row = mssql_fetch_array($msresults)) {if ($i > 0) { print "<tr...

Bleedin hard info to find but can someone point me in the right direction for connecting PHP to SQL2005 on WINXP running Apache.. I would like to convert an Access app to a Web Based App and hopefully become a millionaire ( I wish :-) )

I am trying to set up a calculation in a view against 2 tables. Basically I have an embedded select statement + embedded select statement the problem is if either embedded select statement returns no rows then the calculation fails. Any ideas how I can get around this ? (embedded select...

Hi all We have recently had a new Time and Attendance system installed that uses our SQL2000 server and I need to extract information on absences from it to import into our new Employment Law Software which uses an MDB back end along with an MDW... The problem I have is when setting up a new...

On my access Forms I have little list boxes that display various information about the data each has a refresh button that updates the rowsource but a couple of them take about 25 seconds to execute and I was trying to get the label to change colour to show it is doing something and revert back...

I have this query for a complicated costing routine and it's ended up a complicated query that I have just spent 1 hour tidying up so I can see the wood for the trees... What I would like to know is there anyway of optimizing the code that is blatently obvious to you guru's...

Hi can someone help I have some listboxes (from the toolbox) that users want to export to an excel spreadsheet akin to how Crystal reports does it whereby it opens in a temp excel sheet then you have to save it....

I'm stuck on trying to sort this one..... 2 tables RefTable = StockCode, StockCAT DataTable = Account, StockCode, Date What I am trying to find out is from RefTable with a filter of StockCAT = 10112 or 10115 what products are customers not buying within a certain date range grouped by...

Don't mock me as this statement works but added to the rest of the query I soon run out of space (not suprised) this is just a small snippet of the code but if someone can point me in the right direction to shrink it I would be eternally gratefull... I was hoping there would be some sort of DIM...

I wonder if someone could help me or point me iin the right direction I have a DSL account with 8 public IP's I have my DG814 router connected to the Internet and passed straight onto the CUBE3 which is set as a DMZ by the DG814... The Cube has its Eth1: port set to a public IP and its eth0...

I wonder if someone could help me or point me iin the right direction I have a DSL account with 8 public IP's I have my DG814 router connected to the Internet and passed straight onto the CUBE3 which is set as a DMZ by the DG814... The Cube has its Eth1: port set to a public IP and its eth0...

I have moved a SQL database to a new server and one of the utilities I need to use requires me to log in as the database owner for the life of me I can not seem to find how to change the tables owner can someone please explain how to do that...

I need to let 2 sites access each others databases for information purposes and the other week I set up our router to point any sql port requests to the sql server, which worked fine but I am concerned over security. Is it a case of just changing the port to something obscure and do I need to...