well what you posted is a scalar function; ideally you want it to be an inline table valued function isntead.

after correcting some syntax, and putting it in my default dbo...

qur7 (9/5/2012)

---

Thanks Barry,

it makes sense. can you please let me know where to make changes in the code, sorry I am kind a new at this and for the past...

there's a SERVERPROPERTY function you can use, but do you need to discover that within a TSQL command?

SELECT 'IsClustered', SERVERPROPERTY('IsClustered')

Scott D. Jacobson (9/5/2012)

---

I'd start by profiling that process or at the very least that sproc. Look at the execution plan and start optimizing there. What about it...

yes it's possible;you need to use either a GROUP BY, or a sub select with a row_number() function to limit the selections.

either one can do what you want, depending on...

nzhang6666 (9/5/2012)

---

Just found out. The compatible level of the database is set to sql server 2000 (8.0).

I didn't know function can not be used in parameters of a table valued...

i just tested it in 2008R2, 2005, and compatibility 80.

the database you are testing in is set for compatibility 80 instead of 90.

in SQL2000 (80), functions were not allowed, and...

i googled "vb.net read pop3 mail" and got lots of hits for code examples; switch it around if you are more comfortable with C#, but the code is pretty basic.

I'm...

I've done this in code in vb.net/c#.net, where you pull messages from an SMTP server, and then you can do what you want with them: delete them off the mail...

except for the missing GO statement between the end of the proc and the DECLARE, when i uncomment #2, all three work perfectly.

ok just downloaded this freeware :

http://download.cnet.com/Optillect-SQL-Decryptor/3000-10254_4-75300271.html

i installed it and it decrypts perfectly, without needing the DAC.

Maximum Number of Processors Supported by the Editions of SQL Server

From your other thread, you know it's 4 sockets/unlimited cores per socket.

so if, for YOU, processor=socket then no.

if processor=core, then...

Anthony I've seen executables that decrypt without having to go into the DAC, but When I did the research once before, they seemed to be crippleware to try and get...

does this help you find what you are looking for?

http://www.amazon.com/s/ref=nb_sb_noss?url=search-alias%3Daps&field-keywords=sql2008R2+standard

KumarSQLDBA (9/5/2012)

---

We need SQL server 2008 R2 for the below Database servers with Windows Server 2008 R2 as OS for 2...

swathi that's a great way to show an alternate solution.

The only thing that bothers me is that solution only works if there are only 9 categories, 1-9, since you are...