Viewing 15 posts - 241 through 255 (of 284 total)
perireddy.arikatla (9/21/2013)
I Think I Explained This Time Clearly
A bit more clearer:rolleyes:. But again, this would be easier to come up with a solution if DLL and insert statements...
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
September 21, 2013 at 11:09 pm
perireddy.arikatla (9/21/2013)
But it was not fulfill my request.
select party_code, sum(inst_amt) as Total_instamt, sum(paid_amt) as paid
from @table1
where paid_date < '2012-11-27'
group by party_code
The previously posted query...
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
September 21, 2013 at 10:16 am
Don Halloran (9/18/2013)
select ceiling(floor(@somevalue) / 5.0) * 5.0
A MUCH better solution!
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
September 18, 2013 at 6:06 pm
Luis Cazares (9/18/2013)
Am I missing something or would something like this will work correctly and much faster than the cursor?
LinksUp (9/18/2013)
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
September 18, 2013 at 3:29 pm
I know you posted a solution that works for you, but if you could humor me. . .
Could you try the following code? I am interested to know if it...
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
September 18, 2013 at 3:24 pm
I did not see a way to do this without multiple update statements. But since this is a clean up job, running 2 updates should not be a big deal!
Try...
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
September 18, 2013 at 1:00 pm
What I was trying for was
612 720
Now we get to the crux of the issue. The null thing was a red herring. It had nothing to do with what you...
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
September 17, 2013 at 7:09 pm
Study up on constraints as well as Foreign Keys. These help keep the "bad" data out of the database regardless of where the data is coming from.
As you saw...
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
September 17, 2013 at 4:00 pm
As was requested by Mr. Lange, PROPERLY FORMED DLL, insert statements and expected output make it easier to provide a tested solution. So, the following is just air code that...
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
September 17, 2013 at 2:28 pm
INSERT INTO #Total_Count (NUM_DEATHS_1870, NUM_DEATHS_1880)
(SELECT COUNT (*), 0
FROM [dbo].[1870_1880_DAT]
WHERE YR_Died = '1870')
INSERT INTO #Total_Count (NUM_DEATHS_1870, NUM_DEATHS_1880)
(SELECT 0, COUNT (*)
FROM [dbo].[1870_1880_DAT]
WHERE YR_Died = 1880)
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
September 16, 2013 at 10:32 pm
Your posted DLL is not complete. So nobody can run your code to see how it works. Creation and insert statements are needed for [dbo].[1870_1880_DAT]
How do you remove the nulls?...
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
September 16, 2013 at 8:56 pm
This link might be helpful.
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
September 14, 2013 at 11:34 pm
You have a query that returns 99.9% of what you want. All that is needed is to subtract the 2 weights.
select *, two.ITM$Weight - one.ITM$Weight as WeightDiff
from etc...
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
September 14, 2013 at 8:34 am
This query does what you requested with the provided dll and data.
;WITH cte(col) as (
SELECT col from #table1
...
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
September 13, 2013 at 11:38 pm
smrobin (9/13/2013)
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
September 13, 2013 at 3:40 pm
Viewing 15 posts - 241 through 255 (of 284 total)