Viewing 15 posts - 511 through 525 (of 1,183 total)
...and also look at CONTAINS.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgMay 12, 2008 at 9:08 am
You might also look into CONTAINSTABLE in BOL. It's a little more complicated, but I'd be willing to bet more flexibile and faster.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgMay 12, 2008 at 9:02 am
Peso beat me to it. 😛
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgMay 12, 2008 at 8:45 am
What constitutes SIMILAR?
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgMay 12, 2008 at 8:29 am
I'm thinking more of something that can be used to verify dynamic sql before running it within an sql procedure that builds the dynamic sql.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgMay 8, 2008 at 12:14 pm
Another way (less keystrokes) just multiply one side by 1.0
ISNULL(DROPPEDCALLS.Dropped, 0))/(Count(History.HistoryID) * 1.0)
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgMay 7, 2008 at 1:55 pm
There are an unlimited number of ways to answer this. Now, when I started out years ago I created a Chess database with all of the procedures to play a...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgMay 2, 2008 at 2:17 pm
Your way or create a function to do it.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgMay 2, 2008 at 1:51 pm
Search this site for a split function.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgMay 2, 2008 at 12:52 pm
You could call it an oilPrice table. :hehe:
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgMay 1, 2008 at 9:31 am
rbarryyoung (4/30/2008)
Just add an "ORDER BY Student, AttendDate" to the end of Jason's (Joel's?) query.
😛
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgMay 1, 2008 at 7:04 am
I was on the run to the North Pole mentioned here .. http://en.wikipedia.org/wiki/USS_Silversides_(SSN-679)
Now that was fun!
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgApril 30, 2008 at 7:24 pm
yeah, I got burned by that a few times before I started checking... LOL 😀
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgApril 30, 2008 at 6:25 pm
Sorry RBarry, but this is the SQL 2000 forum. ROW_NUMBER() isn't supported in 2000.
this solution will work though ...
DECLARE @students TABLE (student VARCHAR(20), attendDate DATETIME)
INSERT @students
SELECT 'student1','1/1/2008' UNION
SELECT 'student1','2/1/2008'...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgApril 30, 2008 at 4:36 pm
First we place a unique field on your table. This allows us to join it to itself for the update. We use ROW_NUMBER and PARTITION BY to get the numbers/results...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgApril 30, 2008 at 3:06 pm
Viewing 15 posts - 511 through 525 (of 1,183 total)