No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
12 Posted Topics
[QUOTE=hcarroll08;1150694]i have tried all i know how to do! i have a wireless router for my desk top and i have a connection on my laptop but can not get it to browse the internet. what should i do?[/QUOTE] I have had this problem a few times too and the …
Lately my computer has been getting slower by the day. Attached are images of the 'Processes' tab in the task mgr. Image 1: List of processes sorted by CPU Image 2: List sorted by Memory Usage If you look at image 1, the System Idle Process CPU Usage = 92%. …
[QUOTE=j30rider;1143587]I like to watch a lot of movies online. Well used to anyways. ........ I have noticed when I logon to Firefox/IE the computer runs at 100% and that's before I even try to watch a movie.....[/QUOTE] I have had this exact same problem the past week. Check this thread …
One of the UPDATE queries I am trying to run is not quite working the way I want it to. I know this query is the culprit, but can't quite figure out how to fix it! Here's the story: ------------------------------------------------------- I have 3 tables: let's call them tblUsers, tblDueVisits and …
I have a table in which I have an auto-increment int ID column. Can I set this column to pad the zeroes at the beginning so as to store them as, say, 0001 instead of 1, 0002 instead of 2, and so on? Subsequently, when the table reaches 10 entries, …
The title to the thread pretty much describes what I am getting stuck at. I was able to create a procedure successfully, but everytime I try to execute it, I get an error:[QUOTE]The EXECUTE permission was denied on the object 'sp_OACreate', database 'mssqlsystemresource', schema 'sys'.[/QUOTE] Logically speaking, if the DB …
What is the best way to update a record when 2 users of my site happen to edit it simultaneously? For example, assume the following scenario: Let's say users John Doe and Jane Doe log into my site and happen to view the below record simultaneously. --------------------------------------------------------------------------------- Bruce Wayne | …
Not quite sure whether this is a question for the server side programming forum or for SQL forum. Nevertheless, here it is: What is the best way to update a record when 2 users of my site happen to edit it simultaneously? For example, assume the following scenario: Let's say …
I have been reading up quite a bit on the topic of Stored Procedures (SPs) and keep coming across contradicting opinions from various 'SQL experts' on whether or not they should be used. Sometimes it's a downright 'No' ([I]Frans Bouma's[/I] Blog for example -- google the term for the article), …
I have a table that has various rows of data grabbed from a table in my DB. 3 of the columns display the queried data. The last column, however, contains text fields for the user to hand-enter values. When the user hits the Submit button, all of the values entered …
Can someone please help me figure out what I am doing wrong? Basically I have a form where users enter a bunch of values. On submit, the form values are dumped into a table in the DB. The process is as follows: Users enter a set of values TWICE for …
I have a query similar to the original poster's, so I thought I might post it here. I want to do exactly what he/she is trying to- the only difference being that my data comes from 2 different tables. The date and time columns that correspond to the 'StartedOn' and …
The End.
SQL_n00b