Jeff Moden (8/7/2011)

---

sqlfriends (8/5/2011)

---

I would like to do some testing on a testing box for installation.

Our production server will be enterprise version

For the license issue, can I just use developer...

sravnmaganti

Does the data below, accurately display the data in your flat file?

NUM FNAME LNAME COUNTRY CITY ...

Greg Edwards-268690 (8/5/2011)

---

Ninja's_RGR'us (8/5/2011)

---

Is it even possible?

@steve-2, what is the oldest post that didn't get answered?...

James Tech (8/5/2011)

---

bitbucket-25253 (8/5/2011)

---

Another approach is to "clean up" the duplicates by using a CTE. ....

Have not tested the above code on a record set as large as those...

Have you looked right here on SCC

http://www.sqlservercentral.com/stairway/72382/

Now the series is not complete, but it will give you a start. Who knows it might be enough but as the old...

Another approach is to "clean up" the duplicates by using a CTE. For example:

CREATE TABLE #T(Date_Stamp DATETIME,KW1 DECIMAL(5,1), KW2 DECIMAL(5,1))

INSERT INTO #T

SELECT '12/10/2010', 5.3, 3.1 UNION ALL

SELECT '12/10/2010', 5.3,...

To get a tested reply to your question, please, sample data and expected results from that sample data.

To do so quickly and easily click on the first link in my...

Glad I had finished my first cup of morning coffee to wake up that part of my mind that thinks logically.

Thanks, a nice way to end the week, now hoping...

From the link in my prior post .. have some fun with finding the 1st day of the prior month

DECLARE @I INT

SET @I = 0

WHILE @I < 13

...

Here is a large number of date routines that you might want to save for future reference.

https://www.sqlservercentral.com/blogs/lynnpettis/archive/2009/03/25/some-common-date-routines.aspx

Read this: Minimizing Deadlocks

SQL Server 2000

http://msdn.microsoft.com/en-us/library/aa213028(v=sql.80).aspx

Nice straight forward question - Thanks

Replication is NOT the solution.

Now before going further, why would you want a user to NOT be able to write to the "original" DB, and yet allow that very same...

Follow this link

http://msdn.microsoft.com/en-us/library/bb510589.aspx

Scroll down to:

Identity and Access Control

Database-Level Roles - click on the line to access the roles available...

Have to throw my 2 cents worth in.

TimeWarner Cable - Basic HIgh Definition cable service - no premium channels + internet (typical speed 54 Mbps) $110.00 USD/month.

Windstream land line...