SELECT courseType.type_id,type_name,class_name, 0 AS step INTO #temp FROM class
LEFT JOIN courseType ON courseType.type_id = class.type_id
ORDER BY courseType. type_id
DECLARE @class1 TABLE( type_id int , type_name varchar(50),class_name varchar(500),step int)
INSERT @class1 SELECT type_id,type_name,class_name, step FROM #temp ORDER BY type_name
UPDATE @class1 SET @C= class_name = CASE @T WHEN type_name THEN @C ELSE '' END +class_name+'/',
@T =type_name,
@type_id=type_id,
@step = step =@step+1
FROM @class1
SELECT type_id, type_name, class_name FROM @class1 c
JOIN (SELECT MAX(step) AS maxstep FROM @class1 GROUP BY type_name ) t
ON step=maxstep
稍作改作
LEFT JOIN courseType ON courseType.type_id = class.type_id
ORDER BY courseType. type_id
DECLARE @class1 TABLE( type_id int , type_name varchar(50),class_name varchar(500),step int)
INSERT @class1 SELECT type_id,type_name,class_name, step FROM #temp ORDER BY type_name
UPDATE @class1 SET @C= class_name = CASE @T WHEN type_name THEN @C ELSE '' END +class_name+'/',
@T =type_name,
@type_id=type_id,
@step = step =@step+1
FROM @class1
SELECT type_id, type_name, class_name FROM @class1 c
JOIN (SELECT MAX(step) AS maxstep FROM @class1 GROUP BY type_name ) t
ON step=maxstep
稍作改作
解决方案 »
- NET 加Expire/Cache-Control 头的好处和方法
- window2008 iis7 运行32位web问题
- GridView SQL
- Asp.Net服务器运行环境
- FCKediter V2上传文件是发生错误
- ~~~~~~~~~~~~~【请问如何向GridView 里面传值】~~~~~~~~~~~~~~~~``UP有分
- 连动DropDownList的问题
- 如何控制放在DataList中的控件?
- 访问yahoo messager的API以及是否有相应操作此API的DLL,能获取用户名单以及及时通讯!!
- 新手上路,请帮忙解释一下代码,谢谢,不多。
- 问一个asp.net的初级问题,请知道者不吝赐教!
- 如何保存excel文件
returns varchar(2000)
as
begin
declare @str varchar(2000)
set @str=''
select @str=@str+','+rtrim(field2) from tableA
where a=@content
set @str=right(@str,len(@str)-1)
return @str
end
gocreate function getstr2(@content varchar(5))
returns varchar(2000)
as
begin
declare @str varchar(2000)
set @str=''
select @str=@str+','+rtrim(field3) from tableA
where a=@content
set @str=right(@str,len(@str)-1)
return @str
end
goselect field1,dbo.getstr1(field1) field2,dbo.getstr2(field1) field3 from table1 group by a,c
DECLARE @STRING VARCHAR(50)
DECLARE test_cursor CURSOR FOR
SELECT * FROM TEST WHERE [NAME]='A' ORDER BY [ID] ASC
OPEN test_cursorDECLARE @COUNT INT
SET @COUNT=0
SET @STRING=''
WHILE (SELECT COUNT(*) FROM TEST WHERE [NAME]='A')>@COUNT
BEGIN
FETCH NEXT FROM test_cursor
SET @COUNT=@COUNT+1
Select @STRING=LTRIM(@STRING+STR(ID)) from TEST END
CLOSE test_cursor
DEALLOCATE test_cursorSELECT @STRING
更正:SELECT @STRING=LTRIM(@STRING+STR([ID])+'\') FROM TEST
上面的结果是1/ 2/ 3/ 4/ 5/ 6/ 7/
我尝试了用rtrim但还是不好使。关注。