The schema is quite simple with very few relationships and constraints (apart from most tables having a PK).

Cardinality is high on critical tables... and gets lower with non-critical tables.

I would say the business would allow up to 4 hours with minimal data loss. Obviously they'd want this to be as small as possible but 4 hours is the...

Hi guys,

Sorry for not being clear...

What I am trying to do is bring back a data set (currently:- id, totalcost) and load the values on to a report that is...

Genuis!

Thank you very much.

Joe

Here's the script I am using, which strips out the dates I am actually wanting to retain...

select top 10 dbo.RegexReplace('[0-9][0-9][0-9][0-9]/[0-9][0-9]', '', description_short, 1, 1), description_short from ee_product

where description_short like '%[0-9][0-9][0-9][0-9]/[0-9][0-9]%'

Output...

My...

No there will only be one date in each string.

How would I set the string to be equal the match? That's the bit I am struggling with.

Cheers,

Joe

Thak you very much - that has worked and solved a number of other issues I had.

Joe

it is your and combination that kills it.

e.g. day >= 1

and day<= 16

So you skip all days >16

By converting to datetime, you'll have the full flavour of functions for...

Yes i did try Profiling but I cannot guarantee that my filtering would cover all eventualities. There are so many ways you can update a value in a table I...

Thanks for your reply mahesh_sqldba.

Unfortunately the update query is very likely to be some dynamic sql and not a sproc or function, however I have added your script to my...

John,

You are right to point that out. Perhaps I should have made it clear that we were dealing with data that had NO indexes applied (clustered and non-clustered).

With part 1...

Your suggestion above does work however it doesn't quite fit into what I am trying to do, so if you can help me further I would very much appreciate it.

Basically I...

But what happens if myTESTdb doesn't exist? Parsing fails.

I am looking for a solution that jumps to the QuitWithRollback if the database doesn't exist.

Thanks for your suggestion John.

Mike,

I'll make sure information on all data types is included within this series. Thanks for your input.

Thanks to everyone who has contributed and shown an interest.

Joe

Igor,

I also use an automated process to achieve this and was wondering what threshold values you use. There seems to be little out there on how you can best derive...