I am going to answer your specific question, but first I am going to try to give you some advice that I think will save you some pain down the...

If I understand you correctly you have the same rdlc you want to display twice, but 1 time you want the details hidden and the next you want it visible.

I...

What is the error message you are getting when you try to connect? Are you running SSMS on the SQL Server or remotely?

I don't think that there is a way to do this pre-2005.

BY default SQL Server install sets the MAX Memory option to 2 GB. My laptop has 1.25 GB RAM and SQL Server is set to max at 2 GB....

I think this is the code you are looking for:

[font="Courier New"]/*

Added IsNull because concatenating to a NULL yields NULL.  

Added ELSE to CASE statements so you keep the same value

Added Checks...

If you are really using SQL Server 2000 then you should get a syntax error because Create Role was added in 2005. I think in 2000 it was sp_addrole,...

Would be if I really KNEW anything beyond put left...

Yes you can. It is the same syntax as for permanent tables. Remember a temporary table is really a permanent table in tempdb that is hooked to a...

You would need a CASE as IF is a control of flow construct and CASE is an Expression.

Have you considered using a computed column as I suggested? I really...

This is a common problem people have. Here are some options:

[font="Courier New"]UPDATE paridtest

   SET parcel_id = parcel_id+CASE

                                   WHEN b.dir = 'North' AND LEN(RTRIM(LTRIM(STR(sect)))) = 1 THEN a.parcel_id+'00'+LTRIM(RTRIM(STR(a.sect +...

I would create a permanent table with a processed flag and insert salary changes to it from the trigger. Then have a job that runs every n minutes that...

I would venture to say that this means the import process is not CPU bound but IO or MEMORY bound.

Are you sure you have the necessary permissions to create a maintenance plan?

Are the files always put in the same location? If so you can use a foreach loop container that loops over .xls files in a the location. Processes...