These are actually views rather objects; which should not make any difference in the query execution as such. And since I have an access to the schema's should have...

I am not sure this fits the bill, but check this link out and see if you can tweak things out.

http://www.scarydba.com/2010/10/18/powershell-is-really-easy-if-you-know-what-youre-doing/

Nice example; However this should not have had happened in the first place; and seems kind of weird. We upgraded the DB with a newer version of our build and...

Darn! I knew it wasn't that complicated, I have used XML 'n' number of times before as well to concatenate the columns. If only I would have stressed my self...

How would i get to Identify which columns have been got set to 1, ie. If I had to represent the column names with a comma seperated list ?The one...

Great work! Thanks for the inputs . The article was very helpful to understand the implementation, however reverse engineering it was a bit difficult.

@andrew's solution worked like a...

Included the solution; You might wanna fiddle around it for different solution

But there is more fun in finding the solution as @seth pointed. Also make sure you check the...

Follow this article and it should be able to guide you.

http://www.sqlservercentral.com/articles/Best+Practices/61537/

Thanks Celko, It did work, I modified/tweaked your solution according my needs and it seems to be giving the correct output and since the stores are not going to be...

Thanks for your inputs Celko;

However I want to tell you that this is not even a correct depiction of our DB and is just a crude scratch display of...

Was this so simple? It seems to do the work though

SELECT o.SToreID,a.Names, CASE WHEN a.Names = s.PrimaryName THEN 'Primary' ELSE 'Secondary' END AS Source

FROM #Occurence o

INNER JOIN #Store s

ON...

Since you have already Grouped them by dealer's;

You just had to add the Having clause to get the count > 3

SELECT DealerName

, COUNT(DealerName) AS DealerCount

FROM Dealer

GROUP BY DealerName

HAVING...

That figures out to be one of the solution, but it is not much practical as of now, since we have multiple stores in the DB and reports would be...

If you had followed sean's advice you would have reached to a solution.

Anyways here it is; try to read what others are indicating , it might help

select

case

when (file like...

Yes you are right; Different stores will have different vlaues configured in the DB; and hence different values for the column aliases. All combinations to the views could be included,...