Comments by BinnyVishwant

BinnyVishwant 9-Jan-18 12:47pm View

its a value

BinnyVishwant 17-Jul-17 4:32am View

Could you please explain clearly! what exactly you need to do/required?

BinnyVishwant 13-Jul-17 5:22am View

try to give alias name before FOR

" )as a
FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)') ,1,1,'')"

BinnyVishwant 13-Jul-17 5:09am View

Also try to execute only the select stmt first and check whether you are getting required resuts! by giving your databasename manually

BinnyVishwant 13-Jul-17 5:08am View

can you try to remove onedot(.)i,e. farvisiondb..M_STATEWISEGSTINACTAG >
farvisiondb.M_STATEWISEGSTINACTAG

BinnyVishwant 13-Jul-17 4:36am View

Is this working for JKUMARJV db?

BinnyVishwant 25-May-17 9:13am View

Here is my take:

i have given you some sample format
Sql:

declare @somedaysago datetime
declare @now datetime
set @now = '2013-08-02'
set @somedaysago = dateadd(day,1388,@now)

select @now, @somedaysago

select dateadd(day, 1388, @now)

SSIS:

DATEADD("dd", 1388, GETDATE())

The equivalent SSIS expression is DATEADD("day", 1388, GETDATE()).
The keywords for the "datepart" argument in SSIS are not the same as in T-SQL

BinnyVishwant 24-May-17 4:17am View

could you explain it clearly, why you have repeated twice 2017-05-22,2017-05-22.

Comments by BinnyVishwant (Top 8 by date)