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

    Count of records for past week.

    Hey @SimonSellick, Yeah I get the same thing, which would explain things. How very strange. I guess that SQL Server runs it's week from Sunday through Sunday rather than Monday through Monday as I'm trying to do. Hmmmm. Robert
  2. TamedTech

    Count of records for past week.

    Hello Everyone, Thanks very much for all the discussion, I always find working with dates a bit of a mind bender so enjoy learning this stuff. It seems that when I run Select DateAdd(Week, DateDiff(Week, 0, GetDate()), 0) I do indeed seem to get Midnight on Monday of the current week. So...
  3. TamedTech

    Count of records for past week.

    Hello Guys, I have a query which looks like this: Select COUNT(SaleOrder_ID) AS ThisWeekCount From SaleOrder Where Placed IS NOT NULL And Placed >= DateAdd(Week, DateDiff(Week, 0, GetDate()), 0) I thought that this would count the number of sale orders placed in the...
  4. TamedTech

    Conditionals

    Perfect! Thanks a great deal Denis. Robert
  5. TamedTech

    Conditionals

    Hello Guys, I'm looking for a little advice on how to best form this query. I have three columns in a table, these are all 'int' datatypes and represent a 'state' for the record. ConfigState int EventState int MessageState int What I'm looking to achieve is a query which if the...
  6. TamedTech

    A time out occurred while...

    Hi Denny, Well, I underwent a memory upgrade on the system last night and its been running for the past 12 hours ot so and I've not yet recieved any errors from my applications or SQL Server which is an excelent sign, the server also seems much quicker and more responsive. Looks like that...
  7. TamedTech

    A time out occurred while...

    Thanks Denny, Perhaps my first port of call is to stick another GB or two of RAM in the box and see what happens, if that doesnt fix the issue then we can try again with somthing else. Cheers mate, Robert
  8. TamedTech

    A time out occurred while...

    Hello Guys, I've noticed some really slow performance on an application which is backed by a SQL Server database and it all seemed a little stange so thought I would take a look through the server logs, and it appears SQL Server is throwing a large number of error messages, all saying. This...
  9. TamedTech

    SQL 2k5 Database Migration

    Hi Denny, Just to let you know, this worked great, the DB is moved accross with no problems :-D Rob
  10. TamedTech

    SQL 2k5 Database Migration

    Really? Man that is sweet! I'll give it a shot over the weekend Denny and let you know how I get one. Thanks for the advice. Rob
  11. TamedTech

    SQL 2k5 Database Migration

    Hello Guys, I've got a couple of remote servers, both running win2k3 and SQL 2005 Workgroup. I'm looking to migrate one of my databases from one server to the next and thought I'd come and get some advice from you on the best way to do it. The database is currently sitting at around 7GB in...
  12. TamedTech

    Error 80092004

    Hi Denny, Thanks for getting back to me on this. Well, the first strange occurance is that I've come into the office this morning and SQL seems to have started up just fine :-s and my system also appears to be remembering all the passwords it had forgotton yesterday too :-s Out of interest...
  13. TamedTech

    Error 80092004

    As a little sidenote of informaiton, I found another forum with a thread for the exact same problem as I'm having, I've followed the steps to no avail. http://forums.microsoft.com/TechNet/ShowPost.aspx?PageIndex=1&SiteID=17&PageID=1&PostID=108800 Down near the bottom of that thread a guy...
  14. TamedTech

    Error 80092004

    Hello Guys, I've come into the office this morning to get spme work done and for some reason when trying to access my local SQL Express databases I get an error saying that connection is refused. So, I too a look at the running services on my system and noticed that SQL Express service hadnt...
  15. TamedTech

    Outlook 2k7 on Vista forgetting passwords

    Hello Guys, I've come into the office this morning and my Outlook 2k7 seems to have decided to start playing silly buggers with me. It wont remember the passwords for any of my pop accounts. I have done some googling around and found this tech note on the knowledge base which seems to describe...
  16. TamedTech

    Bluescreen On Boot

    Thanks for the information mate. What would you suggest my best plan of action is? as I'm unable to boot the system into windows and run any virus or malware scans, can I just delete the DLL from the recovery console? is that likely to cause me any problems? Thanks again, Rob
  17. TamedTech

    Bluescreen On Boot

    Hello Chaps, I've got a system here running XP which is blue screening on boot with the following error message: I've tried all the usual F8 boot options for safe mode and last known working configuration and those kind of things but keep running into the same error. I've also tried the...
  18. TamedTech

    Select, Modify & Insert Records

    Thanks guys, I've just run the version of the code with all those modifications and its worked perfectly. Thanks for all your input, its really appreciated. Rob
  19. TamedTech

    Select, Modify & Insert Records

    Haha! Thanks guys, glad to see I've got your scrapping with one another to get the answer. @ Woddy... this is fine, I dont want to append record, I do want to INSERT them, almost like a duplicate. @ George and Rudy, thanks for your help guys, so let me be sure of this... I need to use the ISO...
  20. TamedTech

    Select, Modify & Insert Records

    Hey Rudy, Thanks for the help mate, this looks to be along the right tracks, but it now looks as if its throwing an error at me. INSERT INTO MessageLog SELECT Device_ID , LogDateTime , LogClass_ID , Media_ID , Campaign_ID , 10 FROM MessageLog WHERE Unit_ID = 4 AND...

Part and Inventory Search

Back
Top