Viewing 15 posts - 136 through 150 (of 178 total)
What would be the reason(s) that an Update trigger would not be able to handle this by comparing the before and after version of the records and writing a summary...
January 14, 2008 at 7:43 am
Without knowing more about the interrelationship of the fields and tables, my initial guess would be your WHERE clause is limiting the result set?
Toni
January 11, 2008 at 5:28 pm
You would join the tables and then get the count. -- better example
select f.fieldesc, count(o.fieldid)
from fruits f
left join orders o on f.fruitid =...
January 7, 2008 at 10:11 am
Try using Convert and Replace to change the comma to another character (like @) then change the '.' to comma(s) finally change the other character (@) to a dot. ...
January 3, 2008 at 9:24 am
You can use the CHECK constraint either when you create the table or add it via an ALTER command. In the check constraint you can check the value...
January 3, 2008 at 8:31 am
Glad to be able to help Wayne. At least I got the concept right 😉
oh and it is Toni (as in Toni Marie) not Tony (as...
December 28, 2007 at 7:47 am
TO expand on my prior post. The code below would return just 0x from the table
Toni /* added a second example */
declare @temp table...
December 28, 2007 at 7:22 am
did you try using DATALENGTH function to limit the length to 2? (Writeup from BOL is below)
Toni
DATALENGTH
Returns the number of bytes used to represent any expression.
Syntax
DATALENGTH...
December 28, 2007 at 7:12 am
To use the Index Tuning Wizard you can capture a workload via Profiler or use one from the Query Analyzer Query window. You specify the database, level...
December 28, 2007 at 6:31 am
Ok... I tested with all dates the same and it returns one row per account due to the Group by clause.
So I am still wondering what you saw Ananth?
Toni
December 27, 2007 at 6:18 am
Ananth, first you could add the TOP n clause to the outer select if you needed to;however, based on the specs I don't believe returning all the invoices is wrong...
December 27, 2007 at 6:04 am
Ok.. maybe someone else can verify and/or adjust my observation but it looks like you are joining two tables with many-to-many relationship and getting lots of duplicate data.
This might...
December 22, 2007 at 4:59 pm
Perhaps if you could supply some test data to be sure I am addressing the right problem that would help.
It would be good to see what you are actually trying...
December 22, 2007 at 7:42 am
Viewing 15 posts - 136 through 150 (of 178 total)