So I had a hard time finding where your loop started, so I can't give you details on why its happening. However I can give you a tried and true method to find the issue (its worked for over 30 years for me)
Take a few sheets of paper and write down what you "expect" to happen in plain English.
Then write down the algorithm your code is following in plain English.
Compare - figure out the mis-match, you may need to search vendor docs to find the "gotcha"
Still no luck finding out whats going wrong?
Take a small record set and run it through your written algorithm.
99.9999% of the time this method works!
Hope everyone is doing great!!!.
I am new to this group so any mistake in posting, i am sorry.
I have a scenario, We have 5000+ scheduled jobs in the scheduler tool and the back end for that tool is sql server. We are manually monitring the job status and failuers which is taking huge efforts.
For automating the monitoring process, we want to have Stored procedure which can be triggered when there is failure or status of jobs ran for every hour. I need help as how to have body of the message for reporting the job status and run times.
I got the SP, but how to get the body of the message is what i am stuck with. Below is link from where i check the code.
I suggest you get someone to help with your english first. The question needs some interpreting.
The forum does not supply service so the someone is not going to happen.
Converting between databases will depend on the vendor of the database so know which source and target database is going to help us help you. http://www.sqlservercentral.com/[^] is another good resource for SQL Server and all the big vendors have similar support sites.
Never underestimate the power of human stupidity
I'm looking for a database where I can directly send / receive TCP/IP commands to do manipulate the database with SQL commands. I doubt that there is anything like that out there since my Google searches didn't turn anything up, but I'm asking here in case I'm missing something...
I will never again mention that Dalek Dave was the poster of the One Millionth Lounge Post, nor that it was complete drivel.
I was thinking about something that needs a previous authentication, and then SQL commands can be sent...
Which is how every database that uses SQL works.
The MS SQL Server Management Studio manages the server which is not and cannot be the same as managing a database. Same is true of tools like sqlplus, Toad, MySQL Workbench, etc. One can use those to process SQL but other functionality cannot be controlled via SQL (because that isn't what SQL does.)
we r developing visitor tracking system,when avisitor come giving a card and he swips and enters inside ,when he releaving handovers the card to watchmen.after that there is a chance same card can be given to someother visitor.
mysql table is not having primary key.
table is like this: