This is how they are designed to be used....

Microsoft doesn't use concurrent licensing anymore. The only options are per processor, user CAL's, or device CAL's. And, as was mentioned earlier, if you are using a middle...

Before I started evaluating HyperBac, I was using PKZip to zip up the DW dtabases (and I still use it at this time on our production PeopleSoft servers). Although...

I will say this about Hyperbac, they are a hands on company. I work in Colorado Springs (USA) and Hyperbac is in Melbourne (Australia). I have talked to...

If you are going to look at litespeed, you should also consider RedGate SQL Backup and HyperBac's HyperBac.

😎

Not to defend MS, but it could be an issue with the ODBC connector to MySQL. I have used the Import/Export wizard to pull data from other systems and...

Can't help you with an ROI, but I'd also look at HyperBac from HyperBac. It was selected as the Editors Choice in the latest version of SQL Server magazine...

insert into tablename (column list)

select column list

from ...

For more details look in BOL (ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/1054c76e-0fd5-4131-8c07-a6c5d024af50.htm)

If you have a lot of jobs running you will want to increase this: Maximum job history log size(in Rows): to something more that 1000 rows.

Yes, there is, but I think that would be a good exercise for you to work on using the test code I initially provided along with the change for using...

My first question is what are you using the date for in the package?

The 😉 (wink) should just be a close paren )

Try this:

SELECT

proj_id,

fund_srce_desc

INTO

#KIPP

FROM

PROJ_GOVT_CONTR

order by

proj_id

select

*

from

...

That's why. I provided a SQL Server 2005 solution since you posted your request for help in a SQL Server 2005 forum. CTE's are not available in SQL...

What version of SQL Server are you using?