I agree with the above replies - there's no one-size-fits-all, and the role ranges from infrastructure to development. I'm in a "Database Administrator" role where I spend the large majority...

This looks like a homework assignment. If you're genuinely going to be working with this stuff, I suggest you look into how to write SQL - the basics aren't overly...

This looks like a homework assignment. If you're genuinely going to be working with this stuff, I suggest you look into how to write SQL - the basics aren't overly...

Thanks Orlando, that's exactly what I was after! Thank-you also for the great ideas Luis and Ishanahan, they will help with clarity going forward :-).

Thanks Orlando, the Hungarian notation is enforced by management, it's not by preference :-).

The situation I have is where a previous developer has left a system with large stored...

Thanks - it's good to know heavily commenting reasonably standard code isn't recommended.

What about if you had a large (3000+ line) stored procedure from a previous developer that you...

wendy elizabeth (11/30/2015)

jassie1

1h

1 ?

?

I am creating a new SSRS 2008 report and I am placing an return address in...

Do you see the Report Server Project" type (under Business Intelligence) in the Visual Studio "New Project" window? This requires "SQL Server Data Tools - Business Intelligence" to be installed...

The "Database Project" project type in Visual Studio is for database schemas (stored procedures, table definitions etc.). Your SSRS reports should be in a "Report Server Project".

Do you have...

Ahhh, I see the...

RE: the answers in this thread

You guys are joking, right? right guys? :blink:

Edit: removed, I think I've misunderstood the question.

Would something like this work?

SELECT DISTINCT UniqID

FROM <table>

WHERE Code = 'ABC'

or

SELECT UniqID, CODE

FROM <table>

WHERE Code = 'ABC'

Edit: I've misunderstood the query, and have updated my answer to something more appropriate.

Ahh, you're right. Thanks Phil - I hadn't expected this to be such a common question - the first page of a Google search is full of answers :blush:.

I've just done some benchmarks of my own, and they appear to be the same when there are no indexes that could have been used.

Using a function on a...