I agree. Makes me wonder if this might have been something that was discovered in one of the older versions of SQL... 6.5/7 and you know how people hang on...

You know John, the people that help out here are all un-paid volunteers. Providing the DDL scripts (CREATE TABLE, CREATE INDEX, etc.) for the tables affected, and INSERT statements to...

All the pieces from above, all put together.

SELECT 'ALTER LOGIN ' + QuoteName(name) + ' WITH CHECK_POLICY = ON;'

FROM sys.server_principals

WHERE [type] = 'S' -- SQL Server...

So...

David,

This is definitely an excellent, thought-provoking article. Thanks!

Hi Anil,

This is actually a good example of why you need to provide accurate test data to demonstrate the issue that you're having. The test data did not work for...

I'm surprised that nobody has yet pointed to the excellent DelimitedSplit8K function, developed here on this web site. (Actually, I bet Jeff's getting ready to showcase it later tonight!)

I used...

Tara-1044200 (8/10/2010)

---

How about this..

DECLARE @rowcount int

SET @rowcount = 100000

SET rowcount 100000

WHILE @rowcount >0

BEGIN

BEGIN TRAN

Update dbo.Employee set jobcode = 1 Where jobcode <> 1

SET @rowcount =...

Might I suggest the SQL Server 2008 Upgrade Technical Reference Guide?

You probably need to convert those to varchar(max) first.

Don't forget to run the SQL 2008 upgrade advisor - it will...

Here's my two cents worth:

1. You're running on MSDE.

2. As Gail pointed out, this...

Anil,

This method, just for SQL 2005+, utilizes a CTE to build a dynamic tally table. Not much else is different.

-- declare and initialize variables

DECLARE @CNTPRD INT;

SET @CNTPRD = DATEDIFF(D,'2005-12-31',GETDATE());

-- this...

See how this works for you.

-- since you already have a clustered index, we need to dump the table to a temp table

-- where we can build the clustered index...

BTW, you've been posting in the SQL 7/2000 forums. Is it safe to assume that this code is for SQL 2000? If not, what version are you using?

Thanks for the table structure and inserts... good to see that you've learned!

How does this work for you?

DECLARE @CNTPRD INT;

SET @CNTPRD = DATEDIFF(D,'2005-12-31',GETDATE());

-- these two lines of code are to...

Okay, I just noticed that part of what you are doing is based on the previous record. This will require a different approach.

Do you have any indexes on this table?...