110,536
社区成员
发帖
与我相关
我的任务
分享
string url = string.Empty;
var rowArr = datatable.AsEnumerable().GroupBy(p => p["user_id"]);
for (int r = rowArr.Count() - 1; r >= 0; r--)
{
url = string.Join(",", rowArr.ElementAt(r).Select(u => u["img_url"].ToString()));
for (int p = rowArr.ElementAt(r).Count() - 1; p >= 0; p--)
{
if (p > 0)
{
datatable.Rows.Remove(rowArr.ElementAt(r).ElementAt(p));
}
else
{
rowArr.ElementAt(r).ElementAt(p)["img_url"] = url;
}
}
}
select top 100 percent * from v_users_photo cross apply
(select [user_id],max(addtime) maxtime from users_photo group by [user_id] ) users_photo2
where v_users_photo.[user_id] =users_photo2.[user_id] and v_users_photo.user_id in (31,40,55) and addtime between '2015/8/27 00:04:44' and
CONVERT(varchar(100), GETDATE(), 21) order by users_photo2.maxtime desc,users_photo2.[user_id],v_users_photo.addtime desc
这是查询出一楼图片上数据的命令select top 100 percent * from v_users_photo cross apply
(select [user_id],max(addtime) maxtime from users_photo group by [user_id] ) users_photo2
where v_users_photo.[user_id] =users_photo2.[user_id] and v_users_photo.user_id in (31,40,55) and addtime between '2015/8/27 00:04:44' and
CONVERT(varchar(100), GETDATE(), 21) order by users_photo2.maxtime desc,users_photo2.[user_id],v_users_photo.addtime desc
这是获取图片上数据的代码
在这基础上有办法处理成我需要的吗 大大
select user_id ,stuff(cast((select ','+url from tb where user_id=a.userId for xml path('')) as varchar(max))),1,1,'') from tb a group by user_id