seems like you want inner join on table to be updated and country table on country='DDDDD'

check attachment

2 Suggestion:

1. Change Datetime parameter to string(anyway you are doing so while making dynamic select query), and pass the string formatted parameter from code side.

2. Make sure your variables StartDate,EndDate,EmployeeNo,EmployeeName...

Provide proper data

you might need to convert the stored procedure to trigger

Agree with Jason. just one suggestion

instead of "AND t2.CompanyCode <> 96" , It will be good if you use "AND t2.CompanyCode = 10" , if you have more data for...

I could not get what you really want but will complete correct sequence for select into..

Insert into NewTableName(ColumnName1,ColumnName2)

Select ColumnName1,ColumnName2+ColumnName3 from OldTableName

If you want Concat of column2 & 3 to be...

Check with the permission granted to user throwing the error.

Requires VIEW SERVER STATE permission on the server

How you are authenticating from application.

SQL Server Authentication or Windows Authentication ?

I will still recommend for Repair_rebuild as it repairs extra keys in nonclustered indexes + rebuilds indexes and NO DATA LOSS..

DBCC CHECKDB ('DBName', REPAIR_REBUILD) WITH ALL_ERRORMSGS

Please suggest !!

Try this

SELECT * FROM sports_program where tf_genre_desc138 like '%basketball%'

and tf_genre_desc137='Sports Event'

and convert(datetime,tf_org_air_date) between cast('03/05/2011' as date time) and cast('03/07/2011' as datetime)

order by tf_reduced_titlec

Please check the attached.

Thanks Dave, I was trying somthing like this.

Because of my business logic i have to handle 16 variables.This will work though i found just a very small time difference...

I have one cursor returning id and other master information.

For each id we are collecting multiple rows information from table.

Here we have to check for first 4 rows of that...