u can use the "isdate" function to identify if any of the char input can be understood by sql to contain a date then work from there. remember however the...

What kind of data is stored in the table ,

Mainly is it a product table with 30 millions rows for 30 million products,

Or is it a time based...

Looks like I misunderstood the question , sorry about that. I assumed your working looking for the running total with a value closest to intervals of 20.

Let me see if...

Great catch , now the question is does it apply to newer version of SQL 😀

It seems to be simple enough , is there any particular issue your facing when performing the insert

Insert into employer (identifier , DateTrainingTerminated )

select employer.identifier, max...

I was under the assumption that dm_db_partition_stats was accurate , i tried to create a few scenarios where is tot it would be inaccurate but didn't face any problems.

Here's an...

declare @table table (

Does this work for you

id int ,

runningtot int ,

studid int ,

chardata varchar(25))

insert into @table

select 1,7,123,'Undergraduate' union all

select ...

select row_count from sys.dm_db_partition_stats

where object_id = (object_id('abcd'))

try this , it was asked a q Qotd and works faster

If the issue is that your unable to generate an excel file as part of the output for the SSIS package .You might want to create a staging table and...

http://www.sqlservercentral.com/Forums/FindPost1128900.aspx

there is already a thread on this , please refer above.

the below link shows thes different styles to which you can convert a date time to

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

The regional setting are provided but in this case it means

1/ 12...

The backups can be automated using a maintenance plan for the ftp you might want to use a batch file or an ftp utility, the restore can be done using...

Correct me if I am wrong here , you are trying to install SQL on D drive ?

By this I mean the problem is not about placing the mdf...

Have you had a chance to go thru this

google > direct upgrade from sql 2000 to sql 2008

the first link is a comprehensive guide for upgrade from sql 2000...

Doh !!