Hi

Thanks for your reply. Is this what you meant, or would you need to see more than this?

10/29/2012 10:18:12,Server,Unknown,Registry startup parameters: <nl/> -d F:\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\master.mdf<nl/> -e F:\MSSQL10_50.MSSQLSERVER\MSSQL\Log\ERRORLOG<nl/> -l F:\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\mastlog.ldf

The only information...

Hey Koen, thanks for all your help.

When I clicked MSDB, I got a message:"Failed to retrieve data for this request....The SQL server specified in SSIS service...."

I managed to find...

Hi

Thanks for the reply.

I have connected to Integration Services through SSMS. Although there is a folder listed under Stored Packages - File System that the package should be...

CONTEST ENTRY

This took a bit longer than I thought...

Queries 1 and 2:

“Query #2 runs first, looking to see if that particular article has ever been viewed before or not.” If...

Hi

Very nice article. I'm looking forward to the rest of the series.

I ran the query to show unused indexes, but it returned some strange results including linking databases to the...

Craig

Thanks for the reply, and for pointing me at the obvious.

I was running "select * from sys.objects where object_id=53575229", but I'd forgotten that this is database-specific. Having changed database...

Hi.

Yes, that works perfectly. I think I'll need to read up about binary collations. I'd never heard of them!

Thanks very much for your help

Sorry, I should have said that we are currently using Latin1_General_CI_AS collation.

Thanks

Hi

Try this:

SELECT * FROM

(SELECT * ,ROW_NUMBER()

OVER (PARTITION BY title Order BY price) as row_no

FROM T) x

WHERE ROW_NO = 1

Regards

Alun

How about this?

select YourTable.*

from

YourTable

inner join

(select

field1, field2, field3

from YourTable

group by field1, field2, field3

having count(*)>1) dups

on dups.field1=YourTable.field1

and dups.field2=YourTable.field2

and dups.field3=YourTable.field3

The subquery identifies the duplicates then is joined back...

Jeff

That code doesn't quite work. For example, row 1 is returned as "This is a long sentence and I", which is 29 characters. I think you've forgotten to count spaces...

Hi

I think you need to amend the brackets in your WHERE clause, plus you seem to be comparing the wrong item with NULL. I think this should do it:

SELECT ...

Hi

It took me some time to get this working as well.

We have a report showing report usage per date. We have DateRun as a matrix column and ReportName as a...

Developer failings from my experience (SQL/BI developer):

1. Excessive use of cursors. Some developers seem to prefer to work with one row of data at a time then wonder why the...

As I said, your CASE statement is returning a mix of integers and strings.

A resolved version of your CASE statement is:

SELECT

CASE

WHEN 0 <> 0

THEN (CASE WHEN 1 =...