tag:blogger.com,1999:blog-7805972021499203804.post7585124598543005545..comments2023-10-30T06:24:14.411-07:00Comments on ASP.NET,C#.NET,VB.NET,JQuery,JavaScript,Gridview: SQL Server - Conversion Failed when Converting the Varchar Value '24,' to Data Type int Suresh Dasarihttp://www.blogger.com/profile/01337689983379917267noreply@blogger.comBlogger7125tag:blogger.com,1999:blog-7805972021499203804.post-36893614083719684722016-02-24T23:11:21.050-08:002016-02-24T23:11:21.050-08:00Thanks a lot. It worked like a charmThanks a lot. It worked like a charmAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-44720728308066150702015-11-04T21:17:31.876-08:002015-11-04T21:17:31.876-08:00declare @a as varchar(100)='Service_Name'
...declare @a as varchar(100)='Service_Name'<br /> declare @b as varchar(100)='Amount'<br /> declare @sql as varchar(MAX)<br /> <br /> SET @sql='select' +CAST(@a as int) + ',' + count (@b) + ' As total from <br /> CenterWise' + ' GROUP by ' + @a <br /> EXEC (@sql) <br /><br /><br />Msg 245, Level 16, State 1, Line 5<br />Conversion failedAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-29305054982613496202015-07-28T23:18:15.015-07:002015-07-28T23:18:15.015-07:00HELLO,i have problem regarding "Conversion fa...HELLO,i have problem regarding "Conversion failed when converting the varchar value '{SESSION|userID}' to data type int" issue. someone please help me<br /><br />SELECT STF_NAMA<br />FROM HR_STAF_PERIBADI HP<br />JOIN PRUSER PR ON HP.STF_USERNAME=PR.USERNAME<br />WHERE PR.USERID= '{SESSION|userID}'Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-45353998722508875962015-02-09T02:35:14.259-08:002015-02-09T02:35:14.259-08:00Error while executing below code:
Conversion faile... Error while executing below code:<br />Conversion failed when converting the varchar value ' and c.name not in (select columnName from dbo.ATMcol)' to data type int.<br /><br /><br />DECLARE @SQLQuery AS VARCHAR(4000)<br /> set @SQLQuery=' and c.name not in (select columnName from dbo.ATMcol)'<br /> SELECT c.name 'ColumnName',t.Name 'Datatype',<br /> ( case whenEr Vikas Sangalhttps://www.blogger.com/profile/05163131832814249563noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-61255217400901581192014-02-02T22:31:41.148-08:002014-02-02T22:31:41.148-08:00i have into a procedure :
CAST(null as varchar(...i have into a procedure : <br /><br /><br />CAST(null as varchar(300)) as RefText,<br /><br />set RefText = case when NumeroContratto is null then '' else 'Rif. Contratto N.' + NumeroContratto + ' Periodo: dal ' + convert (varchar(10), DaDataContratto, 5 )+ ' al ' + convert (varchar(10), ADataContratto, 5 ) + char(13) + char(10) + char(10)end<br /><br /><br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-6936046828227328332014-02-02T22:27:14.994-08:002014-02-02T22:27:14.994-08:00I have a problem into a procedure :
CAST(null as ...I have a problem into a procedure :<br />CAST(null as varchar(300)) as RefText,<br />set RefText = case when ContractNumber is null then ' ' else 'Contract N.' + ContractNumber + ' Period: from ' + convert (varchar(10), FromContractDate, 5 )+ ' to ' + convert (varchar(10), ToContractDate, 5 ) + char(13) + char(10) + char(10)end<br /><br />When I try tu run Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-53372178528353764102013-07-17T22:32:35.461-07:002013-07-17T22:32:35.461-07:00Thanks Suresh .....Thanks Suresh .....Dhirajhttps://www.blogger.com/profile/15105906827359903668noreply@blogger.com