Not sure what the output is going to be at the end of your project ;

But you could use the MONTH/YEAR to determine the top level and then using the...

Unfortunately I dont think this would be possible - due to "Applications" using a generic "SQL Login" for transactions.

The user level security is handled by the application interface and therefore...

Just an update -

Because I am using one column from the input table - I have changed to use delimited file as output, which now does the job.

If you are checking for the existance of data in one table comared to another and acting on the result.

You could try using the "MERGE" statement

IF MATCHED in SOURCE

IF MATCHED...

Both 2008 and 2008R2 are contained in the certification ( 70-432 / 70-450 )

You will see a lot of topics on the course work lending itself to the new features...

k.subramanyam1017 (6/12/2012)

---

Hi friends,

I have alredy installed sqlserver in 'c' drive but i want to change the 'd' drive. is it possible or not pls...

Brilliant - a fine example.

Many Thanks

Jared,

That is exactly what I am saying .....

Regards

Steve

OKay - I understand the logic of creating the multiple lines up front, which I can do - combining the fields to string lengths and having the "temp table" with...

Sorry - Yes that is correct.... BUT if there are only 2 lines of description, then I would miss that line out from the output.

I am looking at maybe an...

sorry - having an off day.

Thank you for your help - will read and experiment.

Thanks again

is there a simple "how to guide" that I could follow ?

Regards

Ok sorry for being unclear -

I have the data stored in a simple single table, to which I need to create a text file that gets imported into "IBM...

Not sure the state of the database when the "cancel" was requested and how it "cancelled" - the best advice would be to do a restore prior to the aborted...

Thanks for your help -

I have set this up from the express sql - and works fine, so this is a problem with going to the express server from...