Problem is

select case when 'À#' > 'AÞ' then 'Greater' else 'Less' end

returns "Less".

Character "Þ" probably does not exist in this collation and makes correct matching not possible.

select case...

Index should cover columns used in WHERE clause, not in SELECT list.

I'm using views in similar situations.

View returns values from the latest record for the category.

Work perfectly.

Even with 100k records in log table report is generated in less than 1 second.

...

, CONVERT(varchar(10), NULL) AS column_b

...

SQLBill,

actually Index Seeks are good. Index Scans are bad.

You confused a little.

Once again.

Did you read it?

Did you get it?

Senthil, think about this.

If we are friends, how many rows do you create?

One?

Which one?

Senthil|Sergiy

or

Sergiy|Senthil?

Then, if you need to find friends of Senthil, which column are you gonna scan?

Or...

Best,

did you read answers here:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=355132 ?

Did you get it?

Can you repeat what did you get?

Remove column LagCategory from Services and retrieve it via INNER JOIN to FinancialCategories every time you need it.

You may create a view with this join inside and replace all references...

What's your point?

Create another table with the same structure as existing one?

Then just do this:

SELECT *

INTO dbo.NewTable

FROM dbo.ExistingTable

WHERE 1=0

If not just explain what are you trying to achieve.

In Query Analyzer in Object Browser (press F8 to open it) right-click on the table, then choose "Script Object ..." - whatever you need.

QA is not XML reading or editing tool.

SQL Server generated XML for you.

Use proper tool to display it or work it out.

Hector,

if you need 3 level XML then you need 3 tags.

Just add another tag to the example given and you are there.

I slightly modified that script to bring you exactly...

Watch your syntax.

No matter how smart is the solution syntax must be correct:

SET @bcp = 'bcp "exec ReportProcedure' + @SDate1 + ', ' + @SDate2 + '" QUERYOUT...

bcp "exec ReportProcedure @RepTime = 20070328" QUERYOUT "C:\test.txt" -T