DECLARE @T TABLE([QAB001] VARCHAR(20) COLLATE Chinese_PRC_BIN , [QAB003] VARCHAR(20) COLLATE Chinese_PRC_BIN , LVL INT)
DECLARE @LVL INTSET @LVL=0
INSERT @T SELECT [QAB001], [QAB003],@LVL FROM SGMQAB WHERE [QAB001]='F-3182PHILA01'WHILE @@ROWCOUNT>0
BEGIN
SET @LVL=@LVL+1
INSERT @T SELECT A.[QAB001],A.[QAB003],@LVL FROM SGMQAB AS A,@T AS B WHERE A.[QAB001]=B.[QAB003] AND B.LVL=@LVL-1
END
SELECT T.*,C.*
FROM @T AS T left JOIN TPADEA AS C
ON [DEA001]=[QAB003]
WHERE NOT EXISTS(SELECT 1 FROM SGMQAB WHERE [QAB001]=T.[QAB003])
------------------------------------------------------------------------------------------
如果不可以,那位兄弟可以帮我写一下这个存储过程,问题如下?
http://topic.csdn.net/u/20090630/09/e611548d-1b88-405a-8589-d46e46567ec3.html
DECLARE @LVL INTSET @LVL=0
INSERT @T SELECT [QAB001], [QAB003],@LVL FROM SGMQAB WHERE [QAB001]='F-3182PHILA01'WHILE @@ROWCOUNT>0
BEGIN
SET @LVL=@LVL+1
INSERT @T SELECT A.[QAB001],A.[QAB003],@LVL FROM SGMQAB AS A,@T AS B WHERE A.[QAB001]=B.[QAB003] AND B.LVL=@LVL-1
END
SELECT T.*,C.*
FROM @T AS T left JOIN TPADEA AS C
ON [DEA001]=[QAB003]
WHERE NOT EXISTS(SELECT 1 FROM SGMQAB WHERE [QAB001]=T.[QAB003])
------------------------------------------------------------------------------------------
如果不可以,那位兄弟可以帮我写一下这个存储过程,问题如下?
http://topic.csdn.net/u/20090630/09/e611548d-1b88-405a-8589-d46e46567ec3.html
解决方案 »
- 使用WebBrowser控件如何获得和设置其中文本框的内容
- 感谢csdn给我们提供平台
- FileSystemObject 对象 创建错误的问题
- 在win2000中如何屏蔽Ctrl+Alt+Del,Alt+Tab…………
- 怎么显示不定量的信息?
- 数据库备份问题?
- 奇怪的无法识别诗句库格式问题.
- 如何用ADO实现在程序中动态的往ACCESS数据库中动态的添加新表及设计表结构?
- 如何在程序里获得MP3文件的信息,当前文件长度,文件名,当前播放时间等?
- 如何得到当前应用程序的父路径?急!!!
- 为什么在ado调用存贮过程返回记录集时,存贮过程中必须要加 set nocount on,否则无法正常返回记录.
- VB实现下滑移动菜单? 有无好的例程???
s="DECLARE @T TABLE([QAB001] VARCHAR(20) COLLATE Chinese_PRC_BIN , [QAB003] VARCHAR(20) COLLATE " & vbcrlf & Chinese_PRC_BIN , LVL INT) & vbcrlf & DECLARE @LVL INT 等等等等……
飘过