"Name" Data Type?

Standard apologies for the extreme "newbie" nature of this question...
I've just seen a batch of sample code with the following declaration:
DECLARE @.MyVar Name
"@.MyVar", in this case, is there to receive some string data from an OPENXML
operation. The contents of the variable are subsequently used to feed other
functions that take varchar's as arguments. This works successfully.
The problem is, I've never heard of a "Name" before -- I can't CAST it to
anything useful, nor can I successfully concatenate it with a "+" operator t
o
other string data. I don't believe it is actually a data type, but I'm afrai
d
I don't know what it is, and because of what it's called it's darned hard to
look up in BOL!
Any insight would be greatly appreciated. Thanks!Dan,
A user-defined data type?
Try:
EXEC sp_datatype_info
GO
--and
EXEC sp_help
GO
HTH
Jerry
"Dan Costello" <DanCostello@.discussions.microsoft.com> wrote in message
news:C4A7366D-A8D9-4AE7-90D5-AF1E9CEDC847@.microsoft.com...
> Standard apologies for the extreme "newbie" nature of this question...
> I've just seen a batch of sample code with the following declaration:
> DECLARE @.MyVar Name
> "@.MyVar", in this case, is there to receive some string data from an
> OPENXML
> operation. The contents of the variable are subsequently used to feed
> other
> functions that take varchar's as arguments. This works successfully.
> The problem is, I've never heard of a "Name" before -- I can't CAST it to
> anything useful, nor can I successfully concatenate it with a "+" operator
> to
> other string data. I don't believe it is actually a data type, but I'm
> afraid
> I don't know what it is, and because of what it's called it's darned hard
> to
> look up in BOL!
> Any insight would be greatly appreciated. Thanks!|||Jerry,
Well, now I feel really stupid! Thanks, that's got it. For the sake of
completeness, the sample code uses the "AdventureWorks" sample database,
which does in fact have a user-defined type called "Name" already in it.
--Dan
"Jerry Spivey" wrote:

> Dan,
> A user-defined data type?
> Try:
> EXEC sp_datatype_info
> GO
> --and
> EXEC sp_help
> GO
> HTH
> Jerry
> "Dan Costello" <DanCostello@.discussions.microsoft.com> wrote in message
> news:C4A7366D-A8D9-4AE7-90D5-AF1E9CEDC847@.microsoft.com...
>
>

"Name" Data Type?

Standard apologies for the extreme "newbie" nature of this question...
I've just seen a batch of sample code with the following declaration:
DECLARE @.MyVar Name
"@.MyVar", in this case, is there to receive some string data from an OPENXML
operation. The contents of the variable are subsequently used to feed other
functions that take varchar's as arguments. This works successfully.
The problem is, I've never heard of a "Name" before -- I can't CAST it to
anything useful, nor can I successfully concatenate it with a "+" operator to
other string data. I don't believe it is actually a data type, but I'm afraid
I don't know what it is, and because of what it's called it's darned hard to
look up in BOL!
Any insight would be greatly appreciated. Thanks!Dan,
A user-defined data type?
Try:
EXEC sp_datatype_info
GO
--and
EXEC sp_help
GO
HTH
Jerry
"Dan Costello" <DanCostello@.discussions.microsoft.com> wrote in message
news:C4A7366D-A8D9-4AE7-90D5-AF1E9CEDC847@.microsoft.com...
> Standard apologies for the extreme "newbie" nature of this question...
> I've just seen a batch of sample code with the following declaration:
> DECLARE @.MyVar Name
> "@.MyVar", in this case, is there to receive some string data from an
> OPENXML
> operation. The contents of the variable are subsequently used to feed
> other
> functions that take varchar's as arguments. This works successfully.
> The problem is, I've never heard of a "Name" before -- I can't CAST it to
> anything useful, nor can I successfully concatenate it with a "+" operator
> to
> other string data. I don't believe it is actually a data type, but I'm
> afraid
> I don't know what it is, and because of what it's called it's darned hard
> to
> look up in BOL!
> Any insight would be greatly appreciated. Thanks!|||Jerry,
Well, now I feel really stupid! Thanks, that's got it. For the sake of
completeness, the sample code uses the "AdventureWorks" sample database,
which does in fact have a user-defined type called "Name" already in it.
--Dan
"Jerry Spivey" wrote:
> Dan,
> A user-defined data type?
> Try:
> EXEC sp_datatype_info
> GO
> --and
> EXEC sp_help
> GO
> HTH
> Jerry
> "Dan Costello" <DanCostello@.discussions.microsoft.com> wrote in message
> news:C4A7366D-A8D9-4AE7-90D5-AF1E9CEDC847@.microsoft.com...
> > Standard apologies for the extreme "newbie" nature of this question...
> >
> > I've just seen a batch of sample code with the following declaration:
> >
> > DECLARE @.MyVar Name
> >
> > "@.MyVar", in this case, is there to receive some string data from an
> > OPENXML
> > operation. The contents of the variable are subsequently used to feed
> > other
> > functions that take varchar's as arguments. This works successfully.
> >
> > The problem is, I've never heard of a "Name" before -- I can't CAST it to
> > anything useful, nor can I successfully concatenate it with a "+" operator
> > to
> > other string data. I don't believe it is actually a data type, but I'm
> > afraid
> > I don't know what it is, and because of what it's called it's darned hard
> > to
> > look up in BOL!
> >
> > Any insight would be greatly appreciated. Thanks!
>
>

