I don't see a link between Candidate and Education.

And why can't u add Modified_Date to your SQL Statments?

Just to add:

1. Make sure there is no old long running transactions on the database thats causing the database logs to keep shrinking.(DBCC OPENTRAN).

2.If your recovery model is set to full make...

I know there might be a better way to do this but try this.

Assumtion:KV is ur resultset that u have.

SELECT identity(int,1,1) as Iden,* into #tmp from  KV order by Rank

Desired...

The table might be created with userid as owner (user.table instead of dbo.table) so when u drop u will have to specify user.table.

I found a way to do it. Hopefully this might help some one.

1. Allow the primary file to have Unrestricted File growth.

2. Runn DBCC to Move data from the second file....

you might not get the same result but try this.

Select  Factories.FactoryID,F1.FactoryJob,F2.FactoryJob,

 F3.FactoryJob,F4.FactoryJob,F5.FactoryJob

from ( 

 select distinct ltrim(rtrim(FactoryID)) as FactoryID from Factory) Factories

left outer join (Select * from Factory where ltrim(rtrim(FactoryJob)) ='No1') F1...

Eric,

PPl are trying to help and if you don't want to know how its done in SQL Server then don't post it here. I hope u understand this site is called SQLSERVERCENTRAL...

Try this:

INSERT INTO test (Month_of_file, CalcAction, TableValue, CalculatedValue)

       SELECT @Month_of_file_filter as Month_of_file, 'Record Count by Transaction Month' as CalcAction,

       Convert(Char(10),MonthReported,111) as TableValue, COUNT(*)  as CalculatedValue

       FROM GE_Transaction

       WHERE Month_of_file...

how will u show DRIVE cos u have 2 drive (C and D) and Version?

Try this:

Select Table1.Col1,Table1.Col2...,Table2.Col1,Table1.Col2..

from table1 INNER JOIN table2 on ltrim(rtrim(table1.Col1)) = left(table2.Col1 ,len(ltrim(rtrim(table1.Col1))))

Thanks

Sreejith

If you want to cleanse the data then the data needs to be loaded as is in to staging table(s) and cleansing happens on the staging table(s). Once the data...

Change the w.* to w.col1,w.col2....w.coln. The reason for the error is name and id repeating multiple times. You cannot have the same column name repeating when u create a table/view.

Have u...

In your search function add additional logic to check the word before and after and check if its blank space.

select Cast('31/Oct/2006' as datetime) -1 would work too.