ok..

i give u temporary table for u try..

CREATE TABLE #tamp

( WeekNo INT, FromDate SMALLDATETIME, ThruDate SMALLDATETIME, Period VARCHAR(6) )

INSERT INTO #tamp VALUES (36,'2016-08-29','2016-09-04','201609')

INSERT INTO #tamp VALUES (37,'2016-09-05','2016-09-11','201609')

INSERT INTO #tamp VALUES...

thanks for your great answer...!

Yes, that's actually my design is calculating the formula based on the value of each rows. I made it because the user can freely adding any rows for a new...

thanks brother..

creating system DSN using odbcad32 and making linked server on sql server 2008 (x64) getting error when saving the connections..

it seems, system DSN that i created didn't detected on sql...

ODBC Driver for visual foxpro does not support x64 version of windows.

I've tried it..

yes.. it's get repeated seqno now based on field1, but it's sorted by field1.

it's not the...

I try to install SP3, but it came with errors:

GilaMonster (12/29/2014)

---

gentong.bocor (12/28/2014)

---

Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (Intel X86) Apr 2 2010 15:53:02 Copyright (c) Microsoft Corporation Standard Edition on Windows...

GilaMonster (12/22/2014)

---

HanShi (12/22/2014)

---

When connected to the proper SQL instance, execute "SELECT @@VERSION" in a (new) query window. The result will show you the edition of SQL Server and also states...

No.. i'm using SQL2008 on client, server also using SQL2008..

As GilaMonster said, the problem came from client accessing server. I checked from management studio on client and it's already SP3

Hi..

I just check SELECT @@VERSION from my local connections, and here it is..

Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (Intel X86) Apr 2 2010 15:53:02 ...

Hi..

How do i know if i already installed service pack or not yet ?

Thanks

Thanks for all your participation solving my query problem..

🙂