Search results for query: *

Hi I will try to explain it better. For every item we have a full pallet amount and on every pallet there is a number of boxes, in my first example we have 4 boxes with 250 pcs in each adding up to 1000 pcs on the pallet. If they order 1000 pcs they will get a full pallet and if the order...

Hi Skip Our customer orders an amount but we don´t split any boxes. For every amount we need to calculate how many pallets we need to send and if the amount is more than any number of full pallets we need to round up to the nearest box multipel. As in the first example they order 1100pcs but...

Hi Need help finding out how many pallets and/or boxes an amount is and round up to the nearest pallet and/or box Example: Amount PalletQuant BoxQuant pallets boxes New amount 1100 1000 250 1 1 1250 900 1000 250 1...

Hi, I agree. Thank you Markros /Jonas

Hello I use SQL Server 2005 and I have a list of appr. 7700 items. In the list there is the complete stockquantity for each item and I halso have the typical amount for each pallet. I need a list with all individual pallets and its stock Item stock amount/pallet 100-001 2500 1000...

This work the first week of the month but not the weeks after that. I've tried this case when Month(Dateadd(wk,datediff(wk,0,getdate()),0))<> Month(getdate()) then dateadd(MM,datediff(MM,0,getdate()),0) else dateadd(wk,datediff(wk,0,Getdate()),0) end and it seems to be working I get first...

I´m using Reporting Services and display the report in Moss 2007 portal. It will run automatic every Saturday and a copy in Excel-format will be posted in this portal. But we want to run it manually sometimes too. /Jonas /Jonas

Yes, that is exactly what I need. /Jonas

I've tried this and it seems to be working SET @_WeekStartdate = case when Month(Dateadd(wk,datediff(wk,0,getdate()),0))<> Month(getdate()) then dateadd(MM,datediff(MM,0,getdate()),0) else dateadd(wk,datediff(wk,0,Getdate()),0) end IF Month(Monday this week) <> Month(Today) THEN First day of...

Thanks M. Alot nicer code than what I had but I think its the SET @s = where the trouble is. /Jonas

I don't have sample data. What I want is a count for how many working days it is between Monday (this week) - Today. But it has to within current month. I will run this report every week but if there is a month-break like it was in Sept-Oct (Sept 30 Tuesday)and I run the report on Thursday I...

@Enddate = Getdate() /Jonas

Hi Need some help finding out how many work days it is this week in the current month counting back from today I will use this to calculate a salesbudget for those days I have found in this forum solutions to how many workdays it is this week but I don´t know how to make it work for current...

Alot nicer... Thanks /Jonas

Sorry R937, you are dead on. It is the timepart that is the challenge. I've solved it using this code: Case when Year(ofh.regdat) >= YEAR(DATEADD(dd,- 8, GETDATE())) AND Month(ofh.regdat) >= MONTH(DATEADD(dd, - 8, GETDATE())) AND Day(ofh.regdat) >= DAY(DATEADD(dd, - 8, GETDATE())) AND...

Hello MS SQL Server 2005 I have a datetime field that contains a date set to midnight (2003-03-03 00:00:00) and I need to extract all records between today minus 8 days to today minus 1 day ( last seven full days). I there an easy way to do this? Thanks /Jonas

Hi I have a Seagate 250Gb s-ata disk that is "dead", from my HP media center pc. I got a pci-card to put into my Fujitsu computer so I could connect the sata-disk. Now my problem is that my Fujitsu-computer won´t start as long as the "dead" drive is connected. How do I get the computer to start...

Sorry This wasn´t supposed to end up here... /Jonas

Hi I have a Seagate 250Gb s-ata disk that is "dead", from my HP media center pc. I got a pci-card to put into my Fujitsu computer so I could connect the sata-disk. Now my problem is that my Fujitsu-computer won´t start as long as the "dead" drive is connected. How do I get the computer to start...

Now you earned yourself another star! Thank you LB /Jonas