WITH cte_insert_report_recipients

AS

(

select a.*,CONVERT(VARCHAR(10),a.[ATID])

+ CONVERT(VARCHAR(10),[AID])

+ CONVERT(VARCHAR(10),a.[ReportID])

+ CONVERT(VARCHAR(10),a.[Frequency])

+ CONVERT(VARCHAR(10),a.[RecipientId])

+ CONVERT(VARCHAR(10),a.[DeliveryMethod]) [ID] from ReportSchedules a

)

insert into ReportRecipients

select

b.ReportID,

b.ATID,

...

Didn't get the point but definitely learned something. Way to go!

Easy one. Thanks.

Easy and educational. Thanks.

+1

Ahh! Too many posts and none adding any value to the topic of discussion.

Wrong question or not, if it was able to teach you something new or refresh your...

I am thinking the post was deliberately designed to confuse.

One can clearly see without even executing the statement that result should be 0 because of string truncation.

If all strings have...

http://technet.microsoft.com/en-us/library/ff486956.aspx

I believe the question was picked directly from here.

Easy one. Thanks

Here's a pretty good example with proper explanation on use of NTILE.

http://www.databasejournal.com/features/mssql/article.php/3780311/Exploring-SQL-2005146s-Ranking-Functions-150-NTILE-and-ROWNUMBER.htm

WOW... Thanks for organizing it so neatly. Exactly what the question was intended for.

I don't know how to give points back but I will keep in mind what you said the next time I post a question.

Still I think this is pretty clear....

Thank YOU all for the encouragement.

The SQL bug bite is just beginning to take effect for me. 🙂

Sorry for the late reply. Thanks for your feedback.

Calling the referenced object a "child" of the dbobject was something of requirement at my end. I assumed people using the code...

Thank you for the feedback guys. A lot of valid points raised and I will certainly look into these.

I posted this based on the tests I did on my end...