Glad that we could help and thanks for the feedback.

[offtopic]btw: my name is Florian, SQLCrazy is just my (little scary) status here :-P[/offtopic]

"GO" is a feature of OSQL/SQLCMD/SSMS. Feel free to change it to "FOOBAR" in menu -> tools -> options -> query execution -> sql server -> general -> "batch separator"...

In this case, you can use a CTE with ROW_NUMBER ordered by your Date and do a self-join.

Here's a little example:

DECLARE @t TABLE (

Value DECIMAL(5,2)

...

Hi

Tables are not sorted by inserted rows. You could insert three rows with INT values 1, 2 and 3 and a, not explicitly ordered, SELECT can return 2, 3, 1.

If...

Hi

A database level DDL trigger should help you to create a logging for schema modifications:

Designing DDL Triggers

Greets

Flo

nageshp,

it is possible that you get same results for your UPDATE when using either LEFT JOIN or INNER JOIN. However, this is more accidental than reliable. This happens if all...

Hey Lutz!

First, thanks for the heads up with CROSS APPLY, sure much better solution.

[off topic]

Thanks mate! To be honest, nope. I've got way to less SQL stuff in my current...

Hi UnionAll

You need to use the XML type functions of SQL Server. Here's a little sample, based on your data (removed the "&" characters to get a working source...

Great article! Had the same problem some month ago. Wish I would have had this article at this time.

Greets

Flo

AFAIK searchfilterhost.exe is part of Windows Search and Indexing service. Try to stop the windows service.

I don't think, the memory issues depends on the installation of SQL Server 2008 client components. Have a look into task manager (or system monitor) while executing your package to...

Hi

If you installed the SQL Server 2008 client tools, there is no SQL Server 2008 service installed. Otherwise look at Start->Programs->SQL Server 2008->Configuration Tools->SQL Server Configuration Manager. If any services...

Another simple tool is Adam Machanic's SQLQueryStress tool:

http://sqlblog.com/blogs/adam_machanic/archive/2007/06/28/new-version-of-sqlquerystress-released.aspx

Paul, thanks for the correction!

For your understanding with the cursor:

You have to call FETCH NEXT ... before you can access the FETCH_STATUS

For your understanding with databases:

Do never use cursors ;-). Your approach might work...