Good that I at least found out that SSRS 2008 does not require IIS. I was thinking it still uses IIS as SQL 2005.

My installation of SSRS is in a...

I am using Latin1_General_CI_AS

select case when 'ž' = 'Ž' then 1 else 0 end ---- returns 1

NM

Looks like a problem with the IIS on the Report server. Play around with the settings on that...

Make sure, that in IIS, under Web Service Extensions, ASP.net is allowed.

NM

Hi Everyone,

Please note that you can run two instances of SQL server and make it listen on two different IP address.

You need to...

I hope this is what u are looking for

select UserId,

Sum(case when course = 'Web1' then Status else 0 end) web1,

Sum(case when course = 'Web2' then Status else 0 end)...

can't be of much help, without knowing what has to be done

NM

it would have been nice, if u just post a sample data, not the 10,000 lines.

OK, you may not be able to append to a new column using DTS....

try OPENROWSET / bcp

NM

post a sample xml file and the DDL / schema for the target table, will try to solve ur mystery.

Also note that u can have a script component as a...

try

SET DATEFORMAT YMD

DELETE FROM WHERE RecordDate = '2009-06-30';

This forces to date format to YY-MM-DD, ignoring the client Regional settings.

This will do a...

I believe this is what you are trying to achieve,

select

convert(float, datediff(mi, convert(datetime, (convert(varchar, arrival_date) + ' ' + convert(varchar, arrival_time))), convert(datetime, (convert(varchar, arrival_date) + ' ' + convert(varchar, initial_assesment_time))))), arrival_date,...

I believe that SQL Compact Edition is meant for single user; it is not a complete database. You cannot have stored procedures / triggers / enterprise options like replication,...