Your sentence

Also, in both the tables there are duplicate records in all the columns. Each column has duplicate records. but at any time one particular ROW(Records) is not Duplicate with...

I have to agree Jeff, novice users with three datatypes and no understanding of why each of them is available. Recipe for more problems..

CEWII

I see them as two seperate entites. I see a user table and a subscriptions table. The user table would have a surrogate key (UserId?) and the username...

Basically it just needs to be a user, nothing special. Additional rights will be directly related to what you want it to do...

CEWII

Great..

CEWII

I would only do the blocks that are causing you problems.

CEWII

I think your problem is the optimizer doesn't realize what you've done and generates an error.

But if you execute your update logic, that whole section of code in something like...

Matt Whitfield (9/22/2009)

---

Elliott W (9/22/2009)

---

I have had pretty good experiences with TFS and Vault. I have been working with ClearCase and I hate that one, it usually works but...

#1 and #2 are a little different problem (I think)..

#1, You probably need to explicitly force the servername as opposed to using a file or a table. Because...

You might issue your fill logic dynamically using dynamic SQL. It will execute in a slightly different context and will be recompiled (which is the important part) by default. ...

Better memory use, better engine, better performance.. All things we experienced on the same hardware when we uninstalled 2005 SSAS and put in 2008 SSAS..

CEWII

I see your points, but I would say that there are circumstances that negate or mitigate each of your points and whether this particular problem that the poster is posing...

Ok, this is kind of rough but it generally does what we want.. The big thing is the query near the beginning, this would be where you would put...

stricknyn (9/22/2009)

---

Just an idea so bear with me I'm talking it out loud but here's how I think I'm going to do it:

1)In my stored procedure there will be a...

John Rowan (9/22/2009)

---

The package includes 10 variables, StartId and EndId for each of 5 dataflows....