Hi,

Yes it works (although I've no idea why!).

THanks

Hi,

I've got this working but not fully happy with solution. I made a Temporary table and put the results that I wanted to add together into this...

Hi,

I partly guessed it was dong what I told it to do: it's just that I was telling it the wrong thing!!!

I've tried your solution and it...

Yes, I found the problem, I had missed one of the Joins as noted in my second post.

Sorry!

Sorry,

Solved. I forgot to add the join between sys.index_coluns.index_id and sys.index_indexes.index_id

Fixed:

SELECTSysI.object_id

,SysI.name AS IndexName

,SysI.index_id

,SysI.type_desc AS IndexType

,SysC.name AS ColName

,CASE...

Hi,

Eventually cam eback to this and after some more research, I discovered that the Instance was set to Windows Authentication Mode only and not Windows & SQL Server Authentication!

Fixed anyway,...

Hi,

I've been scratching my head on something similar. I couldn't connect to the database from the server on which it was running (test DSN). I tried every combination of creating...

Hi,

So if I want to add a Login, I first create a User e.g. called TestUser on the database and then:

CREATE LOGIN TestLogin WITH PASSWORD...

It's on a server that I remote onto. The Name is (servername)\SQLEXPRESS

I was trying to create a DSN one the server just to test the connectivity.

http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/

This one? Yes, I did; well, pardon the pun, I "scanned" it rather than reading slowly and nothing on performance of IS NULL jumped out at me.

The tables will not contain that many rows (<5000) but I'd be concerned if performance was slow or if I use this logic on larger tables. If I changed the...

Hi,

I didn't really want to use dynamic SQL because of the risk of SQl Injection (it's for an internet site). I have settled on this:

(@Category =...

Hi Adi,

Thanks for your answer: that is exactly where I went wrong.

Dec.

Hi,

Kingston's answer works.

Thanks for both answers,

Dec.

Hi,

Yes, I think that's what I'm looking for: I'll give it a go later on this evening.

Thanks.