Viewing 15 posts - 151 through 165 (of 1,132 total)
I naturally leaned towards the idea that the groups for sets and the awards form sets of groups so would go for a set based approach. Other guys in the...
June 25, 2009 at 10:10 am
The table datatype can be used as a function parameter, but defining the table type is a prerequisite to using it as a variable datatype.
Here is an example of...
June 25, 2009 at 9:05 am
This technique was documented by Erland Sommarskog, SQL Server MVP in 2004. The XML and other methods can be found in the classic article "Arrays and Lists in SQL...
June 25, 2009 at 4:07 am
Agree that the SQL for an after trigger appears simplier but try with a schema change and the after trigger.
Alter TABLE [dbo].[cnsmr_accnt]
add constraint cnsmr_accnt_PK primary key ( cnsmr_id )...
June 25, 2009 at 3:59 am
Figured out the problem with the trigger not matching the expected results as this requirement was missing:
When new rows for case_feed = '7' then:
The next sequence should begin after the...
June 25, 2009 at 3:12 am
The CPU Usage (%Processor Time) overall is at ~ 10% daily. Core 3 and 7 are at ~40%. The other 6 are all under 3%.
I think if you look further,...
June 24, 2009 at 7:02 pm
Paul, did not see this post until after I replied but we are getting the same result. I am going to start a new post thread.
June 24, 2009 at 3:51 pm
For the record, the script Carl posted runs fine and produces the expected output on my 2005 and 2008 servers.
Paul, thanks for checking.
My newly rebuilt business laptop has...
June 24, 2009 at 3:46 pm
Does anyone have an idea why row_number() in a trigger does not appear to work ? The exact same code in a batch works fine (substituting a temporary table...
June 24, 2009 at 1:23 pm
This is a WAG, but if a user database has any indexed views, the following options must be set before running DBREINDEX. Should not hurt to set the options...
June 24, 2009 at 1:14 pm
the use of Instead of trigger as opposed to for/after insert in my code.
When an insert occurs, the following actions occur and if there is an error in any of...
June 24, 2009 at 1:07 pm
Ahha - a colleague 😀
Just for fun, I created the same schema in SQLAnywhere but without the trigger and defined the foreign key constraints with the "on delete cascade" specification....
June 24, 2009 at 12:22 pm
You can try the below code but there may be a bug. If you run the first SQL, the row_number functions gives the expected result but not when included...
June 24, 2009 at 12:13 pm
Just in today's news:
$9.75 million settlement related to a massive data theft that occurred at the parent company of T.J. Maxx and Marshall's more than two years ago. ...
June 24, 2009 at 10:08 am
Can you post the create table statement please ?
http://www.sqlservercentral.com/articles/Best+Practices/61537/
June 24, 2009 at 9:50 am
Viewing 15 posts - 151 through 165 (of 1,132 total)