It sounds like you might want to do a few joins...

e.g. (making something random up with a cte, I'm not saying this is good ;)):

declare @t_sample table(

[id] int

,[mnth] nvarchar(50)

,[some_number]...

It's certainly an interesting situation - I agree that initial development time could be reduced quite considerably, but exposing a database's schema to the world (if that is the intent) rather...

Hi

I've not looked enough at LINQ yet (though will), so I'm definitely not claiming any expertise, but from what I have seen I would first say that LINQ itself is providing...

Are you creating the temp table then not dropping it when you are finished?

Just being lazy and doing a google search...

http://www.google.co.uk/search?hl=en&q=c%23+sql+server+image+asp.net&meta=

The first article (http://www.developerfusion.co.uk/show/4651/) seems to show what you need.

J

The description of the ROOT directive in BOL seems to imply that you can't add an attribute via that mechanism, but you could try (without using gibberish data obviously

Something like this?

declare

@t table(id int identity(1,1),...

I think the distinction between a primary key and a unique index is that a primary key is a logical entity for defining how data may be uniquely referenced in...

Did you figure out the problem here?

I had a strange query a couple of weeks back on SQL2005 - the query ran fine by itself, but when I added an insert...

Interesting one - I haven't seen update cursors before, but noticed this article:

http://www.dbforums.com/archive/index.php/t-1103811.html

which indicates that perhaps the table needs a unique index on it for this to work...??

On a...

Using Terry's code above, I *think* if you're examining entire tables it might help to avoid the subquery:

select p.personid, e