PaulB-TheOneAndOnly (2/18/2011)

I'm pretty sure you already thought about the rdbms-to-rdbms options available to more the data over from Oracle, like linking the Oracle server so - I'm making no mention...

I'm going to eat them. I find text files to be really delicious, with a bit of hot sauce.. 😛

But really, the files are older data that I'm using for...

Thanks, guys. Jo, I ended up using the spool option to spool the results of a query with a custom delimiter (pipe) into a text file.

Ok, I just got an email that the server is down for awhile, so that's why the listener isn't running. Or listening.

😛

I was just about the post the answer when I saw your reply! Thanks!

I didn't know what to search for in the Oracle documentation.

The solution was to create a 1-column tablix that includes a dataset, at the end of the first part, that contains a list of the subjobIDs.

Then, in the textbox...

using

exec sp_configure locks

returns:

name minimum maximum config_value run_value

----- --------- --------- ------------ ----------

locks 5000 ...

It sounds like what you're saying is that the somewhat unusual performance differences are dependent on the indexes. If that's the case, we would probably need to know the table...

No worries.. you can cook with it as well!

Yes, the "Code." prefix did the trick, as for calling the function that was in the code tab in report properties.

Ninja, you might want to open your window. I'm going...

OK.. I found this article here:

http://www.sqlservercentral.com/scripts/Data+Warehouse/31510/

So he's got a function called CalcRatio that is put into Report --> Properties --> code tab.

However, I must be calling it wrong,...

Ninja's_RGR'us (2/25/2009)

---

the problem is that everything gets evaluated before the iff is executed... hence the error.

You need to create a function in the code pane with 3 parameters (numerator, denominator,...

Look up CREATE TRIGGER in Books Online (especially the examples at bottom of page). You can setup a trigger to perform some action when an insert is done on a...

You ought to...

Sounds to me like Groups should be called Topics or something as mentioned before, but as for your "join" table, if it's a many-to-many relationship, I'd recommend QuestionsTopics, but then...