Viewing 15 posts - 1 through 15 (of 18 total)
I have mixed feelings about the exams. I am interested to know why you are taking it. Is this to enhance your career, for personal reasons, more pay, a promotion...
June 29, 2009 at 3:10 pm
Well after much deliberation I gave up with the idea of a constant line in the Y axis favouring instead a progress time bar across the top of the report...
June 29, 2009 at 2:51 pm
Great article! I have this working but one problem still remains. I want to introduce a constant line in the Y-axis to display where "TODAY" is in the Gantt chart.
I...
June 17, 2009 at 8:50 am
NO. There is no need to insert any NULLS into the base tables. After all, they are already NULL which is why you are going to use ISNULL to get...
January 20, 2009 at 5:34 am
The simple answer is to use ISNULL function around the field that could be NULL so that you return a value instead of NULL, e.g. empty string ('') or 0.
Si
January 20, 2009 at 3:59 am
I think it is just part of SQL Server 2005 client tools so will be available on all versions of SQL Server 2005 although on express edition I think there...
January 20, 2009 at 3:24 am
I could be mis-interpreting what you are saying here (forgive me if so) but two points of interest relating to your last post:-
1. An update statement will only update one...
January 19, 2009 at 12:43 pm
Look up the INNER JOIN syntax in books online 😉
Si
January 14, 2009 at 12:56 pm
Yes it is a bit weird. In SQL 2005 you have the mandatory requirement to enter a semi-colon at the end of the statement that immediately precedes the use of...
January 14, 2009 at 12:50 pm
Pleas take a look at the script bellow and play with it. I think it shows that the check constraint is being checked after the record was inserted into...
January 14, 2009 at 12:38 pm
CHECK constraints happen BEFORE the command occurs. It is triggers that happen AFTER the command occurs, hence why CHECK CONSTRAINTS are recommended over triggers when you are dealing with checking...
January 14, 2009 at 8:09 am
What is your business rule?
I have always used 1 to represent success and 0 for fail as the return value in a user defined function used as a check constraint....
January 14, 2009 at 8:00 am
Just something to think about really since I don't know what your table design looks like for the Ingredient table and all the ways possible for you to populate values...
January 13, 2009 at 4:17 am
Perhaps an obvious question but is the quantity of data the same on each DEV_SERVER as many organisations run different projects on different DEV servers resulting in completely different volumes...
January 12, 2009 at 6:28 am
This looks like 2 INSERT statements, one with a LEFT OUTER JOIN required and one without so a simple way around this is to put the IF condition at the...
January 9, 2009 at 5:54 am
Viewing 15 posts - 1 through 15 (of 18 total)