In a similar scenario in our system we have scheduled a call to a Stored Procedure which send mail to client using dbmail.

Please dont get me wrong here:-)

i meant in what format is it stored? Is it some file sort or what? Whats the unit of data stored...

Hope i am a bit...

Hope this helps...

declare @stmt nvarchar(max)

declare @whrcls nvarchar (max)

declare @param int

set @param=1

set @whrcls=''

set @stmt = 'SELECT SALESPERSON,

...

Thanks to forum (again) , i have something new to offer to my client...

@ John, this is my last option i know 🙂

Really a tedious task for a lazy person like me.

Anyways i am planning to write to the SSIS/RS team to...

I know the ETLs and Reports that are used but i do not have any list of tables which are being referenced by them. So i was looking for any...

In short my condition is all worst now... B'coz:(

1) Primarily this Database is for reporting purpose . There are customized user specific report too. Now the user may run a...

thanks Cindy,,, can be a good starting point.

Hi Shield,

Your logic was excellent... and will help me achieve what i wanted.

I learnt something new today 🙂

One more query :

Can we use CTE with SP, as in

;WITH cte...

My two cents:

select *,

CASE

WHEN DATEDIFF(WEEK,signing_date, entry_date)=1

THEN 'On Time Signing'

ELSE 'Exception Not within Time range'

END As TimeStatus

from example

result set:

2010-05-15 00:00:00.0002010-05-15 00:00:00.000Exception Not within Time...

i have to cleanse some data at back-end level, which was earlier done at front. so for that i was considering using a view/ or a temp table as a...

It worked ,,, thankx...:-)

I also have a similar scenario, (as suggested) i am trying to do the grouping at front end (SSRS report in my case)

Now the problem, when the results set size...

Hope this helps...

select * from cunsumption_detail

where

(form38_no like ('AA-[1-9][0-9]') and form38_no not like ('AA-10'))

or

form38_no like ('AA-10[0-9]') and form38_no like ('AA-110')

how abt this?

declare @month datetime

set @month = 'apr'+'1 2010'

SELECT DATEPART(MONTH, @month)

Cheers,,,