Express Edition doesn't support RS.

Check the below link for detail list:

http://www.microsoft.com/sqlserver/2005/en/us/reporting-services-features.aspx

Lets try to get into it...

Please provide answer to the following queries:

1. Are you excuting on the same server in both the scenarios?

2. Were the number of records initially (before...

Duplicate of:

http://www.sqlservercentral.com/Forums/Topic637789-359-1.aspx

Reply on the above link..

If you are loading the data in CSV into a single table then I would suggest following approach:

1. Create a table (staging table) to hold all the new records from...

Thanks Jeff!! 🙂

I think the below table design should solve your problem.

You need to create following tables:

PhoneType --Storee all the categories/types of phone numbers

(ID, Name)

PhoneNumber --Stores all the phone numbers

(ID,TypeID, Number)

ContactPhoneNumber --Stores...

DECLARE @RESULT varchar(128)

SELECT @RESULT = COALESCE(@RESULT, ', ' , '') + YourColumnName

FROM YourTableName

SELECT @RESULT

If the column is not char/varchar type the you will have to use cast

Not one that I am aware of....

Usually the best practice is to create the objects in following order:

1. DB

2. Tables

3. Views

4. UDFs

5. SPs

But again, in Views, UDFs and SPs you...

If you are not using 2005/08 you can go for below query:

SELECT Result1.Mycount

,Result1.SubsectionID

...

If you have to count the rows per subsection then you have to remove the extra columns from Select (A.SubsectionID,A.QuestionID, A.ResultValue) and also form the GROUP BY (A.SubsectionID,A.QuestionID, A.ResultValue).

You query...

ORDER BY clause will go after GROUP BY. The query should look like

Group By S.SubSectionTitle

ORDER BY S.SubSectionTitle

Also, you won't be able to select these columns (A.SubsectionID,A.QuestionID, A.ResultValue) as these...

Yes you can get away with these warnings. You will have to identity the objects that are generating these errors (as in the example AddEmployee SP) and then reorganize your...

Looks like %~dp0 is also an option to get the working directory. Thanks for updating me on this!!

The only difference I found is the leading '\' in case of %~dp0.

i would suggest..put up a trace and see what query is getting fired on the database.

(Sorry for typo I mentioned it as error in the last line)

I agree with RBarryYoung. Sometime later if you want to see that dependencies you won't get the results.