And a darned good one too, may I say ! :w00t:

As Jason stated, the query I provided should cover your quest.

Oh indeed. I forgot to mention this:

Test it, Test IT !

- the trc files you see are the ones generated because the default trace is active (+_ 20MB each, wright ?) I presume.

( please let it be active. It can...

Because you're only using inner joins, just let the sql engine determine at which step in the process it will handle your where clause.

(It will take indexes and statistics into...

Maybe this can be an option too

Declare @SeriesStartDate datetime

Declare @SeriesEndDate datetime

Select @SeriesStartDate = '2010-11-01'

, @SeriesEndDate = DATEADD(mm, 4, @SeriesStartDate)

Declare @DynamicPivot varchar(1000)

declare @Separator char(1)

Select @DynamicPivot = ''

, @Separator = ''

Select @DynamicPivot=@DynamicPivot...

I would first look for things that may cause your kind of corruption:

A good starter is : http://sqlskills.com/BLOGS/PAUL/post/Example-20002005-corrupt-databases-and-some-more-info-on-backup-restore-page-checksums-and-IO-errors.aspx

You'll find more corruption/checksum related blogs on that site.

http://www.sqlservercentral.com/articles/Corruption/65804/ also contains very helpful...

you could try to investigate its execution count

select qs.execution_count

FROM sys.dm_exec_query_stats qs

cross apply sys.dm_exec_query_plan(qs.plan_handle) QP

that's one of the advantages you get when switching to dbmail 🙂

Thank you for the feedback !

Others will benefit from it.

Is this a single shot migration ?

Did you have a look at the SSMA for access (freeware by MS )?

( SQLServer Migration assistant for access )

Can this help out ?

insert into @sku values ('12345000'),

('32134000'),

('21340000'),

--It was not working for skus like

('1234567'),

('1234012'),

('1234500')

Select sku

, SUBSTRING ( sku , 1, datalength(sku) - patindex('%[^0]%',reverse(sku)) +1) as newsku

--, patindex('%[^0]%',reverse(sku)) as pos

from...

manju3606 (1/4/2012)

Hi ALZDBA,

can i ask question here,i am using bellow qurey to get all relationship tables and i am getting all the relation ship tables also now what i...

Don't put a function on your tables column ! (it ruins index usage !)

do the function on the foldable calculated formula on getdate !!

and consider putting an index on...

Please allow me to point to a very interesting project at codeplex:

Scripted PowerShell Automated Deployment Engine (SPADE) for SQL Server[/url]

pre-configure windows, install sql, post install scripts, ....

Do you need to take DST (Daylight saving time) into account ? ( search SSC for solutions )

Just to remind some pitfalls ...:Whistling: