Changing the compatibility level is in fact that easy. Whether you'll have bugs in the procs or elsewhere is a separate question, but if you're just transferring data manually or...

karthikeyan,

Now that was a fun little exercise! Below is a function that will return a table.

CREATE FUNCTION [dbo].[fnCountCharacterOccurrence]

(@String NVARCHAR(4000))

RETURNS @Results TABLE (item NCHAR(1), itemCount INT)

AS

BEGIN

...

Can you please explain what you want with a bit more detail?

Please read the following post, and then try again. 😀

😀

Those replies just show how much I know, but then again, I haven't had any experience with large DBs.

😀

I would guess this would be a question to help determine your ability in writing optimized queries/procs. As the size of the DB grows so would the need for optimized...

I humbly submit this article...

http://www.sqlservercentral.com/articles/Development/2824/

SELECT TABLE_NAME FROM information_schema.columns WHERE COLUMN_NAME = '.....'

Actually a proc CAN return more than one dataset. :w00t: We're doing it in our .NET application. Now I'm not...

*laughs*

I used Excel. 😎

I'm not sure if your performing the calculations in your code in in the report itself. If you're doing the calcs in the report, move them into the procedures instead....

It's 1.02 to the 36th power or

1.02*1.02*1.02*1.02*1.02*1.02*1.02*1.02

*1.02*1.02*1.02*1.02*1.02*1.02*1.02*1.02

*1.02*1.02*1.02*1.02*1.02*1.02*1.02*1.02

*1.02*1.02*1.02*1.02*1.02*1.02*1.02*1.02

*1.02*1.02*1.02*1.02

=2.039887

Which in your example has been rounded up.

😀

search this site for the split function

...and there's always the possibility of rewriting the query. Can you post it so we can take a look to see if there's something to be done there?

Matt Miller (12/17/2007)

---

All right - now THAT's ugly.... Tell me - what does get_next_CRM_ID do?

Using that proprietary thing right there is the reason you're jammed up. Looks to...

Being that your procedure does all of that, IMHO you are stuck with looping of some sort.

You can always use a temp table and loop through an IDENTITY column...