"Design Storage and Process the Cube" issue

To anyone who can help,
I am reviewing the processes in the Analysis Manager, and I am going
through the sample exercises offered by SQL Server's Analysis Manager Help.
So far, every step has been successful, but now I am running into a
problem. If you have the Analysis Manager installed, you should be able to
follow this directory to see the instructions I am following.
C:\Program Files\Microsoft Analysis
Services\Help80\Tutorial\design_stor_pro
c.htm
When I attempt to process the design storage to set the aggregations, it
is failing. I get the following error for why the process has failed:
[Microsoft][ODBC Driver Manager] Data source name not found and no d
efault
driver specified;IM002; Time:8/26/2004 5:25:00 PM
If you understand why this is happening, I would appreciate any tips. If I
go to redo the process it does show that I already have aggregates for the
cube. Does that mean it actually worked, or am I correct in my assumption
that the error is pointing to a problem that I need to resolve. Thanks for
any information!
CourtneyHi
Did u manage 2 fix the problem?
Udi
"Courtney Fay" wrote:

> To anyone who can help,
> I am reviewing the processes in the Analysis Manager, and I am going
> through the sample exercises offered by SQL Server's Analysis Manager Help
.
> So far, every step has been successful, but now I am running into a
> problem. If you have the Analysis Manager installed, you should be able t
o
> follow this directory to see the instructions I am following.
> C:\Program Files\Microsoft Analysis
> Services\Help80\Tutorial\design_stor_pro
c.htm
> When I attempt to process the design storage to set the aggregations,
it
> is failing. I get the following error for why the process has failed:
> [Microsoft][ODBC Driver Manager] Data source name not found and no
default
> driver specified;IM002; Time:8/26/2004 5:25:00 PM
> If you understand why this is happening, I would appreciate any tips. If
I
> go to redo the process it does show that I already have aggregates for the
> cube. Does that mean it actually worked, or am I correct in my assumption
> that the error is pointing to a problem that I need to resolve. Thanks fo
r
> any information!
> Courtney
>
>

"Design Storage and Process the Cube" issue

To anyone who can help,
I am reviewing the processes in the Analysis Manager, and I am going
through the sample exercises offered by SQL Server's Analysis Manager Help.
So far, every step has been successful, but now I am running into a
problem. If you have the Analysis Manager installed, you should be able to
follow this directory to see the instructions I am following.
C:\Program Files\Microsoft Analysis
Services\Help80\Tutorial\design_stor_proc.htm
When I attempt to process the design storage to set the aggregations, it
is failing. I get the following error for why the process has failed:
[Microsoft][ODBC Driver Manager] Data source name not found and no default
driver specified;IM002; Time:8/26/2004 5:25:00 PM
If you understand why this is happening, I would appreciate any tips. If I
go to redo the process it does show that I already have aggregates for the
cube. Does that mean it actually worked, or am I correct in my assumption
that the error is pointing to a problem that I need to resolve. Thanks for
any information!
Courtney
Hi
Did u manage 2 fix the problem?
Udi
"Courtney Fay" wrote:

> To anyone who can help,
> I am reviewing the processes in the Analysis Manager, and I am going
> through the sample exercises offered by SQL Server's Analysis Manager Help.
> So far, every step has been successful, but now I am running into a
> problem. If you have the Analysis Manager installed, you should be able to
> follow this directory to see the instructions I am following.
> C:\Program Files\Microsoft Analysis
> Services\Help80\Tutorial\design_stor_proc.htm
> When I attempt to process the design storage to set the aggregations, it
> is failing. I get the following error for why the process has failed:
> [Microsoft][ODBC Driver Manager] Data source name not found and no default
> driver specified;IM002; Time:8/26/2004 5:25:00 PM
> If you understand why this is happening, I would appreciate any tips. If I
> go to redo the process it does show that I already have aggregates for the
> cube. Does that mean it actually worked, or am I correct in my assumption
> that the error is pointing to a problem that I need to resolve. Thanks for
> any information!
> Courtney
>
>