Search results for query: *

Update to my problem listed above... after checking all the cables (they were all good)... over the past few weeks, i've figured out the problem. It Seems to be the boot order of the devices. Power up sequence: Power up LTO3 Superloader, after it's ready, power up the server it's connected to...

Wow, good thing you found it, and got up and running again. Still not sure what's going on with the loader here, nothing in the current setup had changed, and nothing was moved or unplugged either. I guess i'll have to call them again and see about a replacement... again.

Hello; Just curious how you made out and share the fact that today, i seem to be in the same boat again. I had problems with my first superloader 3, and tech support walked me through rebooting everypart of the system and re-adding the devices to the device manager.... but in the end, to my...

Look good now, thank you. The number figure is acutally dollars ($). Do you think the number format or datatype should be changed? (from test database) This the result: Year Total Feb 01, 2006 6435333.9500 Mar 01, 2006 243451.4700 Apr 01, 2006 134586.2000 May 01, 2006 1345408.4000 Jun...

1) Do you have any data after 2006 Jan? Yes 2) What is the datatype of SQLTranDate? Data Type is 'char' **see note 3) What database are you using? SQL 2005 Standard **When you asked about the datatype, that made me think of something, i copied this data from our production db to my test...

I should have explained better, only the words 'year' and 'total' were showing on the screen. (no numbers) something like this: ================= Year Total =================

No results, only the "year" & "total" are showing.

Current Code: Note: there is no 2007 data in the table, and the current year is correct on the system. select month([SQLTranDate]) as Month, year([SQLTranDate]) as Year, sum([SQLTranAmt]) as Total FROM chart1 where [SQLTranDate] >= convert(varchar(10), dateadd(day, -day(getdate()) + 1...

Thank you, I greatly appriciate everyeones help, looks like it's almost there. I wish i could be more helpful with changing the code, but i guess that why i'm here, being new to the programming side I'd like to learn wherever i can. Show's both months for each year though. Feb06 through -->...

Thank you, I put the code in, but get an error about the comma on line 4. (I cut and paste the code in, and moved the line with the comma up to make it a long line, and it still shows the error.) Data failure. [Microsoft][ODBC SQL Server Driver][SQL Server]Line 4: Incorrect syntax near ','.

Hello, I'm trying to complete a SQL Query to return a set of data for creating a dynamic chart. For example; I would like to return the data for the last 12 months. So for Feb 2007, would return data for Jan 06 to Jan 07, and in Mar 07, data returned would be Feb 06 to Feb 07. I'm somewhat new...