Having ORDER BY in your view definition does not guarantee that the results will be ordered when you SELECT from the view. The only way you can ensure that...

Unfortunately I don't have the structure of your tables, nor any of the data in them, so there's not much I can do. As I suggested above, your query...

Import both files into staging tables in SQL Server, perform a join with MIN and GROUP BY, then export to your new file. Alternatively, if you use SSIS, you...

You can't have a default expression containing the name of a column, so if a computed column isn't what you're after, I think you can only achieve what you want...

Is this something you do regularly, or is it just a one-off? Have you considered using COLLATE clauses in your code instead of changing the structure of your database?

John

I think I saw Paul Randal blog about this a while ago. He may have been writing about the undocumented (I think) DBCC PAGE. Anyway, a well targeted...

Ted

In the event of a crash, what is the largest amount of data (in days, hours and minutes) that you can afford to lose? Do you need to be...

Please show us what you've tried so far and we'll see whether we can help with any specific problems you have. We're not here to do your job for...

Read about DATEPART. Or you can use the MONTH and YEAR functions. Try it out, and post again if there's anything in particular that you don't understand.

John

Or this, which uses INFORMATION_SCHEMA.COLUMNS, so that no joins or subqueries are necessary. Also adds supports for text and varchar(max) data types, nullability, and table schemas. The syntax...

You just need to declare @sql as nvarchar(max).

John

Cadavre (11/23/2011)

---

We could always drop the CURSOR 🙂

This is untested, so test before you run it.

DECLARE @sql AS VARCHAR(MAX)

SELECT @sql = COALESCE(@SQL, '') +

CASE WHEN ROW_NUMBER() OVER (PARTITION BY...

So you want to compare every column in every row? ...

Connect to the target server with SSMS, open Security and then Logins. Do you see a login there either for the service account, or for a domain group of...

Puneet

Two possibilities

(1) The account under which SQL Server Agent is running does not have access to the server to which you're trying to connect

(2) You are using Package Configurations, and...