Kind of cross-tab query

Hi
I'd like to get the results below from this sort of data. I might also have
additional tables that need another 'prods' type column.
Thanks
Andrew
declare @.docs table (docID int primary key, docname varchar(25))
declare @.prods table (prodID int primary key, docID int, prodname
varchar(25))
insert @.docs values (1, 'doc1')
insert @.docs values (2, 'doc2')
insert @.docs values (3, 'doc3')
insert @.prods values (1, 1, 'prod1')
insert @.prods values (2, 2, 'prod2')
insert @.prods values (3, 1, 'prod3')
insert @.prods values (4, 2, 'prod4')
insert @.prods values (5, 3, 'prod5')
insert @.prods values (6, 2, 'prod6')
/*
docID docname prods
-- -- --
1 doc1 prod1, prod3
2 doc2 prod2, prod4, prod6
3 doc3 prod5
*/In general, a recommended approach is to extract the resultset outside the
server and massage the data to appropriate display format using some client.
Regarding the workarounds for forcing this at the server, you can check out
the following links:
( For SQL 2005 only )
http://groups.google.com/group/micr...br />
9b9b968a
( For SQL 2000 & 2005 )
http://groups.google.com/group/micr...br />
6dd9e73e
Anith|||For all types of static and dynamic crosstabs server side it's recommended
you check out RAC.Powerful and easy.
www.rac4sql.net

Kind Attention: MSFT

Hi,
The below issue is frustrating me as I have posted it
couple of times on this news group but didnt received a
single response.Atleast this time I expect a response from
MSFT online personnels.
I have a SBS 2003 5 CAL . I want to use SQL Server on top
of it in production, I prefer to use SQL Server based on
the available CPU's on my system. But I am confused
thinking, In what way SQL Server Licencing restrictions
are applicable as it is bundled along with SBS.
Thanks for the help!
Regards
ChipQ. Is it possible to install the server applications included with
Windows Small Business Server 2003 on a different computer running Windows
Server? For example, I want to run SQL Server on the computer running
Windows Small Business Server 2003, but I want to run Exchange Server 2003
on a different computer.
A. No. The server applications that come with the product must be
installed on the same physical machine, if they are installed at all. The
only exception is that FrontPage 2003, which is included with the premium
edition, may be installed on a single client computer in the Windows Small
Business Server 2003 network.
direct from MS web site
http://www.microsoft.com/windowsser...iew/generalfaq.
mspx
Neil MacMurchy
"Chip" <chipsin007@.yahoo.com> wrote in message
news:1b1401c3fc0d$62f56690$a301280a@.phx.gbl...
> Hi,
> The below issue is frustrating me as I have posted it
> couple of times on this news group but didnt received a
> single response.Atleast this time I expect a response from
> MSFT online personnels.
> I have a SBS 2003 5 CAL . I want to use SQL Server on top
> of it in production, I prefer to use SQL Server based on
> the available CPU's on my system. But I am confused
> thinking, In what way SQL Server Licencing restrictions
> are applicable as it is bundled along with SBS.
> Thanks for the help!
> Regards
> Chip
>|||Hi Neil,
Thanks for trying to help me, but if u read my post
clearly I was talking about installing the SQL Server on
the Same SBS 2003 Edition and am concerned about Licensing
Issues with SQL Server 2000 on SBS 2003.
I am going mad with this Issue.
Regards
Chip
>--Original Message--
> Q. Is it possible to install the server
applications included with
>Windows Small Business Server 2003 on a different
computer running Windows
>Server? For example, I want to run SQL Server on the
computer running
>Windows Small Business Server 2003, but I want to run
Exchange Server 2003
>on a different computer.
> A. No. The server applications that come with the
product must be
>installed on the same physical machine, if they are
installed at all. The
>only exception is that FrontPage 2003, which is included
with the premium
>edition, may be installed on a single client computer in
the Windows Small
>Business Server 2003 network.
>
> direct from MS web site
>http://www.microsoft.com/windowsser...sbs/techinfo/ov
erview/generalfaq.
>mspx
> Neil MacMurchy
>
>"Chip" <chipsin007@.yahoo.com> wrote in message
>news:1b1401c3fc0d$62f56690$a301280a@.phx.gbl...
from
top
>
>.
>|||you might have better luck in the microsoft.public.smallbiz.sbsisp group.
My guess however is still a big nope. Since the SBS server is licensed per
seat, I don't think this would allow the SQL portion to be licensed per
processor as they apps are licensed as a bundle. I realize that if you
wanted to use this to allow anonymous SQL access (Internet) you need to use
per processor licensing but this is not the intent of this product (to my
knowledge).
Best bet would be to call MS. A regional sales rep can usually clear away
the licensing confusion that most MS products have
Neil
"Chip" <chipsin007@.yahoo.com> wrote in message
news:1daa01c3fc20$06faab30$a301280a@.phx.gbl...
> Hi Neil,
> Thanks for trying to help me, but if u read my post
> clearly I was talking about installing the SQL Server on
> the Same SBS 2003 Edition and am concerned about Licensing
> Issues with SQL Server 2000 on SBS 2003.
> I am going mad with this Issue.
> Regards
> Chip
> applications included with
> computer running Windows
> computer running
> Exchange Server 2003
> product must be
> installed at all. The
> with the premium
> the Windows Small
> erview/generalfaq.
> from
> top|||Hi Neil,
Thank you very much for ur views and suggestions. I will
contact the Local Microsoft office. But I am surprised of
one thing. How come no Microsoft guy tried to answer my
query even after I put the Attention Note in subject.
Anyway Have a nice time.
Regards
Chip
>--Original Message--
>you might have better luck in the
microsoft.public.smallbiz.sbsisp group.
>My guess however is still a big nope. Since the SBS
server is licensed per
>seat, I don't think this would allow the SQL portion to
be licensed per
>processor as they apps are licensed as a bundle. I
realize that if you
>wanted to use this to allow anonymous SQL access
(Internet) you need to use
>per processor licensing but this is not the intent of
this product (to my
>knowledge).
>Best bet would be to call MS. A regional sales rep can
usually clear away
>the licensing confusion that most MS products have
>Neil
>"Chip" <chipsin007@.yahoo.com> wrote in message
>news:1daa01c3fc20$06faab30$a301280a@.phx.gbl...
Licensing
included
in
>http://www.microsoft.com/windowsser...sbs/techinfo/ov
received a
based on
restrictions
>
>.
>|||"Chip" <anonymous@.discussions.microsoft.com> wrote in message
news:2a0701c3fc90$f2d9dc40$a101280a@.phx.gbl...
> Hi Neil,
> Thank you very much for ur views and suggestions. I will
> contact the Local Microsoft office. But I am surprised of
> one thing. How come no Microsoft guy tried to answer my
> query even after I put the Attention Note in subject.
> Anyway Have a nice time.
In short, because we're not lawyers and we've been told that because we're
not lawyers we're not to dispense legal advice. :-( On top of that, there
simply may not be any Microsoft employees reading this newsgroup who know
the answer. I know I sure don't. Neil is right, your best bet is to contact
your local sales office.
Oh, and please note that while this is a Microsoft-hosted newsgroup, unless
you're a subscriber to technet or MSDN there's no guarantee of a response.
Sorry!
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.

