Hi Jones,
Is the position open for working remotely?

Thanks,
Ananda Kumar J.

Hi,
Could you please share your email ID to share the project details?

Thanks,
Ananda Kumar J.

Hi,
Could you please let me know where shall i post the quote for this work?

Thanks,
Ananda Kumar J.

Not able to reach the site with the link provided the Site. The answer could be

;WITH CTE

AS

(

SELECT SEQ, BINARYVALUE, 0 AS EXPO, CONVERT(NVARCHAR(4000),RIGHT(BINARYVALUE,1)) REMAINING

, CONVERT(NVARCHAR(4000),LEFT(BINARYVALUE,LEN(BINARYVALUE) - 1)) DEDUCTIBLE

FROM TC51

UNION...

The challenge can be easily handled in an another way like

WITH CTE1

AS

(

SELECT CODE, 1 AS ROWNUMBER, MAXROWNUMBER

FROM (

SELECT CODE, MAX(ROWNUMBER) MAXROWNUMBER

FROM ( SELECT CODE, ROW_NUMBER() OVER(PARTITION BY CODE ORDER...

It is an amazing idea.

this query might solve your issue

SELECT GETDATE() as A, convert(datetime,{fn CURDATE()}) as B

into #1

Select * FROM #1

Select * FROM #1 where A>{fn CURDATE()}

drop table #1

Hi,

You can use Select Convert(varchar(10),Field,Style)

The Style may be US Datetime, or UK Date time, if you want to know more on this, you can refer BOL.