Search results for query: *

Hi All, I have this code $computer = gc env:computername Get-Content -Path 'C:\temp\error.log' -Tail 1 -Wait | where {$_.contains("error")} | ForEach-Object -Process {send-mailmessage -SMTPServer "SMTPSERVER" -to "someaddress@someaddress.com" -from "someaddress@someaddress.com" -subject...

Hi Guys, I am using code similar to the following For Each WS In Worksheets WS.Cells.Replace What:=Search, Replacement:=Replacement, _ LookAt:=xlPart, MatchCase:=False Next to try to replace values in a sheet. My question is can you reference the row number of the cell that is currently...

Thanks pwise your a legend

Hi All, I am trying to transfer data from one database table (ODBC linked table non SQL Server) to a SQL table. I have this working and I use a configuration table to determine what data needs to be transferred. The config table is simply [Item Name], [Frequency], [Date Last Transferred] where...

Thanks for the prompt response Borislav Basically if the start date from table 1 is within the start and end date of table 2 then it is assumed that the sum will be for that period. The way the driving ssyetm works is that time will always be cut off at 18:00 and 06:00.

Hi All, I have 2 tables Table 1 ItemID Start End Hours D1 01/06/2009 6:12 01/06/2009 6:17 0.10 D1 01/06/2009 7:43 01/06/2009 8:39 0.94 D1 01/06/2009 8:49 01/06/2009 9:45 0.93 D1 01/06/2009 9:49 01/06/2009 9:53 0.07 D1 01/06/2009 10:05 01/06/2009...

Hi all, I am trying to extend the following query to find successive duplicates SELECT Value, COUNT(Value) AS Duplicates FROM TABLE1 GROUP BY Value HAVING ( COUNT(Value) > 1 ) So I have a table that has the follwing data Date ID Value 12/01/2008 1 12 12/02/2008...

Thanks Guys

Hi All, I have a calendar table which contains daily values i.e 01-01-2008 01-02-2008 Is it possible without a join (or otherwise) to select every 7th day given an input day so for example if a user selected 01-01-2008 the next date would be 01-08-2008 and so on. Cheers

Hi All, When I create a pie chart and there tends to be a lot of records with small percentages. When this occurs the labels become squashed and overlapped. Is there a way around this or is there a way to not show the label for anything below a certain percentage Cheers

Cheers Mate

Hi all, I have the following table (including data) Date Product Weight 12/06/2008 4:15:00 AM A 100 12/06/2008 4:30:00 AM B 100 12/06/2008 5:00:00 AM B 100 I have grouped the data by the hour (i.e. all above is grouped into 1...

Cheers Ryan Works Great

Cheers Ryan, Thats the twist of this query first it needed to be grouped by hour so after originally Date Product PrevProd Weight 12/06/2008 4:15:00 AM A A 100 12/06/2008 4:30:00 AM B A 100 12/06/2008 5:00:00 AM B...

Hi all, I have the following table (including data) Date Product PrevProd Weight 12/06/2008 4:15:00 AM A A 100 12/06/2008 4:30:00 AM B A 100 12/06/2008 5:00:00 AM B B 100 12/06/2008 5:30:00 AM B...

Hi All, Is it possible to have two aggregations using the pivot query. for example if you have the following Date Product Pice1 Price2 2008 a 1 2 2008 b 3 4 2009 a 3 4 2009 b 5 6 becomes Date...

Thanks Guys appreciated

Not sure but it kind of sound like what Armando Prato has done here http://www.mssqltips.com/tip.asp?tip=1455 Example 3

Hi All, I am trying to create a stored procedure that accepst a number value (in this case the number represents an hour) the results of the data should then be grouped by this value so for example I have the following Date Value 07/01/2008 4:15 200 07/01/2008 4:35 221...

Thanks Guys