Just to be sure we are on the same page. When you say you delete the data in the destination table, are you doing a DELETE or TRUNCATE?

Have you...

I would try and help, but not having an issue connecting to SSIS, so I'm not sure what help I can provide. Maybe a little more detail as to...

Just a guess, did you know it existed a year ago?

It is awesome some of the ideas and help you can get from people here!

😎

Or

SELECT

*

FROM

dbo.tblData

WHERE

MonthID between ((3 * @Quarter) - 2) and (3 * @Quarter)

If MonthID is indexed, you still get the...

Roy Ernest (3/18/2008)

---

How in heavens name did we end up with exotic food when talking about interview:D

Since the topic is already there, has anyone had Bat? You know , the...

jfletcher (3/18/2008)

---

I tried your suggestion and it looks like it worked. I wanted one occurance of each MRN no matter which table it appeared in or in both and...

Okay, I am confused, but I would have sworn you asked for help in locking out the DBA at client sites from your application database and from outside your application....

CTE's are not for every situation. Since you are already creating and populating one or more temp tables, using CTE's in those sprocs may not be appropriate. You...

You aren't going to be able to lock out an individual with system adaministration privledges in SQL Server. This privledge grants access to all databases and their objects. ...

You can't index a CTE, just like you can't index a derived table. It should, however, use the appropriate index(es) of the table(s) referenced in the CTE.

😎

I have to agree with GSquared and Jeff. I like CTE's as well. when you have a complex query that uses a derived table, it makes the code...

Here is what i have found. You have a couple of columns that have a different collation from both the database as well as other columns in the table...

Yes: Tools, Options, scripting. There is an option under Table and View options to include collation. That should be set to true.

I tested it on one of...

From the select statement, can't really help. I need two things: the DDL for the table (or tables) including collation for character based fields (need to know what collation...

I will agree.