Viewing 15 posts - 151 through 165 (of 1,183 total)
What differentiates 720 as AM vs PM?
______________________________________________________________________
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, 2012 at 1:30 pm
count(distinct i.inv_NUMBER)
______________________________________________________________________
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, 2012 at 1:25 pm
As with anything in SQL, it depends. This is more than one way to get the desired results and my suggestion is in no way intended to be taken as...
______________________________________________________________________
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, 2012 at 12:28 pm
SQLKicksButt (1/23/2012)
______________________________________________________________________
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, 2012 at 12:15 pm
Break down the properties into their own set.
Something similar to ...
Applicance
ApplianceId INT
Model VARCHAR(50)
Manufacturer VARCHAR(50)
...
______________________________________________________________________
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, 2012 at 11:57 am
Because the MONEY data type only goes out to 4 decimal places. The extraneous value of 0.00004608518933991 is dropped by rounding.
SET nocount ON
DECLARE @num1MONEY
DECLARE @num2MONEY
DECLARE @num3MONEY
SET @num1 = 2642.7100
SET...
______________________________________________________________________
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, 2012 at 9:58 am
...and if you decide to use SQL and not move this pivot to the presentation layer. What you would do is pivot with two seperate statements and join them. Either...
______________________________________________________________________
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 17, 2012 at 1:58 pm
Please read the article referenced in my signature. It will help us help you. 🙂
______________________________________________________________________
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 17, 2012 at 1:29 pm
Adding to the above suggestions. This site is a huge resource. Monitor the active threads as much as you can. If someone posts a question you don't know the answer...
______________________________________________________________________
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 17, 2012 at 1:24 pm
Sounds like an ideal situation for a Report Model. There are numerous tutorials available if you google 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. SelburgJanuary 17, 2012 at 8:09 am
good catch, we need to also include the date. One way to do this is to get the number of days since 1/1/1900
SELECT
*
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 16, 2012 at 2:07 pm
SQL Kiwi (1/16/2012)
SELECT
Segmented.ID,
Segmented.UserID,
Segmented.Location,
Segmented.LocationDate
FROM
(
SELECT
...
______________________________________________________________________
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 16, 2012 at 1:38 pm
So what happens in the case of identical rows that chain longer than 5 minutes?
i.e.
123,‘Columbus’,‘1/5/2012 8:00 PM’
123,‘Columbus’,‘1/5/2012 8:04 PM’
123,‘Columbus’,‘1/5/2012 8:08 PM’
123,‘Columbus’,‘1/5/2012 8:12 PM’
They all occur within 5 minutes of each...
______________________________________________________________________
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 16, 2012 at 1:26 pm
Please read the post linked in my signature. This will help us help you. 😛
______________________________________________________________________
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 16, 2012 at 1:01 pm
Another tool to keep in mind is the SQL Server Migration Assistant (SSMA) found here.
It may not show you the differences, but may help in your overall project/scope.
______________________________________________________________________
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 16, 2012 at 8:19 am
Viewing 15 posts - 151 through 165 (of 1,183 total)