请那位大神帮帮忙啊_百度知道
推门进去正对着一扇向阳的窗户，玻璃明颂赊齿肥佼堵酬瑟揣鸡亮采光很好，右手侧是一个下面带有学习用写字台的组合床，床上整洁的铺着蓝大方格床单，墙边挂着一幅熊猫图案的画，靠墙立放着蓝灰色枕头，与整体蓝灰格调的组合床很协调，床头还有个简易书架，用来放些睡前的读物。
写字台的两侧有许多抽屉用来存放学习用品和杂物，桌面上也有一个更为简易的书架，桌面还放着台灯和电脑液晶显示器主机放在桌子下边，靠床有个梯子供上下床使用，窗台下面有个篮球，显示出孩子对篮球运动的爱好。整个房间干净整齐，显示出家人良好的卫生习惯。---------------------------------------------------------------------
Push the door facing a sunny windows, glass bright lighting is very good, the right-hand side is a study with a desk with the following combination of bed, the bed covered with blue large squares clean sheets, wall hung a panda pattern painting, stood against a wall and blue-gray pillows, and the overall combination of blue and gray style bed very coordinated, there is a simple bedside shelves, used to put some bedtime reading.
There are many on both sides of the desk drawer to store school supplies and debris on the desktop also has a more simple bookcase, desk lamps and also placed on the table, the host computer LCD monitor below, by the bed with a ladder for use on the bed windowsill below a basketball, showing children of basketball hobby. The room clean and tidy, good health habits shown monks.
提问者评价
谢谢了，亲
其他类似问题
等待您来回答
下载知道APP
随时随地咨询
出门在外也不愁求大神帮帮忙啊_sql吧_百度贴吧
&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&签到排名：今日本吧第个签到，本吧因你更精彩，明天继续来努力！
本吧签到人数：0成为超级会员，使用一键签到本月漏签0次！成为超级会员，赠送8张补签卡连续签到：天&&累计签到：天超级会员单次开通12个月以上，赠送连续签到卡3张
关注：10,691贴子：
求大神帮帮忙啊收藏
执行存储过程时出错，二楼上代码
USE [smsemsMPS2]GO/****** Object:
StoredProcedure [dbo].[proc_WorkorderReport2]
Script Date:
10:04:36 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO-- =============================================================-- Created By: Liying Zheng, R_LS_, 4/10/2012-- Description:Other storage to optimize performance-- Modified by Ying Xin, 7/22/2014This is for the new improvement on affiliate side, add sort by-- =============================================================ALTER proc [dbo].[proc_WorkorderReport2]
int,@serviceDateStart1 varchar(50),@serviceDateEnd1 varchar(50),
varchar(50),
varchar(50),
varchar(200),@region1 varchar(200),@status1 int,@CustomerNameId1 int,@store1 varchar(50),@Schedule_Status1 varchar(50),@Schedule_End1 varchar(50),@ScheduleMoth_Start1 varchar(50),@ScheduleMoth_End1 varchar(50),@Sortby int,@pageIndex1 int,@pageSize1 int,@Technician1 int asBEGINdeclare @id int set @id=@id1declare @request int set @request=@request1declare @serviceDateStart varchar(50) set @serviceDateStart=@serviceDateStart1declare @serviceDateEnd varchar(50) set @serviceDateEnd=@serviceDateEnd1declare @city varchar(50) set @city=@city1declare @state varchar(50) set @state=@state1declare @district varchar(200) set @district=@district1declare @region varchar(200) set @region=@region1declare @status int set @status=@status1declare @CustomerNameId int set @CustomerNameId=@CustomerNameId1declare @store varchar(50) set @store=@store1declare @Schedule_Status varchar(50) set @Schedule_Status=@Schedule_Status1declare @Schedule_End varchar(50) set @Schedule_End=@Schedule_End1declare @pageIndex int set @pageIndex=@pageIndex1declare @pageSize int set @pageSize=@pageSize1--declare @Technician int set @Technician=@Technician1declare @comanyid intselect @comanyid=CompanyID from [User] where ID=@idDECLARE @StartPoint VARCHAR(10)DECLARE @EndPoint VARCHAR(10)SELECT @StartPoint = @PageSize * ( @PageIndex - 1 ) + 1 ,
@EndPoint = @StartPoint + @PageSize - 1
Declare @sql1 varchar(8000)Declare @sql2 varchar(8000)Declare @sql3 varchar(8000) Declare @sql4 varchar(8000)set @sql1=*DECLARE @Results TABLE(
ID_IDENTITY INT IDENTITY PRIMARY KEY,
requestnum varchar(50),
ScheduleDatetime varchar(50),
Calldatetime varchar(50),
ProStatus varchar(50),
SourceOfReq varchar(50),
LocationNum varchar(50),
Storenumber varchar(50),
District varchar(200),
region varchar(200),
retailerID varchar(200),
stpv varchar(50),
city varchar(50),
name varchar(200),
TradeName varchar(100),
R_Name varchar(50))*set @sql2=*INSERT INTO @Results(
id,requestnum,ScheduleDatetime,Calldatetime,ProStatus,SourceOfReq,LocationNum,Storenumber,District,region, retailerID,stpv,city,name,TradeName,R_Name)SELECT tb2.id,tb2.requestnum,tb2.ScheduleDatetime,tb2.Calldatetime,--tb2.storeconfirm,case tb2.ProStatus when 0 then **Unscheduled**when 1 then **Scheduled**when 2 then **Missed** when 3 then **Rescheduled**when 4 then **In Progress**when 5 then **Completed**when 6 then **Billed** when 7 then **Pay to Affiliate**when 8 then **Expired**when 9 then **Resolved Without Invoice**when 10 then **Deferred**when 11 then **Void**else **** end ProStatus,
case tb2.SourceOfReq when 0 then **Contracted Service** when 1 then **Reactive Service** when 2 then **Affiliate Credit Memo** when 3 then **AEmergency Request** when 4 then **Customer Credit Memo**when 5 then **Pool Service**else **** end SourceOfReq,tb1.LocationNum,tb1.Storenumber,tb1.District,tb1.region, tb1.retailerID, tb1.stpv,tb1.city ,--tb1.phone,--tb1.ASA,--tb1.rou,--tb1.SMSorLandlord,tb3.name,tb4.TradeName,tb6.Name as R_NameFROM request as tb2,shop as tb1, company as tb3,trade as tb4,Retailer as tb6where tb2.SourceOfReq!=4 and tb2.tradeid&&44 panyId=*+CONVERT(varchar,@comanyid)+* and tb1.ID=tb2.shopID panyID=tb3.ID and tb2.tradeID=tb4.ID and tb1.retailerID=tb6.ID*set @sql3=* and tb2.RequestNum=*+CASE WHEN @request&=0 THEN *tb2.RequestNum* ELSE
**+CONVERT(varchar,@request)+** END +* *+CASE WHEN @serviceDateStart=** THEN ** ELSE *and tb2.Calldatetime&=***+@serviceDateStart+**** END+* *+CASE WHEN @serviceDateEnd=** THEN ** ELSE *and tb2.Calldatetime&= ***+@serviceDateEnd+**** END+* and tb1.city like *+case when @city =** then *tb1.city* else ***%*+@city+*%*** end+* and tb1.stpv like *+case when @state =** then *tb1.stpv* else ***%*+@state+*%*** end+* --and tb1.District like *+case when @district =** then *tb1.District* else ***%*+@district+*%*** end+* --and tb1.region like *+case when @region =** then *tb1.region* else ***%*+@region+*%*** end+* and tb2.ProStatus=*+CASE WHEN @status&0 THEN *tb2.ProStatus* ELSE
**+CONVERT(varchar,@status)+** END +*
and tb1.retailerID=*+case when @CustomerNameId&=0 then *tb1.retailerID* else **+CONVERT(varchar, @CustomerNameId)+** end+* and tb1.LocationNum like *+case when @store =** then *tb1.LocationNum* else ***%*+@store+*%*** end+* *+CASE WHEN @Schedule_Status=** THEN ** ELSE *and tb2.ScheduleDatetime&= ***+@Schedule_Status+**** END+* *+CASE WHEN @Schedule_End=** THEN ** ELSE *and tb2.ScheduleDatetime&= ***+@Schedule_End+**** END+** if (@Technician1&&0)beginset @sql3=@sql3+ * and tb2.Technician=*+@Technician1endSET @sql3=@sql3+CASE WHEN @Sortby=0 THEN **
WHEN @Sortby=1 THEN * ORDER BY tb2.RequestNum*
WHEN @Sortby=2 THEN * ORDER BY tb2.RequestNum DESC*
WHEN @Sortby=3 THEN * ORDER BY tb2.Calldatetime*
WHEN @Sortby=4 THEN * ORDER BY tb2.Calldatetime DESC*
WHEN @Sortby=5 THEN * ORDER BY tb2.ScheduleDatetime*
WHEN @Sortby=6 THEN * ORDER BY tb2.ScheduleDatetime DESC*
WHEN @Sortby=7 THEN * ORDER BY tb4.TradeName*
WHEN @Sortby=8 THEN * ORDER BY tb4.TradeName DESC*
WHEN @Sortby=9 THEN * ORDER BY tb2.SourceOfReq*
WHEN @Sortby=10 THEN * ORDER BY tb2.SourceOfReq DESC*
WHEN @Sortby=11 THEN * ORDER BY tb6.Name*
WHEN @Sortby=12 THEN * ORDER BY tb6.Name DESC*
WHEN @Sortby=13 THEN * ORDER BY tb1.LocationNum*
WHEN @Sortby=14 THEN * ORDER BY tb1.LocationNum DESC*
WHEN @Sortby=15 THEN * ORDER BY tb1.city*
WHEN @Sortby=16 THEN * ORDER BY tb1.city DESC*
WHEN @Sortby=17 THEN * ORDER BY tb1.stpv*
WHEN @Sortby=18 THEN * ORDER BY tb1.stpv DESC*
WHEN @Sortby=19 THEN * ORDER BY tb2.ProStatus*
WHEN @Sortby=20 THEN * ORDER BY tb2.ProStatus DESC*
ELSE ** END
SET @sql4 = *DECLARE @iCount AS intSELECT @iCount = MAX(ID_IDENTITY) FROM @ResultsSELECT
iCount = @iCount,id,requestnum,ScheduleDatetime,Calldatetime,ProStatus,SourceOfReq,LocationNum,Storenumber,District,region, retailerID,stpv,city,name,TradeName,R_NameFROM @Results WHERE ID_IDENTITY BETWEEN *+@StartPoint+* AND *+@EndPoint+*--ORDER BY--convert(smalldatetime,ServiceDate) DESC*
exec(@sql1+@sql2+@sql3+@sql4)END
我这么执行存储过程的时候会报错exec dbo.[proc_WorkorderReport2] 13694,0,**,**,**,**,**,**,-1,-1,**,**,**,**,**,1,20,0,89消息 245，级别 16，状态 1，过程 proc_WorkorderReport2，第 169 行Conversion failed when converting the varchar value * and tb2.RequestNum=tb2.RequestNum
and tb1.city like tb1.city and tb1.stpv like tb1.stpv --and tb1.District like tb1.District --and tb1.region like tb1.region and tb2.ProStatus=tb2.ProStatus
and tb1.retailerID=tb1.retailerID and tb1.LocationNum like tb1.LocationNum
and tb2.Technician=* to data type int.
这么执行就不报错，是什么情况
登录百度帐号我的游戏推荐游戏
后查看最近玩过的游戏
使用签名档&&
为兴趣而生，贴吧更懂你。或大神帮帮忙啊_百度知道
提问者采纳
com/zhidao/wh%3D600%2C800/sign=832e2eea8f81e09220cc/a8ec8ae50e86c6a3ec08fa513dc692,hiphotos,//c,hiphotos,jpg" esrc="http,baidu,com/zhidao/wh%3D450%2C600/sign=a0bac7eb0ff431adbc874b3d7eec8ae50e86c6a3ec08fa513dc692,jpg" target="_blank" title="点击查看大图" class="ikqb_img_alink"><img class="ikqb_img" src="http,baidu,baidu,&nbsp,hiphotos,,com/zhidao/pic/item/a8ec8ae50e86c6a3ec08fa513dc692,
哦哦 在海淀区
提问者评价
你的回答完美的解决了我的问题，谢谢！
来自:作业帮
其他类似问题
等待您来回答
下载知道APP
随时随地咨询
出门在外也不愁大神帮帮忙啊_百度知道
提问者采纳
提问者评价
你的回答完美的解决了我的问题，谢谢！
来自:作业帮
其他类似问题
按默认排序
其他1条回答
等待您来回答
下载知道APP
随时随地咨询
出门在外也不愁