As requirement owner says there is no much flexibility in SSIS as in T-Sql query, so decided not to use SSIS, as I know BCP and others are used mostly...

No this is a project requirement:-)

This is a requirement. I have to do with out using SSIS, 🙂

The solution u gave will work fine, but how to know the current date format in sql, so that i can give that dateformat as

SET DATEFORMAT Current Date Format...

;WITH cte as

(

SELECT id,name,

,

,topid FROM tree WHERE topid = 0

UNION all

SELECT t1.id, t1.name,t1.[Left],t1.

,t1.TopId

FROM tree t1

JOIN cte c ON c.id = t1.topid AND c.

= t1.Id

)

SELECT * FROM...

Hi,

I tried with recursive cte and self join. But not getting required output:-)

Thanks to everyone 🙂

Thanks Florian Reischl

ur query wil perform better than mine

Thanks Christopher Stobbs

Ur Query is performing btter than mine:-)

Hi

Gianluca Sartori

declare @tbl table(id int)

insert @tbl select 12

insert @tbl select 13

insert @tbl select 16

insert @tbl select 17

insert @tbl select 18

insert @tbl select 15

insert @tbl...

Hi,

I saw in Profiler,ur query wil perform poorly than my query.Urs wil take

twice as much as reads and cpu and duration of my...

execute sp_helptext 'ProcedureName' to get the script for Procedure

hi, U sent

with cte as (select *,Row_number() over(order by id) as rownumber,

count(*) over() as total from TableName)

select * from cte where rownumber between some integers

ok its...

the precedence of OR & AND & NOT goes with brackets i think.

select * from temp where (loginname='Raj' AND password='abcd')

OR FirstName='Raju'

here both (loginname and password) acts s one...