Thats true. Also DTS has problem with temp tables i suggesr using CTE if there is any temp tables used.

This should help you to understand the page basics.

How SQL Server stored rows in pages...[/url]

One more thing can be done is to use the DTS Wizard.

1. Right click on Database in SSMS.

2. Select Tasks-> Export data

3. Choose Datasource as SQL and give server name...

Can you specify the pattern of affected data? its just one row so is difficult to find out the solution for everybody...

This should help...

select LEFT(Column, charindex('<',Column))

Sql String solutions...

Here is the solution check if this fits your criteria.

create table #t

(

name varchar(max)

)

insert into #t

select '1~2' union

select '1' union

select '1~4~3' union

select '2~3'

select * from #t

SELECT

case when CHARINDEX('~',name,0) >...

have you checked with profiler...

just a first thought...the solution you given looks perfect...

Here is i think what you are looking for..

select distinct

a.cStudentID,

a.School_Year,

a.CourseID,

case when b.termcode is not null then b.termcode else a.termcode end as 'termcode' ,

case when b.termcode is not null...

hi Gopi,

please check out the blog to ensure correct understanding of how SQL stores rows into pages.

How SQL Stores rows in 8Kb pages [/url]

Hope you will like it.

This is only possible if you set the NVARCHAR value as XML like below.

declare @a nvarchar(max)

set @a = N'<root><name> SQL Server 2012</name></root>'

select cast(@a as xml)

It...

Please check the below article to know more about how is null works and what you should do to get it worked in your

http://borngeek.in/isnulltransact-sql-explored-in-detail/[/url]

Thats a nice explanation you got !!!

There is also a thing to remember about the ISNULL behavior which is very useful while coding.

Check below link:

http://borngeek.in/understanding-isnulltransact-sql-behavior/

Any update on this ?

Below is the error description

Executing the query "stored proc name" failed with the following error: "Timeout expired. The timeout period elapsed prior to obtaining a...

No, It can not be done. The SP GetData is a generic one and can be used by multiple SP's.It is also necessary to include the dynamic SQL query in...

Less than 5 minutes approximately 45 lacs records inserted into database.

Extremely fast.