I'm not quite sure what you are asking, but...

if you do a DBCC DBREINDEX it drops and recreates the indexes. This gets rid of any fragmentation of the indexes. However,...

How is the time stored? If it's as varchar forget it. VARCHAR is a string value and strings are ordered (sorted) alphanumerically.

1

10

11

2

20

25

3

This is why dates and times should always be...

It's my opinion you don't need that immediate transaction log and can turn it off.

Most likely, the person who set it up did it as a 'fail safe'. A lot...

Even degaussing the tape won't return it to it's 'new out of the box' state. If you really need a 'new out of the box' tape, you'll have to buy...

The problem is that you are trying to RESTORE a database that already exists. It can be done, but you must use the WITH REPLACE option.

Refer to the BOL for...

I think this script shows the 'fine line' with the word EXECUTE. Parsing a script is not executing it. Another word might be COMPILE.

EXECUTING it is running the script.

Look...

I should have added that you are better off doing:

SET @var1 = 'Hello'

SET @var2 = SELECT col1 FROM table

SELECT @var1, @var2

And don't forget to DECLARE the variables at the beginning.

-SQLBill

Where did you get this from?

Select [var1] = ‘Hello’,[var2] = t.col1

from table t

I have never seen anything...

Sudhir,

I agree with Frank and disagree with you. The answer is NOT 33.00.  If both numbers are INT as you show them, the answer will be INT. INT does not...

In answer to your question....NO there is no simple query that would return what you want. Why not? Because of the poor data.

You can't ask for LIKE %HYATT GRAND%...

Another solution and one that I use:

Create a stored procedure on SQL Server that does what you want. Make sure it has the variables you want entered via Crystal Reports....

Lee,

To answer your question "Is there any way to keep it as a date or datetime value?" - No. In SQL Server there isn't a DATE datatype only DATETIME and...

To add to Peter's comments, even if you shrink the files it doesn't happen immediately.

You are better off allowing the TL to grow. Continuing to back it up and run...

This is why you shouldn't rely on Maintenance plans. Script your own backup jobs.

-SQLBill

Did you provide the license information when you installed it? (I know this might be a dumb question, but if you leave out the license information the evaluation version is installed).

-SQLBill