Search results for query: *

Hi guys what is the best way to prevent multiple users logging in using the same username/password --Can we guarantee this using the session --Is it better to do storing the sessionid in the database --any other thoughts would be great. Thanks

Hello all, i am Creating New EmployeeId in the Employees table using this statement. BEGIN TRAN INSERT INTO Employees(EmployeeId,) SELECT 1 + COALESCE(MAX(EmployeeId), 0) FROM EMPLOYEES COMMIT TRAN Is there any way i should store this newly created EmployeeId in a local variable so that...

Hi gurus I have two tables users(userid int,name varchar(50)) userclass(classid int,name varchar(50)) I want to make sure these two tables should never have same id's Why i need this is i want to find whether a given id is actually a classid or just userid. If it is a classid then i...

hi experts, can any one give me a thought how can we write a stored procedure which loops through the records. the basic purpose i need this query is to update each record with a new value by looping the records.. thanks for any help

Hi this query returns the following data(all the conflicting bookings) vongrunt and jonwolds helped me to write this query now i need to extend this query.. select B1.BookingId,B1.start,B1.Finish from Bookings B1 where exists ( select BookingId from Bookings B2 where B1.Bookingid <>...

this query gets me all the overlap booking dates select BookingId,convert(varchar(10),b1.Start,120) Stdate,convert(varchar(5),b1.Start,108) StTime,convert(varchar(5),b1.Finish,108) edtime from Bookings b1 where exists ( select BookingId from Bookings b2 where b1.Bookingid <>...

is there any way of simulating vb like attaching vscrollbar to textbox using javascript i wanted to do this for one of my datetime control which needs to increment or decrement time when you click on buttons.. here i am giving a bit more explanation what i am looking for i have 4 text boxes...

Hi can any one please guide me where to look for resources to learn paint shop pro..currently i have jasc paint shop pro. if any one know any free online audio tutorials or any good website to learn paint shop pro please do let me know. thanks

Hi i have written a stored procedure using cursor.I know we should avoid using cursors whenever possible.I think this sp could be written without using cursor but have no clue. any help will be appreciable. here is my original sp..hope this could explain the problem.. declare c1 cursor local...

Hi i am looking for an sql statement which returns the overlapping date ranges here is the data in my table bookingid start finish 1001 2004/10/11 08:00 2004/10/11 17:30 1002 2004/10/11 09:00 2004/10/11 14:30 1003 2004/10/11 10:00...