no it's not. variables do not have row indexs or columns.

your multiple quotes demonstrate it over and over again:

v_accounts_info_table(index).account_sequence for example

v_accounts_info_table(v_account_id).account_sequence...

i think in Oracle, a semicolon is manditory to determine the end of a statement;

i reformatted your queries and pasted them into SLq Developer, and got the same error.

when i...

the utility i described should work for you;

i found out the hard way on a new Windows7 laptop; the security is tighter, and it does not automatically add the person...

so you are not going to provide the CREATE TABLE definition of v_accounts_info_table?

you keep posting variations of the same oracle function over and over instead of providing the information...

I've looked at this at least half a dozen times, and still cannot see what it is doing, because i never see the table definition it is fiddling with.

this oracle...

Henrico Bekker (5/5/2010)

---

Because the sql user account needs to be created on sql server level as well, not only db level.

drop the account from the DB, recreate it on sql...

i think you can use the Surface Area Configuration tool to add yourself as an administrator, and then change the passwords of the lost admins, including "sa", right?

Well, my SSMS is actually what gets installed with SQL 2008 standard; it runs the reportagainst any database I point it at;

your SSMS might not have that feature;

anyway, i profiled...

ok the error you can get is:

i poked around using my Google-Fu, and that seems to be the limit;...

i remember a post from Jeff Moden mentioning that a view could only have ~200 references; it was less than 255 but more than 200; so if you have 400...

EXCEPT requires the same number of columns from both tables.

remember it's comparing row to row based ont he columns you select, so you need to either remove Column 2 from...

yet another day where i learned something I didn't know.

Thansk for this post, Brian. Good to know!

yeah it's so easy once you've discovered ti you want to kick yourself... I found out the hard waywhen i bought a new laptop and installed both SQL 2005 and...

the function you pasted is for Oracle, and contains a lot of stuff that is Oracle-only syntax.

it cannot be directly compiled into SQL Server, you'll have to re-write it.

with both .net and SQL server's built in tools, eventually someone can reverse engineer decrypt everything.

SQL server has to be able to compile any encrypt stored procs/functions ; the WITH...