Click here to Skip to main content
15,903,856 members
Home / Discussions / Database
   

Database

 
GeneralRe: ADO+"Update"+RecordsAffected+"VC++" Pin
DaviziN16-Oct-03 21:37
DaviziN16-Oct-03 21:37 
GeneralSome SQL problem in displaying data Pin
erbest15-Oct-03 22:20
erbest15-Oct-03 22:20 
GeneralRe: Some SQL problem in displaying data Pin
andyharman20-Oct-03 12:14
professionalandyharman20-Oct-03 12:14 
GeneralALTER TABLE ALTER COLUMN IDENTITY,help me Pin
crodling15-Oct-03 21:52
crodling15-Oct-03 21:52 
GeneralRe: ALTER TABLE ALTER COLUMN IDENTITY,help me Pin
Mike Dimmick16-Oct-03 5:03
Mike Dimmick16-Oct-03 5:03 
GeneralRe: ALTER TABLE ALTER COLUMN IDENTITY,help me Pin
Anonymous19-Oct-03 14:55
Anonymous19-Oct-03 14:55 
GeneralHighlighting a datagrid row based on condition Pin
Anonymous15-Oct-03 14:49
Anonymous15-Oct-03 14:49 
GeneralLoooping through SELECT values in SQL Pin
mittalpa15-Oct-03 10:59
mittalpa15-Oct-03 10:59 
Hi,

Environment - VB.NET, ASP.NET, SQL Server 2000.

In a SQL User-Defined Function, I am selecting a column which returns multiple rows. I need to construct one single string out of those returned values. To do that, I am using CUROSR.

Now, CURSOR is expensive operation. If there are 1000 users at a time, it will consume lot of resources.

Is there a way, I can construct this String without using CURSORs??

Please advice. Thanks

Pankaj

Follow your goals, Means will follow you ---Gandhi---
GeneralRe: Loooping through SELECT values in SQL Pin
Mike Dimmick16-Oct-03 5:14
Mike Dimmick16-Oct-03 5:14 
GeneralRe: Loooping through SELECT values in SQL Pin
Arjan Einbu18-Oct-03 9:44
Arjan Einbu18-Oct-03 9:44 
GeneralRe: Loooping through SELECT values in SQL Pin
mittalpa20-Oct-03 10:09
mittalpa20-Oct-03 10:09 
GeneralHelp! Test of SQL Server's scalability Pin
yyf15-Oct-03 10:34
yyf15-Oct-03 10:34 
GeneralRe: Help! Test of SQL Server's scalability Pin
Guillermo Rivero15-Oct-03 13:21
Guillermo Rivero15-Oct-03 13:21 
GeneralRe: Help! Test of SQL Server's scalability Pin
yyf16-Oct-03 3:22
yyf16-Oct-03 3:22 
GeneralQuery Pin
Anonymous15-Oct-03 6:36
Anonymous15-Oct-03 6:36 
GeneralMSAccess system tables & ADO.NET Pin
Armen Dalaliants15-Oct-03 6:28
Armen Dalaliants15-Oct-03 6:28 
GeneralImport Stored Procedure Pin
Richard Hudson15-Oct-03 5:19
Richard Hudson15-Oct-03 5:19 
GeneralRe: Import Stored Procedure Pin
Mike Dimmick16-Oct-03 5:08
Mike Dimmick16-Oct-03 5:08 
Generalforeign key Pin
Anonymous15-Oct-03 4:32
Anonymous15-Oct-03 4:32 
GeneralKill Sleeping Database Connections in SQL Server Pin
Altafqau15-Oct-03 0:17
Altafqau15-Oct-03 0:17 
GeneralRe: Kill Sleeping Database Connections in SQL Server Pin
Sage16-Oct-03 11:18
Sage16-Oct-03 11:18 
GeneralRe: Kill Sleeping Database Connections in SQL Server Pin
Altafqau16-Oct-03 23:49
Altafqau16-Oct-03 23:49 
GeneralADO and Pro-C Pin
WoonLeng13-Oct-03 19:56
WoonLeng13-Oct-03 19:56 
QuestionUpload File into SQL Server? Pin
DudleyDoorite13-Oct-03 4:34
DudleyDoorite13-Oct-03 4:34 
GeneralDataRow/DataGrid filter question. Pin
TravisMerkel12-Oct-03 13:06
TravisMerkel12-Oct-03 13:06 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.