i think you also want to set MAXDOP =1 during the bulk insert as well as inserting into the identity table as sturner suggested.

this is really an html question, more than a report server question, i think.

you can do it with a div, by putting the table/list in the div;

it would end up...

yes, but it takes a little bit of configuration on your part: you need at least TWO Oracle users in the Oracle database to accomplish this; one for when YOU...

DBA_SQL (1/18/2012)

---

I actually need to update an existing column with incremental numbers..as shown... Can you help me to...

another option is to have each table hav a foreign key to the designation instead;

much easier and makes sense to me:

the "designation" table would just be a lookup table.

CREATE TABLE...

i would just add two separate foreign key columns, one to each table, and a constraint to prevent both foreign keys from existing for a given record;

then if a...

it depends; you have to look at oracle and see the size that is assigned; you can't just read NUMBER, when you describe the table you need the size also:,...

well my first guess was off i guess, but i still think it might be permissions.

lets go back to the basics, i guess: you said this:

when i try to access...

inside a trigger, or procedure, there's a lot of built in functions you can use;

I use a variation of this in a lot of auditing type stuff:

--the auditing...

if the user explicitly says SELECT * FROM NEWTABLE, does he get an error stating "object does notexist or does not have access"

if that is true, it sounds like the...

I used Recuva, some free app on http://www.piriform.com/recuva recently to get some stuff from a folder that was deleted on Win7 / 64, it worked, but others may know of...

spids get reused, as they disconnect and someone else reconnects; You might want to add a trace so you can get the data you want int eh future, complete with...

i have tehse saved in my snippets; does this do what you want?

--elapsed time/datediff

select

[Days] ...

here's my first guess; there's a lot of flexibility in ISDATE and convert, you might get dates that are out of range.

;With mySampleData

AS

(

select '1 - Apr' As dt, 2010 AS...

I know you are leaving a lot out to simplify the examples, but that ends up adding more questiosn than answers.

why do you think you need two tables that represent...