Ravi

What I would do is use a SELECT statement with ORDER BY EmployeeID at the end and let my front end do the presentation of the data.  If you have...

This excellent article on hierarchies should help you.

John

Vladan

The previous invoice won't be for another customer, because the data in the temp table is ordered by customer.  Have I overlooked something?

John

Hemant

First, a couple of comments on your table design.  If CustomerCode is just that, then varchar(50) is probably a bit much, especially if you are using that column to join...

DAB

Now that you're up to 16GB, have you removed the /3GB switch from your boot.ini file?

You should expect to see a low cache hit ratio soon after the server is...

Yes, a linked server is the way to go if you're going to do it regularly - although there are also ways of running ad hoc queries without creating a...

Michelle

I don't know anything about Litespeed, I'm afraid, but here, off the top of my head, is how I'd go about moving the databases.

(1) Back up all databases in case...

 "The only unique key on the tab1 is the primary key... I have checked all other col's on the table but none are unique."

You have two unique constraints on the...

Arun

Sergiy is quite right, of course.  Now, to answer your question... the following should work.  Somebody might be able to think of something more concise.  It should work no matter...

The procedure for moving tempdb data and/or log files is different from the procedure for user databases.  You need to use the ALTER DATABASE statement, if I remember correctly.  There...

Tryst

Yes, so long as it as simple as switching two values over.  Obviously if the values were 13 and 28, say, then you'd need to think about how you would...

Michael

You will find a table with the meanings of the columns in Books Online.  For your report, I think you will need to create your own lookup tables with this...

Tryst

Here's a way of doing it without a CASE statement

TABLE #MyTable (TableID int,...

I would set it to the size of the disk (assuming you don't use the disk for anything else) and then leave it.  Make sure you grow the file out...

Richard

More information, please.  Is it all the indexes on this table, and if so have you rebuilt them all, including the clustered index (if there is one)?  How do you...