DECLARE @a INT

SELECT @a = 1

SELECT @a = -@a

SELECT @a

SELECT @a=-@a

SELECT @a

Note that @a*-1 doesn't change...

Sounds like you server is splitting the report over multiple sessions. By converting these to global temp tables you are now limiting it so that you CANNOT run more...

I must be missing something here. How are we updating tables that were deleted.

CREATE TABLE #x(a INT)

INSERT INTO #x(a) VALUES (10)

DROP TABLE #x

UPDATE #x

SET a=20

That doesn't work for me......

We upgraded to 2005 in July. Personally I wouldn't count on 2008 to be "Safe" until at least this time next year.

I don't know that I would wait...

Yes, this works. 🙂 Have fun.

You will need to create the view first, but I am sure you could even code that in too.

CREATE TABLE [view_config](

[view_name] [sysname] NOT...

The OP was to add the table name to a view. What was asked is NOT possible. However, the dynamic SQL is, and an alternate of it would...

I don't believe there is any way to do it with the interface. In the registry you can modify several default locations.

However, in most cases as I...

TheSQLGuru (10/10/2007)

---

I would recommend you look at the new Vostro 1700 model. I am LOVING mine - Core 2 Duo CPU, 2 hard drives, 4GB RAM and an awesome...

You can run the express edition on a laptop/desktop. But I strongly discourage this.

First. Laptops move and BREAK!

Second. Since you can't install a...

All of the suggestions to this point are good, except I have to also agree that yours is not.

I have no issues with Alpha or numeric keys if...

Can you post the name of the database? The reason is, I suspect that the issue has to do with the USE and the database name.

Try rather than ""...

Google Toolbar. Spell check, links from system to system.

I agree with everyone about using SQL to do formatting, but this will work

DROP TABLE #Doit

CREATE TABLE #Doit

(a INT IDENTITY,z INT)

go

INSERT INTO #Doit(z)

VALUES(NULL)

GO 50

SELECT '------------------

',a,'

-----------------'

FROM #Doit

SQL Server and Windows 2003 with only 1GB of RAM?

There is your problem....

You don't understand the difference here. Oracle has more functionality. Agreed! But is it a better product? I don't think so.

When I was an...