no probs

really you shouldn't use the * notation, it will lead to frustration and chasing weird errors when someone makes a modification to the schema.

if you can't be bothered typing...

The problem your facing is that 1 person might have more than one record in some of the other tables

you can have a look at the contents of the...

SSIS has fuzzy lookup and fuzzy grouping which will find potential matches, create a link between the two, score the matching and allow you to give give certain cut off...

Try this example of computed columns:

CREATE TABLE MyTable

(

Col1 varchar(50) NULL,

Col2 varchar(50) NULL,

Col3 AS getdate(),

Col4 AS col1+col2

)...

create a windows login for the service to run under

add this windows user as a database user and then only give it rights to the specific databases you want it...

with the * notation you get columns from addnotes AND customer

change your query to this:

insert into laptop.dbo.addnotes

select addnotes.* from addnotes

join customer on customer.cus_id=addnotes.id

where customer.status = 'Active'

You don't have to install the entire SQL Server to access a SQL Server database though, there is the option of just installing the client tools:

http://www.microsoft.com/downloads/details.aspx?amp;displaylang=en&familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en

there are some third party...

Is this being handled by the OnError Event handler?

If so then there is the System::SourceName variable which holds the name of the control flow item which caused the error.

as far...

There is an example here

http://www.sqlservercentral.com/articles/SSIS/61987/

and another one here

http://www.sqlservercentral.com/articles/SSIS/64014/

neither one will be 100% match for what you want but they should give you enough info 😉

Put a simple report in its place with a single text box which informs the user that the report has moved

You can then change the navigation properties on the text...

Unfortunately not (although I would be very very happy if someone else could prove me wrong)

Reporting services integration with Excel isn't actually that good, just try exporting a report with...

This is one of the reasons why I either hibernate or leave my PC on over night 😀

One thing which I've always disliked doing though is having multiple server connections...

No probs 😀

Date comparisons can throw up a few of these gotchas for Newbies!

Have a careful look...

you need to use the dateadd with convert functions

select

SUM(CASE WHEN DATEPART(MONTH, scheddate) = DATEPART(MONTH, GetDate()) THEN qty ELSE 0 END) AS month_current,

SUM(CASE WHEN left(convert(varchar, scheddate, 112), 6) = left(convert(varchar, dateadd(month,...

Gift Peddie (5/14/2009)

The ASP .NET application will then need to pick up this data and present it to the user.

The problem you're going to face is getting the real time...