Thanks for posting this. It is going to come in quite handy.

Kurt

I like door #2 better with the Left Join.... 😉

Kurt

ksatpute123 (9/23/2013)

---

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,

...

I find this thread interesting that it portrays the current need at the time to move data or databases around. We all know there are certain things that take...

Looking at this reinforces the fact that not all programmers are good programmers. Some coders just don't get it. Sorry.

Kurt

John Chapman (9/12/2013)

---

Some more points:

- Functions have some limitations (can't execute stored procedures or use temporary tables for example). Occasionally, this can bite because TTs allow for...

Is there a more specific error?

Kurt

When ever I have to rely on dynamic SQL I print it out before I execute it. This way I can see if there are any syntax errors in...

I worked on an application where by all tables in the database had audit information. The audit information contained Created By, Created Date, Updated By, Updated Date. All...

These are the kinds of utilities I tend to create over and over due to ever changing requirements. Case in point, I had to rebuild a mirror server from...

Typically is is bad practice to use SELECT *, especially when creating a view. I always make it a practice to fully qualify my selects. If this were...

Is this a homework assignment?

Kurt

This was my experience as well. I have battled with this printing issue for so long I have more or less given up on trying to print an ER...

Consider using an INSERT/UPDATE trigger on the table.

Kurt

pshaship (8/18/2011)

---

I want to run the below same query for 50 databases

How could we do that in single step instead of doing per database?

use [WSS_Content]

if not exists

(select * from...