用case when 慢慢写
创新互联是一家专注于网站设计、网站制作与策划设计,仙桃网站建设哪家好?创新互联做网站,专注于网站建设十多年,网设计领域的专业建站公司;建站业务涵盖:仙桃等地区。仙桃做网站价格咨询:028-86922220
'1110630' +
case b.wdh when '00' then '0201'
when '02' then '0301'
when '03' then '0401'
...
else '0101' end
+ '00000000' as P005
DECLARE @str as nVARCHAR(max)
set @str='yyq,'
select @str=@str+''''+fkmc+''''+'=sum(case fkmc when
'+''''+fkmc+''''+' then fk else null end),'
from hb group by fkmc
set @str='select '+substring(@str,1,len(@str)-1)+',sum(fk) as 合计 from hb group by yyq'
print @str
exec(@str)
你这样写，我执行了一下是可以的，除了数据为空时，其他都可以的
International logistics has become an important part of economic system. Modern logistics is the result of economic globalization, but also promote the economic globalization is an important services. Logistics enterprise to improve the competitiveness of enterprise informatization construction, there is the road. Modern logistics management system including single business management, scheduling up business management, transportation business management, inventory management, personnel management. Business management and operation in the whole logistics management system in control.
In business for scheduling, inventory management workload big technical problems, we design and implement inventory management system. This system is running on Windows platforms, using J2EE platform development, with high throughput and scalability of the system, the system can adapt to a larger scale of operations and future development. And in the business can provide complex function at the same time, still can provide simple and intuitive operating mode and the page.
The main content of this article for:
First, introduces the research background, and modern logistics system, analyses the development status of modern logistics system of inventory management system.
Second, introduces MVC design patterns, currently using frame of Struts J2EE technology and SQL Server database in the use and development of 2005.
Third, according to the pattern design, design MVC dispatching business module of inventory management subsystem,
Fourth, using J2EE technology and SQL Server 2005 database, realizes the inventory management subsystem according to the following functions: single information retrieval outbound request form, According to the state Treasury information retrieval request list, According to the state information retrieval transport request list, Searching out the corresponding information warehouse inventory goods, The outbound transportation and request for review.
Added:
This system USES B/S model design, use Java, JavaScript as the application development, using the language Sqlserver005 create backstage database, making use of graphics software Visio state chart and control flow graph and Jtest use of unit tests, using open-source Bug management tools mantis, submit the related Bug finally formed through the test data, to test for business process.
加入sql2005的jar包 ;displaylang=zh-cn 下载
在看数据库用户名和密码是否正确
你试试把下载数据库驱动包下的一个.dll文件放在windows目录下的system32还是system下面试试 我以前遇到过这样的问题
那你最好分开写，一个SQL查询不为1的，一个SQL查询为1的，然后Union起来