Viewing 15 posts - 616 through 630 (of 1,183 total)
Dave,
You are indeed getting it wrong.:hehe:
You're confusing Foreign Keys with Indexes.
Read up on BOL on these topics and ask more questions after that. 🙂
______________________________________________________________________
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. SelburgFebruary 8, 2008 at 2:03 pm
And indexes are "pointers" to the physical location of the data. Think of them as floating on another layer or more appropriately as the index in the back of 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. SelburgFebruary 8, 2008 at 1:44 pm
Your question isn't clear to me.
Is Billing type supposed to result in 'Express Cash' or 'Payment Services'?
I mean you can
SELECT
CASE WHEN PROD = 'XCDD' AND...
______________________________________________________________________
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. SelburgFebruary 8, 2008 at 1:38 pm
Can you give us some sample data from t_Prod, 1,2 and 3? as well as some sample 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. SelburgFebruary 8, 2008 at 7:20 am
.... like restart the SQL services through Enterprise Manager. ....
AND
.... The latest is full text searches stopped working when we replace the SQL service account with a non-local administrative account....
______________________________________________________________________
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. SelburgJanuary 31, 2008 at 3:16 pm
If I understand you correctly, add a "dummy" parameter to the dataset that you're using for #2 that will come up if that particular parameter from #1 is selected.
______________________________________________________________________
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. SelburgJanuary 31, 2008 at 7:58 am
EDITED: Incorrectly used INNER join when LEFT is appropriate.
Matt's suggestion OR use the left join method ...
FROM
....
...
______________________________________________________________________
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. SelburgJanuary 24, 2008 at 11:15 am
"Books Online" It can be found
Start > Programs > Microsoft SQL Server 2005 > Documentation and Tutorials > SQL Server 2005 Books Online
______________________________________________________________________
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. SelburgJanuary 24, 2008 at 7:44 am
Read up on the PIVOT keyword in BOL or search this site. There are plenty of examples around. 😉
______________________________________________________________________
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. SelburgJanuary 24, 2008 at 7:37 am
Please read ... http://www.sqlservercentral.com/articles/Best+Practices/61537/ ... and repost your question. 😀
This also seems like a homework question. What have you tried already?
______________________________________________________________________
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. SelburgJanuary 23, 2008 at 2:36 pm
I fully understand joins, but I'm just not familiar with the older syntax (non-ANSI) standard use of them.
I've ran tests and it seems to be correct, I just wanted clarification...
______________________________________________________________________
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. SelburgJanuary 21, 2008 at 10:38 am
Thanks!
______________________________________________________________________
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. SelburgJanuary 11, 2008 at 10:58 am
Homework?
Read up on HAVING in BOL.
______________________________________________________________________
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. SelburgJanuary 11, 2008 at 8:40 am
What's your table definition, what keys/indexes are on it now?
Can you provide examples of the queries ran against it currently?
______________________________________________________________________
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. SelburgJanuary 10, 2008 at 2:24 pm
Read up on PIVOT and UNPIVOT in BOL. The answer is in there. 🙂
______________________________________________________________________
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. SelburgJanuary 9, 2008 at 12:14 pm
Viewing 15 posts - 616 through 630 (of 1,183 total)