Remember, the output is only quaranteed in a specific order if you specify the ORDER BY in the query. How the data is phisically structured is not importand.

I notice a warning about the "cluster validation". Please run the cluster validation check from Windows and correct all reported problems.

I notice the message stating "clustered disk unavailable". Are the...

You're absolutely right!! I have to look better if I copy/paste from a post.:hehe:

INSERT INTO table2

SELECT FDT1, TODT1 FROM table1

UNION ALL

SELECT FDT2, TODT2 FROM table1

Edit: corrected the code with comma's between the columns

The error is given because the specified file allready exists and the file is currently in use. Probably a database with the same name does exist on the SQL instance....

If you want to pass an unicode value to a stored procedure, you first need to set the value to a variable. Then pass the variable to the stored procedure:

declare...

You need to apply the "N" when you set the value of the variable and not when you use the variable to fileter your results. This will work:

declare @kat nvarchar(50)

set...

The [tempdb] is re-created every time the SQL Engine is (re-)started. There is no need and it's even not possible to create a backup of the [tempdb].

If you...

Double post: see http://www.sqlservercentral.com/Forums/Topic1473467-391-1.aspx

Add a filter to your query to select only the NULL values. Remember that because of the NULL values an equal sign doesn't work. You have to use the IS...

This code will give you the extra column with the first day of the month. I've calculated this with DATEADD combined with the DATEPART of [TimeStamp] and the 0...

SSIS is capable of doing very extensive filtering and transformations. Try it for yourself and if you run into trouble or need some help: on SSC is a special section...

Koen Verbeeck (7/12/2013)

I allways forget some posters ask questions for such reasons (interview, exam, school assignment). It's a shortcut and...

A connection time-out error can also occur if a query takes too much time to complete. In SQL Server there is a default time-out setting for remote connection of 60...

If you really want to import that much data into Excel, you need to upgrade to a newer version.

Excel 2010 is capable to handle a bit more then 1.000.000 (1...