Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. lannym

    Superloader 3 + BackupExec 10d

    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...
  2. lannym

    Superloader 3 + BackupExec 10d

    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.
  3. lannym

    Superloader 3 + BackupExec 10d

    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...
  4. lannym

    SQL Query

    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...
  5. lannym

    SQL Query

    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...
  6. lannym

    SQL Query

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

    SQL Query

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

    SQL Query

    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...
  9. lannym

    SQL Query

    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 -->...
  10. lannym

    SQL Query

    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 ','.
  11. lannym

    SQL Query

    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...

Part and Inventory Search

Back
Top