Viewing 15 posts - 1,051 through 1,065 (of 3,221 total)
Jeff Moden (8/7/2011)
sqlfriends (8/5/2011)
Our production server will be enterprise version
For the license issue, can I just use developer...
August 7, 2011 at 3:12 pm
sravnmaganti
Does the data below, accurately display the data in your flat file?
NUM FNAME LNAME COUNTRY CITY ...
August 7, 2011 at 2:47 pm
Greg Edwards-268690 (8/5/2011)
Ninja's_RGR'us (8/5/2011)
GSquared (8/5/2011)
Ninja's_RGR'us (8/5/2011)
That's got to be a new record!Not one I'm interested in breaking, though.
Is it even possible?
@steve-2, what is the oldest post that didn't get answered?...
August 5, 2011 at 2:46 pm
James Tech (8/5/2011)
bitbucket-25253 (8/5/2011)
Have not tested the above code on a record set as large as those...
August 5, 2011 at 12:24 pm
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...
August 5, 2011 at 11:02 am
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,...
August 5, 2011 at 10:51 am
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...
August 5, 2011 at 10:16 am
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...
August 5, 2011 at 6:21 am
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
...
August 4, 2011 at 1:25 pm
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
August 4, 2011 at 1:08 pm
Read this: Minimizing Deadlocks
SQL Server 2000
http://msdn.microsoft.com/en-us/library/aa213028(v=sql.80).aspx
August 4, 2011 at 7:56 am
Nice straight forward question - Thanks
August 3, 2011 at 8:19 pm
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...
August 3, 2011 at 7:32 am
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...
August 2, 2011 at 8:02 pm
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...
August 2, 2011 at 12:43 pm
Viewing 15 posts - 1,051 through 1,065 (of 3,221 total)