pls try below code

SELECT * FROM iaxChecksCurrent

WHERE

CONVERT(varchar(10),UploadDate,120) = '2012-07-18'

pls check any inner query take more time that time you will use temporary tables.

and also use with(nolock) option in that query.

in third table actual your data same id have multiple zip code.

could you please check it third table have unique id's are not..

THANKS IT IS WORKING

actual here logic is one month some employee is working same project in

same country what time i will pick up where en_dt is null

else

one month some employee is...

pls try below code

you are find the error.

step 1:

declare @par varchar(10)=''

select LEFT(@par,len(@par)-1)

step2:

declare @par1 varchar(10)='abd'

select LEFT(@par1,len(@par1)-1)

Thanks for give replay.

can you tell me.

above query which output need.

PLS TRY BELOW CODE.

DECLARE @T1 TABLE(ID INT,NAME VARCHAR(30))

INSERT INTO @T1(ID,NAME)

SELECT 1,'AA'

UNION

SELECT 2,'BB'

UNION

SELECT 3,'"Application''s"'

UNION

SELECT 4,'"Application"'

SELECT * FROM @T1

WHERE NAME LIKE '"Application%'

FIRST USE:SP_WHO2 ACTIVE COMMAND FILE IN MASTER DATABASE:

THAT TIME YOU WILL GET SOME OUT PUT.

pls check bikby column .

if any id was showing that column.

pls use that id below mentation...

pls try below code

declare @month int=7

declare @t1 table(empid int,month int,sal int,cont int)

insert into @t1 values(1,6,1,2)

insert into @t1 values(1,6,2,4)

insert into @t1 values(1,6,3,2)

insert into @t1 values(2,6,1,2)

insert into @t1 values(2,6,2,4)

insert into @t1...

pls check below url

http://www.rad.pasfu.com/index.php?/archives/18-Foreach-Loop-based-on-Variable-SSIS.html

Use row number transformations.

PLS TRY BELOW CODE

SELECT DATEADD(MM,DATEDIFF(MM,0,GETDATE()),0)

DECLARE @date datetime = '2012/06/20 11:05:02 PM'

DECLARE @HH INT=SUBSTRING(CONVERT(VARCHAR(10),@DATE,108),1,CHARINDEX(':',CONVERT(VARCHAR(10),@DATE,108))-1)

SELECT CONVERT(CHAR(10), CONVERT(datetime, @date,103),101)+' '+CONVERT(VARCHAR(10),CASE WHEN @date LIKE '% PM' THEN

...