Viewing 15 posts - 106 through 120 (of 345 total)
For the delete, make MasterReviewID on PeerReview reference MasterReview with a cascading delete.
But for the insert, I don't quite get it...what values will you use in the PeerReview when inserting...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
November 2, 2011 at 3:13 pm
CherylNH (10/31/2011)
Thanks for your reply, but this is a SQL2008 database, not an Access database, so the .LDB would normally exist.Cheryl
Brings up an interesting question: why are the extensions MDB...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
November 1, 2011 at 1:11 pm
Tallboy (10/20/2011)
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
October 27, 2011 at 12:13 pm
Apparently so:
http://msdn.microsoft.com/en-us/library/ms165629(v=sql.90).aspx
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
October 25, 2011 at 1:09 pm
Post the trigger code so we can take a look.
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
October 25, 2011 at 8:11 am
i have this code in where clause RTRIM(LTRIM(ODER_ID))= ' ',WHAT THis do
It filters out rows with non-blank oder_id values. RTRIM and LTRIM simply remove spaces from a string on the...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
October 21, 2011 at 7:43 am
So what is the error?
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
October 21, 2011 at 7:08 am
I knew I had this working properly at one time...my memory isn't what I remember it used to be. :w00t:
Include the commas in the string, like so:
declare @Codes varchar(25) =...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
October 20, 2011 at 7:03 am
The OP didn't give the data type of table_Type_Codes, so I worked my example as it being a varchar. But it's a simple adjustment if the column is an int.
create...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
October 19, 2011 at 3:19 pm
Here is a second option. Will not be as performant as the splitter option.
Declare @Type_Code varchar(50)
set @Type_Code = '4,11,12'
Select * from table_Type_Codes Where @Type_Code like '%' + table_Type_Codes +...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
October 19, 2011 at 2:45 pm
Nice solution, Drew. Very smooth.
OP, if you want the extra non-matches to not show, thrown a WHERE n.Name IS NOT NULL
AND s.Code IS NOT NULL; to the end of...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
October 18, 2011 at 11:53 am
What is your criteria for determining which code goes to which name?
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
October 18, 2011 at 10:58 am
I didn't think about it at first, but calculating the time like "where DATEPART(hour,(DateTested)) between 7 AND 16;" won't work. Use something like "where CAST(DateTested as Time) between '07:00' AND...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
October 17, 2011 at 10:00 am
Not sure why you're doing an aggregate or a group by or one query...if you want the data separated into 3 temp tables, then copy them into 3 temp tables....
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
October 17, 2011 at 9:31 am
R_S (10/13/2011)
The simplest method to refresh is to take a backup and restore the latest production copy
I can't just copy the production database again because I removed some tables and...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
October 13, 2011 at 12:19 pm
Viewing 15 posts - 106 through 120 (of 345 total)