ok it looks like I have to keep this in the same schema, I can't update a table of another schema in a stored procedure not of the same schema....

Huh.. This does seem to be something to do with the schema, I switched the schema to dbo and it managed to work... Not sure what I am meant to...

owner of the schemaname is dbo

Hi,

I read that article before, but from my understanding, that's more like the inverse of what I was doing, as I want to find the gaps in between the date...

Sorry, the 2 was to represent that I could potentially have multiple items, and each one would have their own gaps represented, but the updated dataset never left my management...

Ok I've solved my problem, I needed to put my 10.0.0.0 managedDTS file into the x86 version of the folder.

I think I figured out my problem - the page height was probably set to being too high, as I think any empty space was being considered as something that...

Upon receiving more detail requirements, it seems like this may not work after all... the database is currently SQL Server 2000, there is no XML Data Type, which I think...

Thanks, this looks like it'll work 🙂

It's been brought to my attention recently that there are several tables containing information about jobs and their schedules. does anyone know if it is possible to list through SQL...

That was the only solution I could...

Ah ok thanks, I assumed there might be a way to deploy it through visual studio, so that it shows up in the same interface. I'll revise what I'm doing...

I was having the opposite problem yesterday - I actually wanted to split up my report into multiple pages, as I had a ton of data, but it was all...

I've figured out one way of doing it, which might not be the best way - I grouped the data of my first column in SQL and then numbered this...

I've solved my problem now - I was using a shared data source, which meant I couldn't use expressions. The solution was to override the datasource used, in my dataset,...