Thanks I've sorted it out.. currently testing the results.

Yes, RTFM I know I know 😀

Thanks for this but I've tried to your version and it doesn't seem to work?!

I've changed your code so it uses my sample data but the syntax just looks wrong...

Here is a screenshot of what I'm trying to achieve:

Would I have to use a separate statement to update/insert?

To keep it simple, I've used streamreader to get each line and output the records into the relevant failes of Type01 to Typ07

public void Main()

...

Yea I've already started with the script task in SSIS route. I will post another update over in the next 24 hours.

Thanks to you both for your contribution.

Arggh Sean you beat me to it lol, anyhoo here is my attempt:

with SCC_CTE(VENDID, VENDTYPE)

as (select 'ABC', 1 union all

select 'ABC', 0 union all

select 'ABC', 0 union all

select 'XYZ', 1...

I've seen this before where dates are stored as INTs in fact tables. Your logic works but for this kind of thing I would create a Date dimension table to...

http://sql-ution.com/download-the-dba-repository/

http://sqlmag.com/sql-server/dba-repository-2010

Both sites inspired me to create my own DBA Repository. They're both very good.

RIGHT-CLICK folder, click properties then Security tab, click EDIT then give the SQL Server Service account Full control of the folder.

Possibly the security settings on the folder?

If you can afford some downtime then you can detach database, move log file to new location then reattach and point the database to the new location of the log...

Yogeshwar Phull (6/27/2013)

---

Hello

Is there an easy way of calcluating how many times an application hits SQL server on daily basis. I was thinking of using SQL server profiler for counting...

I'm assuming you cleared the data cache on the Windows XP machine before you ran the select?

Are you using a third party tool to perform the backup?

Was going to say that in an ideal world you'd host all your databases in memory but as you say it depends.