Alex koranteng (1/27/2013)

---

I have a Select statement based on few joins. When I run it on my development server and test development server, I am getting different rowcounts. I have...

Hi...welcome to the site.

its a bit difficult...

Hi...am a bit busy just at the mo....maybe someone else will...

Hi...everyone here provides their time and expertise free of charge ....so please be patient. 🙂

It will probably help us to help you if you could provide the results you...

great...look fwd to seeing the scripts

pbaldy (1/9/2013)

---

I appreciate your quick reply. I will do that research. The DatePart() function in Access has arguments that let you control this (specifically the "firstweekofyear" argument). ...

ok...what version...

Hi

seems you are new around here...so a big welcome ...hopefully you will find this site a friendly and helpful resource.

first off...you have posted in SQL 7 , 2000 forum...is...

suggest you search this site (and others) for "Calendar tables"....

weeks are generally peculiar to the industry/company...there is a lot of help out there if you care to read.

regards

further reading here may give you some ideas

http://www.sqlservercentral.com/articles/Hierarchy/94040/

http://www.sqlservercentral.com/articles/T-SQL/94570/

Steve

may be worth your while posting some "base data examples" here...

Steve

I would entirely agree with your comment and...

+1

CREATE TABLE [dbo].[mydate](

[mydate] [datetime] NULL

)

INSERT INTO [dbo].[mydate]([mydate])

SELECT '20121222 00:00:00.000' UNION ALL

SELECT '20121223 00:00:00.000' UNION ALL

SELECT '20121224 00:00:00.000' UNION ALL

SELECT '20121225 00:00:00.000' UNION ALL

SELECT '20121226 00:00:00.000' UNION ALL

SELECT '20121227 00:00:00.000'...

karna5999 (1/6/2013)

---

How do I evenly divide $10752.00 into 7 In SSIS ?

(even division of a decimal)

For example:$102.10 / 2

Result:-

...