Viewing 14 posts - 16 through 29 (of 29 total)
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...
November 24, 2009 at 9:10 am
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...
August 19, 2009 at 9:31 am
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...
August 18, 2009 at 6:40 am
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...
June 5, 2009 at 7:41 am
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....
June 1, 2009 at 6:14 am
Richard Briggs (3/13/2009)
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...
March 13, 2009 at 7:01 am
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...
March 13, 2009 at 6:57 am
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...
March 9, 2009 at 6:35 am
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...
November 5, 2008 at 6:37 am
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...
October 9, 2008 at 7:56 am
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...
September 19, 2008 at 7:16 am
jim.powers (8/21/2008)
Hmm... If I don't have the same high-energy and need the occasional break, does that mean I'm getting old? 😛
Yes 🙂 Which is what has happened to...
August 21, 2008 at 7:21 am
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...
August 21, 2008 at 7:08 am
Viewing 14 posts - 16 through 29 (of 29 total)