The easiest way to change the URL that users access the Report Manager with is to set up a DNS entry with the desired name pointing to the full address....

<retracted>

I believe the problem with the original statement was how SQL Server handles single. vs. double quotes. In your code, SQL Server was getting confused between the single quote...

I'm with HansVE and the others on the TinyInt split of the address. You can index those columns on any table that includes them and then join each of...

A very interesting article, which I have bookmarked for future reference. I, too, find SSIS difficult to learn coming from a VB/.NET/T-SQL background. I ended up building an...

Whatever others say, I think this is great. I have always needed the ability to execute a SQL Agent job from a web page in an on-demand fashion, and...

This is a great, albeit rather standard, technique for conditional WHERE clauses. Performance has never been an issue for me as long as the evaluated condition is efficient (i.e....

Richard Briggs (3/13/2009)

---

Hey Comrades

how about creating a Peristed Calulated column in your 'person' table.

The column would call one of the function solutions you have discussed.

This makes is easier...

This was perfect timing, Lynn, since I need to produce an Age column in a view for patients in our medical facility. Since I only need to know the...

For Irina: The error is coming from the report itself. It cannot find the DLL. Make sure you add the reference in your *report* project to the...

I have been getting column names with the data when copying the grid to Excel all along. I just click the blank square in the upper left corner of...

I agree with the last sentence in the editorial that project managers need to coordinate issues and then get out of the way. PM is a full time job...

I've always seen the distinct difference between front end/business app coding and database coding. They really are two separate disciplines, and any SQL against relational data can be hard...

Yes 🙂 Which is what has happened to...

I call the technique you mentioned a "brain stretch". Sometimes it involves talking with a co-worker about a topic outside work, sometimes it involves going home and letting the...