IF EXISTS (Select * from dbo.SysObjects where name = 'Numbers' and XType = 'U' and user_name(uid) = 'dbo')

 DROP TABLE Numbers

GO

CREATE TABLE dbo.Numbers (PkNumber int identity(1,1) primary key clustered, dude bit...

dbcc inputbuffer (@@spid)

But I think it must be executed by another process... because the last line executed will then become "dbcc inputbuffer (@@spid)"

What bug are you trying to track?

Don't use on production server :

DBCC FREEPROCCACHE

DBCC DROPCLEANBUFFERS

You really don't need to do this in sql server (unless dealing with millions of rows and multiple tables).  You can use a derived table to get the results in...

Alright, good luck with that.

You do something like this.  The total is kept in the wage table (assuming you are using a "standard" table design).  The total is counted from the TimeSheets table and kept in...

Can you try to explain what you need in more details... I have no idea where you are having difficulties.

Depends on what you do with the data.  Normally you simply calculate that information and display it to the user.  However if you have for exemple a Wage table, then...

Can't help much... don't have 2005 installed here.

Much simpler than what you think.

Store a start date and end date in sql server.

Then the calculation becomes this :

Select datediff(N, StartDate, EndDate) / 60.0 AS Hours

Ya that's why I wsa excited about the solution, it was exactly what you needed.  But I was reffering to a more global solution where you could need to 95th...

This should answer it :

DECLARE @a int, @b-2 int, @c int, @d int

Select @a = 1, @b-2 = @a + 1, @c = @b-2 + 1, @d = @c...

Can you then explain me why I am getting a null with this query??

SELECT PARSENAME(REPLACE('1,2,3,4,5,6,7,8,9,10',',','.'),5)

IF EXISTS (SELECT * FROM dbo.SysObjects WHERE Name = 'Events' AND XType = 'U' AND USER_NAME (uid) = 'dbo')

       DROP TABLE dbo.Events

GO

CREATE TABLE dbo.Events

(

       EventID INT  

Lol, that's what I get for talking without testing .