Derived Table

I have created SQL using a Derived Table. Obviously, there's a method for my
madness here and it has been a while since I've used a derived table. I am
testing portions of my query and I am having a problem with the following
SQL...getting the following error message...
Server: Msg 8155, Level 16, State 2, Line 1
No column was specified for column 6 of 'drvtbl'.
And here's the SQL...
SELECT drvtbl."loan_id",
drvtbl."corr_name",
drvtbl."corr_address_1",
drvtbl."corr_city",
drvtbl."corr_state",
drvtbl."corr_zip",
drvtbl."misc_field_value"
FROM (SELECT ms_address_information."loan_id",
ms_address_information."corr_name",
ms_address_information."corr_address_1",
ms_address_information."corr_city",
ms_address_information."corr_state",
CAST(ms_loan_misc_fields."misc_field_value" AS CHAR(15))
FROM { oj "fics"."dbo"."ms_address_information" ms_address_information
LEFT OUTER JOIN "fics"."dbo"."ms_loan_misc_fields" ms_loan_misc_fields
ON ms_address_information."loan_id" = ms_loan_misc_fields."loan_id"
AND ms_loan_misc_fields."misc_field_id" = 10079}) drvtbl
Can anyone help me out here and tell me why I am getting an error message on
this?
Thanks for your help!give your column an alias
i.e.
SELECT drvtbl."loan_id",
drvtbl."corr_name",
drvtbl."corr_address_1",
drvtbl."corr_city",
drvtbl."corr_state",
drvtbl."corr_zip",
miscField
FROM (SELECT ms_address_information."loan_id",
ms_address_information."corr_name",
ms_address_information."corr_address_1",
ms_address_information."corr_city",
ms_address_information."corr_state",
CAST(ms_loan_misc_fields."misc_field_value" AS CHAR(15)) as miscField
FROM { oj "fics"."dbo"."ms_address_information" ms_address_information
LEFT OUTER JOIN "fics"."dbo"."ms_loan_misc_fields" ms_loan_misc_fields
ON ms_address_information."loan_id" = ms_loan_misc_fields."loan_id"
AND ms_loan_misc_fields."misc_field_id" = 10079}) drvtbl
"wnfisba" wrote:

> I have created SQL using a Derived Table. Obviously, there's a method for
my
> madness here and it has been a while since I've used a derived table. I am
> testing portions of my query and I am having a problem with the following
> SQL...getting the following error message...
> Server: Msg 8155, Level 16, State 2, Line 1
> No column was specified for column 6 of 'drvtbl'.
> And here's the SQL...
> SELECT drvtbl."loan_id",
> drvtbl."corr_name",
> drvtbl."corr_address_1",
> drvtbl."corr_city",
> drvtbl."corr_state",
> drvtbl."corr_zip",
> drvtbl."misc_field_value"
> FROM (SELECT ms_address_information."loan_id",
> ms_address_information."corr_name",
> ms_address_information."corr_address_1",
> ms_address_information."corr_city",
> ms_address_information."corr_state",
> CAST(ms_loan_misc_fields."misc_field_value" AS CHAR(15))
> FROM { oj "fics"."dbo"."ms_address_information" ms_address_informatio
n
> LEFT OUTER JOIN "fics"."dbo"."ms_loan_misc_fields" ms_loan_misc_fields
> ON ms_address_information."loan_id" = ms_loan_misc_fields."loan_id"
> AND ms_loan_misc_fields."misc_field_id" = 10079}) drvtbl
>
> Can anyone help me out here and tell me why I am getting an error message
on
> this?
> Thanks for your help!
>

Deploying to a folder?

Is there any method to deploy a report to a folder under the project's
folder? I currently deploy new reports from within VS.NET and manually move
them to their correct folders using the "move" button on the
http://servername/reports/pages/folder.aspx?IsDetailsView=True web page. Is
there anyway to setup the sub folders in VS.NET?
--
Jeff Lynch
"A BizTalk Enthusiast"
http://codebetter.com/blogs/jeff.lynchHello Jeff,
Based on my scope, there is no official method to change the subfolder
path. The catalog information is stored in catalog table in ReportServer
database.
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
| From: "Jeff Lynch" <jeff.lynch@.newsgroup.nospam>
| Subject: Deploying to a folder?
| Date: Mon, 18 Apr 2005 08:10:04 -0500
| Lines: 12
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2527
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527
| X-RFC2646: Format=Flowed; Original
| Message-ID: <OlXjwfBRFHA.996@.TK2MSFTNGP09.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: gateway.gulfcoastseal.com 65.212.192.66
| Path:
TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP0
9.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.reportingsvcs:47959
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| Is there any method to deploy a report to a folder under the project's
| folder? I currently deploy new reports from within VS.NET and manually
move
| them to their correct folders using the "move" button on the
| http://servername/reports/pages/folder.aspx?IsDetailsView=True web page.
Is
| there anyway to setup the sub folders in VS.NET?
|
| --
| Jeff Lynch
| "A BizTalk Enthusiast"
| http://codebetter.com/blogs/jeff.lynch
|
|
|