Kind Attention: MSFT

Hi,
The below issue is frustrating me as I have posted it
couple of times on this news group but didnt received a
single response.Atleast this time I expect a response from
MSFT online personnels.
I have a SBS 2003 5 CAL . I want to use SQL Server on top
of it in production, I prefer to use SQL Server based on
the available CPU's on my system. But I am confused
thinking, In what way SQL Server Licencing restrictions
are applicable as it is bundled along with SBS.
Thanks for the help!
Regards
ChipQ. Is it possible to install the server applications included with
Windows Small Business Server 2003 on a different computer running Windows
Server? For example, I want to run SQL Server on the computer running
Windows Small Business Server 2003, but I want to run Exchange Server 2003
on a different computer.
A. No. The server applications that come with the product must be
installed on the same physical machine, if they are installed at all. The
only exception is that FrontPage 2003, which is included with the premium
edition, may be installed on a single client computer in the Windows Small
Business Server 2003 network.
direct from MS web site
http://www.microsoft.com/windowsserver2003/sbs/techinfo/overview/generalfaq.
mspx
Neil MacMurchy
"Chip" <chipsin007@.yahoo.com> wrote in message
news:1b1401c3fc0d$62f56690$a301280a@.phx.gbl...
> Hi,
> The below issue is frustrating me as I have posted it
> couple of times on this news group but didnt received a
> single response.Atleast this time I expect a response from
> MSFT online personnels.
> I have a SBS 2003 5 CAL . I want to use SQL Server on top
> of it in production, I prefer to use SQL Server based on
> the available CPU's on my system. But I am confused
> thinking, In what way SQL Server Licencing restrictions
> are applicable as it is bundled along with SBS.
> Thanks for the help!
> Regards
> Chip
>|||Hi Neil,
Thanks for trying to help me, but if u read my post
clearly I was talking about installing the SQL Server on
the Same SBS 2003 Edition and am concerned about Licensing
Issues with SQL Server 2000 on SBS 2003.
I am going mad with this Issue.
Regards
Chip
>--Original Message--
> Q. Is it possible to install the server
applications included with
>Windows Small Business Server 2003 on a different
computer running Windows
>Server? For example, I want to run SQL Server on the
computer running
>Windows Small Business Server 2003, but I want to run
Exchange Server 2003
>on a different computer.
> A. No. The server applications that come with the
product must be
>installed on the same physical machine, if they are
installed at all. The
>only exception is that FrontPage 2003, which is included
with the premium
>edition, may be installed on a single client computer in
the Windows Small
>Business Server 2003 network.
>
> direct from MS web site
>http://www.microsoft.com/windowsserver2003/sbs/techinfo/ov
erview/generalfaq.
>mspx
> Neil MacMurchy
>
>"Chip" <chipsin007@.yahoo.com> wrote in message
>news:1b1401c3fc0d$62f56690$a301280a@.phx.gbl...
>> Hi,
>> The below issue is frustrating me as I have posted it
>> couple of times on this news group but didnt received a
>> single response.Atleast this time I expect a response
from
>> MSFT online personnels.
>> I have a SBS 2003 5 CAL . I want to use SQL Server on
top
>> of it in production, I prefer to use SQL Server based on
>> the available CPU's on my system. But I am confused
>> thinking, In what way SQL Server Licencing restrictions
>> are applicable as it is bundled along with SBS.
>> Thanks for the help!
>> Regards
>> Chip
>
>.
>|||you might have better luck in the microsoft.public.smallbiz.sbsisp group.
My guess however is still a big nope. Since the SBS server is licensed per
seat, I don't think this would allow the SQL portion to be licensed per
processor as they apps are licensed as a bundle. I realize that if you
wanted to use this to allow anonymous SQL access (Internet) you need to use
per processor licensing but this is not the intent of this product (to my
knowledge).
Best bet would be to call MS. A regional sales rep can usually clear away
the licensing confusion that most MS products have :)
Neil
"Chip" <chipsin007@.yahoo.com> wrote in message
news:1daa01c3fc20$06faab30$a301280a@.phx.gbl...
> Hi Neil,
> Thanks for trying to help me, but if u read my post
> clearly I was talking about installing the SQL Server on
> the Same SBS 2003 Edition and am concerned about Licensing
> Issues with SQL Server 2000 on SBS 2003.
> I am going mad with this Issue.
> Regards
> Chip
> >--Original Message--
> > Q. Is it possible to install the server
> applications included with
> >Windows Small Business Server 2003 on a different
> computer running Windows
> >Server? For example, I want to run SQL Server on the
> computer running
> >Windows Small Business Server 2003, but I want to run
> Exchange Server 2003
> >on a different computer.
> >
> > A. No. The server applications that come with the
> product must be
> >installed on the same physical machine, if they are
> installed at all. The
> >only exception is that FrontPage 2003, which is included
> with the premium
> >edition, may be installed on a single client computer in
> the Windows Small
> >Business Server 2003 network.
> >
> >
> >
> > direct from MS web site
> >http://www.microsoft.com/windowsserver2003/sbs/techinfo/ov
> erview/generalfaq.
> >mspx
> >
> > Neil MacMurchy
> >
> >
> >"Chip" <chipsin007@.yahoo.com> wrote in message
> >news:1b1401c3fc0d$62f56690$a301280a@.phx.gbl...
> >> Hi,
> >>
> >> The below issue is frustrating me as I have posted it
> >> couple of times on this news group but didnt received a
> >> single response.Atleast this time I expect a response
> from
> >> MSFT online personnels.
> >>
> >> I have a SBS 2003 5 CAL . I want to use SQL Server on
> top
> >> of it in production, I prefer to use SQL Server based on
> >> the available CPU's on my system. But I am confused
> >> thinking, In what way SQL Server Licencing restrictions
> >> are applicable as it is bundled along with SBS.
> >>
> >> Thanks for the help!
> >>
> >> Regards
> >>
> >> Chip
> >>
> >
> >
> >.
> >|||Hi Neil,
Thank you very much for ur views and suggestions. I will
contact the Local Microsoft office. But I am surprised of
one thing. How come no Microsoft guy tried to answer my
query even after I put the Attention Note in subject.
Anyway Have a nice time.
Regards
Chip
>--Original Message--
>you might have better luck in the
microsoft.public.smallbiz.sbsisp group.
>My guess however is still a big nope. Since the SBS
server is licensed per
>seat, I don't think this would allow the SQL portion to
be licensed per
>processor as they apps are licensed as a bundle. I
realize that if you
>wanted to use this to allow anonymous SQL access
(Internet) you need to use
>per processor licensing but this is not the intent of
this product (to my
>knowledge).
>Best bet would be to call MS. A regional sales rep can
usually clear away
>the licensing confusion that most MS products have :)
>Neil
>"Chip" <chipsin007@.yahoo.com> wrote in message
>news:1daa01c3fc20$06faab30$a301280a@.phx.gbl...
>> Hi Neil,
>> Thanks for trying to help me, but if u read my post
>> clearly I was talking about installing the SQL Server on
>> the Same SBS 2003 Edition and am concerned about
Licensing
>> Issues with SQL Server 2000 on SBS 2003.
>> I am going mad with this Issue.
>> Regards
>> Chip
>> >--Original Message--
>> > Q. Is it possible to install the server
>> applications included with
>> >Windows Small Business Server 2003 on a different
>> computer running Windows
>> >Server? For example, I want to run SQL Server on the
>> computer running
>> >Windows Small Business Server 2003, but I want to run
>> Exchange Server 2003
>> >on a different computer.
>> >
>> > A. No. The server applications that come with the
>> product must be
>> >installed on the same physical machine, if they are
>> installed at all. The
>> >only exception is that FrontPage 2003, which is
included
>> with the premium
>> >edition, may be installed on a single client computer
in
>> the Windows Small
>> >Business Server 2003 network.
>> >
>> >
>> >
>> > direct from MS web site
>http://www.microsoft.com/windowsserver2003/sbs/techinfo/ov
>> erview/generalfaq.
>> >mspx
>> >
>> > Neil MacMurchy
>> >
>> >
>> >"Chip" <chipsin007@.yahoo.com> wrote in message
>> >news:1b1401c3fc0d$62f56690$a301280a@.phx.gbl...
>> >> Hi,
>> >>
>> >> The below issue is frustrating me as I have posted it
>> >> couple of times on this news group but didnt
received a
>> >> single response.Atleast this time I expect a response
>> from
>> >> MSFT online personnels.
>> >>
>> >> I have a SBS 2003 5 CAL . I want to use SQL Server on
>> top
>> >> of it in production, I prefer to use SQL Server
based on
>> >> the available CPU's on my system. But I am confused
>> >> thinking, In what way SQL Server Licencing
restrictions
>> >> are applicable as it is bundled along with SBS.
>> >>
>> >> Thanks for the help!
>> >>
>> >> Regards
>> >>
>> >> Chip
>> >>
>> >
>> >
>> >.
>> >
>
>.
>|||"Chip" <anonymous@.discussions.microsoft.com> wrote in message
news:2a0701c3fc90$f2d9dc40$a101280a@.phx.gbl...
> Hi Neil,
> Thank you very much for ur views and suggestions. I will
> contact the Local Microsoft office. But I am surprised of
> one thing. How come no Microsoft guy tried to answer my
> query even after I put the Attention Note in subject.
> Anyway Have a nice time.
In short, because we're not lawyers and we've been told that because we're
not lawyers we're not to dispense legal advice. :-( On top of that, there
simply may not be any Microsoft employees reading this newsgroup who know
the answer. I know I sure don't. Neil is right, your best bet is to contact
your local sales office.
Oh, and please note that while this is a Microsoft-hosted newsgroup, unless
you're a subscriber to TechNet or MSDN there's no guarantee of a response.
Sorry!
--
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.

