Your app (on the frontend) needs to replace the CHAR(10) and CHAR(13) characters from the stored value to the linefeeds used by this app. Most applications handle this stuff automatically...

The most easy way is to compare the number of records of your staging table with the total number of records of the ETL tables.

IF (select COUNT(*) from #stg)

=

(select COUNT(*)...

yuvipoy (5/7/2014)

---

I think you entered here wrongly.

It is SQL server 200 it does not have SSMS.

and thats too setting value in SSMS i dont think it will resolve.. in profiler...

This could be the default limit in SSMS. Look in SSMS for...

can you elaborate on what you are doing (what steps did you take) and display the informational and/or error messages you get?

You can use the CASE statement to select the conditional value you need:

/*

for p_typ in 'IP' I will get all rows from TBL_a for that p_id

for p_typ in 'BP','0P' I...

You can change the (default-)collation of a database with the ALTER DATABASE command. But this doesn't change the collation of the existing objects!! You need to change each existing object...

You need to supply a complete script that will display your problem.

I've changed the code you provided so it will run without initial errors, but this code does NOT have...

You need to convert the current datetime (from GetDate() ) to a DATE datatype instead of a DATETIME datatype. When comparing this to a DATETIME value it will be converted...

You can query the [sys].[columns] table for the specific column name and translate the corresponding object_id to the table name. You can build a dynamic SQL statement inside that query....

1....

The format "yyyy-dd-mm" will not be accepted as a datetime datatype. You have to provide the values in this format as a string.

Next it is a rebuilding of the string...

Or using the solution with OUTER APPLY:

declare @table table (value varchar(500))

insert into @table (value)

values('plan type A change from plan type B from Plan type C')

, ('Insurance plan M changed from...

When I remove the complete WHERE clause, I get results displaying the last execution of every job. Each job is displayed the number of times equal to the number of...

Read this article http://www.sqlservercentral.com/articles/CROSS+APPLY+VALUES+UNPIVOT/91234/. You most likely can solve your question with the information from this article.