can't query on 'Order Details' table in Northwind

Click here to monitor SSC

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>

SQLServerCentral is supported by Red Gate Software Ltd.

Log in :: Register :: Not logged in

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>

Recent Posts

Popular Topics

Home

Home » SQL Server 7,2000 » General » can't query on 'Order Details' table in...

Add to briefcase

can't query on 'Order Details' table in Northwind

Expand / Collapse

Author

Message

VIJAYA SATISH KUMAR BODAPATI

Posted Monday, October 29, 2007 8:41 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, September 22, 2010 7:22 AM
Points: 9, Visits: 18

Hi all

I faced a problem when using Northwind sample Database. On of the table in the database is 'Order Details'. I am unable to query on the table because of the space in the name ('Order' 'Details') of the table. When I remove the space in the name, the reports associated in Cognos are not working properly. Let me know whether there is any purpose to put the name like that and if I want to see the data in query mode how it is possible.

Thanks in advance
Satish

Post #416045

Andras Belokosztolszki

Posted Monday, October 29, 2007 8:55 AM

Ten Centuries

Group: General Forum Members
Last Login: Thursday, January 26, 2012 5:26 AM
Points: 1,367, Visits: 1,585

put brackets around the name, like:
[Order Details]

Regards,
Andras

Andras Belokosztolszki, MCPD, PhD
GoldenGate Software

Post #416053

VIJAYA SATISH KUMAR BODAPATI

Posted Monday, October 29, 2007 9:38 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, September 22, 2010 7:22 AM
Points: 9, Visits: 18

Thank you friend. You helped me to resolve my problem

-Satish

Post #416078

« Prev Topic | Next Topic »

Add to briefcase

Permissions

Expand / Collapse