KDC Error

Hello:
I am getting a KDC error on my domain controllers system log. The error is
below.
Event Source: KDC
Event ID: 11
Description:
There are multiple accounts with name "MSSQLSvc/computer.domain.local:1433"
of type 10.
I have tracked this down to one of the developers domain admin accounts. It
is the "servicePrincipalName" on his account. This is the same
"servicePrincipalName" as the SQL server. I research this before and it was
thought perhaps he had install SQL under this account or at one point SQL
was running under this account. When I removed it SQL basically shutdown.
I immediately put it back. Later someone told me I should have just stopped
and restarted the SQL service and it would have corrected the problem.
Can anyone give me any input on this? This is a major production server and
I want to be very careful.
Harrison MidkiffHi
I am not sure about what the cause of this problem is, but the solution may
be to create a new service account, set SQL Server to use this account,
stop/restart SQL server at a scheduled time. Changing the old service account
should then not effect the SQL Server.
John
"Harrison Midkiff" wrote:
> Hello:
> I am getting a KDC error on my domain controllers system log. The error is
> below.
> Event Source: KDC
> Event ID: 11
> Description:
> There are multiple accounts with name "MSSQLSvc/computer.domain.local:1433"
> of type 10.
> I have tracked this down to one of the developers domain admin accounts. It
> is the "servicePrincipalName" on his account. This is the same
> "servicePrincipalName" as the SQL server. I research this before and it was
> thought perhaps he had install SQL under this account or at one point SQL
> was running under this account. When I removed it SQL basically shutdown.
> I immediately put it back. Later someone told me I should have just stopped
> and restarted the SQL service and it would have corrected the problem.
> Can anyone give me any input on this? This is a major production server and
> I want to be very careful.
> Harrison Midkiff
>
>|||Hi Harrison ,
This issue can occur if SQL accout is changed from Machine account to
service account. The SPN for the machine account was not removed from the
domain.
I suggest that you use LDIFDE to export the domain to text file and seach
for MSSQLSVC.
Syntax was:
LDIFDE -d DC=DEFIANT,DC=pactsolutions,DC=com, DC=au -f c:\export.txt
After you locate the duplicate SPN, you can use the Adsiedit.msc tool to go
to the object, view the duplicate SPN value, and remove the duplicate SPN
value. To determine which one was the one in current use, please delete one
of the
MSSQLSvc/uohssrv1.uohs.uottawa.ca:1433 SPNs, then restarted the SQL
service(s).
The SQL service will re-add the SPN on the currently in use service
account. If it is not readded, then the duplicate has been removed.
You can refer to the following article for more related information about
Kerberos Terminology and Service Principle Name (SPN).
811889.KB.EN-US HOW TO: Troubleshoot the "Cannot Generate SSPI Context"
Error Message
http://support.microsoft.com/default.aspx?scid=KB;EN-US;811889
Hope this helps.
Best regards,
Vincent Xu
Microsoft Online Partner Support
======================================================Get Secure! - www.microsoft.com/security
======================================================When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
======================================================This posting is provided "AS IS" with no warranties,and confers no rights.
======================================================>>Reply-To: "Harrison Midkiff" <HMidkiff@.aviinc.com>
>>From: "Harrison Midkiff" <HMidkiff@.aviinc.com>
>>Subject: KDC Error
>>Date: Thu, 11 May 2006 19:00:26 -0400
>>Lines: 25
>>Organization: Audio Visual Innovations, Inc.
>>X-Priority: 3
>>X-MSMail-Priority: Normal
>>X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
>>X-RFC2646: Format=Flowed; Original
>>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
>>Message-ID: <eVgny6UdGHA.3348@.TK2MSFTNGP03.phx.gbl>
>>Newsgroups: microsoft.public.sqlserver.server
>>NNTP-Posting-Host: 208.5.55.190
>>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP03.phx.gbl
>>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:431203
>>X-Tomcat-NG: microsoft.public.sqlserver.server
>>Hello:
>>I am getting a KDC error on my domain controllers system log. The error
is
>>below.
>>Event Source: KDC
>>Event ID: 11
>>Description:
>>There are multiple accounts with name
"MSSQLSvc/computer.domain.local:1433"
>>of type 10.
>>I have tracked this down to one of the developers domain admin accounts.
It
>>is the "servicePrincipalName" on his account. This is the same
>>"servicePrincipalName" as the SQL server. I research this before and it
was
>>thought perhaps he had install SQL under this account or at one point SQL
>>was running under this account. When I removed it SQL basically
shutdown.
>>I immediately put it back. Later someone told me I should have just
stopped
>>and restarted the SQL service and it would have corrected the problem.
>>Can anyone give me any input on this? This is a major production server
and
>>I want to be very careful.
>>Harrison Midkiff
>>