Mark,

I am glad that I was able to help. For your second query, there are two things, which I can point out. First, if you are counting noComments, you should...

Michael,

Please keep in mind to help your fellow SQLServerCentral members by posting table structure and sample data, so that we can be at our best in helping you.

Please try out...

Mark,

Adding the other "Names" to the group by clause should fix the issue.

Example:[/u]

SELECT

r.id

, count(rc.reviewID) AS noOfComments

, cl.Name AS cruiseLine

, cs.Name AS cruiseShip

, cr.Name AS region

from dbo.ReviewCruises r

INNER JOIN dbo.ReviewCruiseComments...

FYI,

This is the query for which the original author is now using for his reports. (Reporting Services against a SQL Server 2000 database, thus we cannot use the flexibility of...

edony44,

Please provide table structure and some sample data. There is a number of ways in SSIS for SQL Server 2005 to accomplish what you need.

Regards,

Wameng Vang

Opus,

I have replied to your PM. What I meant by IM, was my MSN contact information.

Please keep in mind to post information in the original topic posting, not PMs. ;)...

edony44,

Without table schema/structure, and meaningful data, it is difficult to predict how the data will look.

Please keep in mind to always post schema and meaningful data so that we can...

Opus,

For now, judging from our postings, your query will return for each grade, a geocode, and a student count. Therefore, geocode can exist more than once, because you are grouping...

ishaan99,

I've read your most recent posting. Please submit the scripts for the table(s) structure. It would be nice to also get some sample data. This will allow me to dig...

Opus,

Your Statement:

select

ss.graden as Grade,

s.geocode as Geo,

s.suniq

from

stustat as ss inner join

studemo as s on ss.suniq = s.suniq inner join

track as t on ss.trkuniq = t.trkuniq

where

t.schoolc = @School

and ss.edate...

El barto,

Base on the DDL provided, we still need more information.

Please provide some sample data.

Please provide your current select statement.

This will help reduce our time in providing a...

Pam,

I could not reach the SQL Server Mobile documentation. However, I was able to locate the example syntax that you've provided. It is for SQL Server CE Edition. See:

http://msdn2.microsoft.com/en-us/library/aa237859(SQL.80).aspx

Base on...

El barto,

It is possible, however, in order for us to write specific sample queries for your specific table; you will need to provide the table structure/ DDL.

Regards,

Wameng Vang

Pam,

Can you provide the link to BOL? I am interested to know where you found the syntax.

However, to answer your question, you can use the following syntax:

ALTER TABLE bvc_Affiliate

ADD...

joe pinder,

Was that stored procedure code generated, by say a tool like CodeSmith? If so, you may need to modify the template, so that in the future it can be...