Last Post 20 Apr 2008 12:27 AM by SQLUSA. 2 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

17 Apr 2007 09:55 PM

I am Migrating one database of Mysql to SQL server 2005, I am facing problem with Views where in Mysql they have GROUP_Concat (aggregate Function) which is not available with SQL i found some solution on Google.

1. Use of Cursors (T-SQL)
2. Creating an functions.

but again now i am facing issues like.

1. can i create CURSORS inside Views if yes please give me more information on it.
2. the function will return only 255 max value and what if i want to return bigger value.

Thanks for your help.

New Member
New Member

19 Apr 2007 12:26 AM
Hello russellb

thanks for your help it resolve my issue. thanks a lot
New Member
New Member

20 Apr 2008 12:27 AM
Talking about performance,

Functions and CURSORS are not scalable.

You are better off inline and set-based operations if you need speed.

Kalman Toth - Database, Data Warehouse & Business Intelligence Architect
SQL Server Training, SSAS, SSIS, SSRS:

Acceptable Use Policy