Convert Number to Word in Crystal Report

How to write amount in word in crystal report. Today we are  discussing about to convert amount in word. i mean 12,082.00 in to "TWELVE THOUSAND EIGHTY-TWO ONLY" in Crystal report. if right(Totext({@total}),2)="00" then uppercase(ToWords({@total},0))+" "+"Only" else uppercase(ToWords({@total},0))+" AND  "+uppercase(ToWords(tonumber(right(Totext({@total}),2)),0))+" "+"Paisa  Only" ...

Read More

Create a Job in Sql Server

How to Create a job(Schedule) in Sql Server USE [msdb] GO BEGIN TRANSACTION DECLARE @ReturnCode INT SELECT @ReturnCode = 0 IF NOT EXISTS (SELECT name FROM msdb.dbo.syscategories WHERE name=N'[Uncategorized (Local)]' AND category_class=1) BEGIN EXEC @ReturnCode = msdb.dbo.sp_add_category @class=N'JOB', @type=N'LOCAL', @name=N'[Uncategorized (Local)]' IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback END DECLARE...

Read More

Update table with join

Update  table with join. We have two table with name s1 and s2 In first table s1 we have add1 column with null value. We have another table s2 that contains loc column . Now we need a sql query to update table s1 add1 column with second s2 loc column. Table name s1 id      Name                add1 1      Rahul                NULL 2      Ramu       ...

Read More

Crud operation in single page in mvc using Json

Today we discuss about the crud operation  in single page in  mvc 4 First we create model using linq to entity (using edmx file).                                                                     List of Users User Creation User Deletion  ...

Read More