Using the above example, the generated xsd file needs another 'toplevel' element. Make it a complex type and sequence and then you will get a new table called report which...

Just a couple of typo points really.

The function SumCustomerTotals returns a table with CustomerTotalDue and shippedtotal but your example function call in the 6th code box selects different column names....

I'm no expert and I haven't used the express version much, but from your screen print it doesn't look like SQL express has installed correctly. I think SQL VSS is...

I'm following this one avidly (well I'm trying to keep up). Thanks for this.

Tony

PS. The link to part 1 points back to part 2.

For David McKinney

Just be wary when using a main procedure to prepare your temp tables

followed by sub procedures to populate the temp tables

The article notes that temp tables can be...

Sorry I was out of touch. I was being a bit dumb as that output file is just the output messages from the job run.

I can't say I've output xml...

Am I being too simplistic by saying just add a job?

Under SQL Server Agent, right click jobs, new job and fill in the boxes.

Under steps, general tab holds your commands...

Have a look at Books OnLine for @@IDENTITY because it sounds like you main application is using that builtin function to get the last value inserted into an identity column....

You could just add a parameter to the proc_test_table2 and then in the trigger gather the information you want to report to the email message and pass it into the...

I think the problem here is to do with locking.

The insert process locks the 'second row' when it starts the insert and then the trigger fires. In the trigger it...

Not really an answer, but another work around. I use winsplit revolution (freeware) to organise windows on my screen. With this you could use ctrl,alt,F7 to quickly move the active...

Rather than just trying to scroll through the Messages tab looking for the errors, just hit Ctrl+F and search for 'Msg' or 'Error' (can't remember which it is now). This...

Have a look at Jeff Moden's article [p]http://www.sqlservercentral.com/articles/TSQL/62867/[/p]

on the uses for a tally table. You should be able to use this to parse strings for character positions.

There are probably other ways but using a CTE (Common table expression) is a possibility

I'll assume you want the main table data for records you found in the audit where...

Yes, both give the same result but, they won't always do so at the same speed.

The second format (using the OR) is quicker (provided the column is indexed) so...