Allen,

Yep, I know they will appear in the Message window. That's what I want to happen. But they all appear at once, not as they occur in the WHILE statement.

I...

I think I figured it out.

Normally after clicking on Logout in the bar, it goes to the LOGOUT page. Then when LOGOUT is clicked it takes a short while, but...

Allen,

OOOPPPS. After running the query again and watching closely, the results are NOT being returned (PRINTed) until the WHILE exits. So, I'm beginning to think that when a WHILE is...

To add to this question:

I am querying data from a large amount of data. I want the number of events for each day for a month's time. My query (see...

Thanks Allen. I had tried the PRINT command but couldn't get it working correctly.

Should have thought about converting the int to varchar. Oh well...if we could think of everything there...

Do you mean the DATETIME datatype? Or do you mean the SQL Server TIMESTAMP?

TRANSACT-SQL TIMESTAMP is NOT the same as SQL-92 TIMESTAMP.

TRANSACT-SQL TIMESTAMP is a binary value which is used...

Did exactly what I wanted.

Thanks.

-SQLBill

Here's one problem with your script:

and Fname LIKE '%%%'

First, this selects ALL data from Fname.

Second, it overuses the %.

Are you trying to get everything from Fname?

If so, delete that line.

Are...

quote:

---

So, detach your databases.

Move them to another folder.

Uninstall the instance.

Move the database files back to their proper location.

Attach them.

Should work.

---

I don't see why it should since SQL uses (default) TCP 1433.

Check the BOL, use the INDEX tab and enter TCP/IP and select the sub-topic connecting to SQL Server.

-SQLBill

I suggest uninstalling and reinstalling the Client tools (Enterprise Manager) on your users machine.

-SQLBill

So, detach your databases.

Move them to another folder.

Uninstall the instance.

Move the database files back to their proper location.

Attach them.

Should work.

-SQLBill

I have found that when a job posting requires you to have worked in some field before, that usually means they want someone familiar with the type of data they...

If you are using DATE functions (DATEADD, DATEDIFF) or just comparing dates; you might not be able to CONVERT it to VARCHAR or CHAR.

So, I suggest the following:

CONVERT(DATETIME(CONVERT(VARCHAR(10),mydate,120)))

This will convert...

Soemthing else to check:

You will get an error if there are too many numbers to the left of the decimal.

For example: DECIMAL(9,3)

Will not accept:

1234567.123

You can only have 6 digits to...