Yes, a PK shouldn't be volatile. A PK is one of the fundamental concept of relational databases. It is used to uniquely identify a row in a table. The IDENTITY...

Actually there are many difficulties arising. I once attended a presentation where they showed us a software using SQL Server as backend. I was the only one not from the...

Hmph, obviously the new forum software does not have fllod control or it is not activated. Sorry for posting twice. Too much coffein got me nervous fingers

Any chance to change the underlying table design? It really looks like you have something like this

year 01 02 03 04 05

2003 ...some numbers

2002 ...some numbers

If so, that should be the...

Any chance to change the underlying table design? It really looks like you have something like this

year 01 02 03 04 05

2003 ...some numbers

2002 ...some numbers

If so, that should be the...

Ok, now that it works for you, you have no excuse not to post anymore

Summary tables? Hm...have I heard this before? Sounds like a great idea

Now serious, I agree that no normal user should be sa....

What a shame, Steve!

Thanks for the info!

It's interesting to see such regulations. In my profession everybody's crazy about being allowed to put the three letters CFA on his business card. However, they use...

I guess I made a copy and paste error

Anyway, you're far from reaching the 8,000 character mark. Getting it all in one string...

Because of the expiration of most certificates, I do not recommend you go out and get certifications, that young unless you have an after school job that would give you...

Nothing like answering my own questions

With the contest it seems to make sense. Am I right?

But why can be voted on scripts...

I would lie if I say I know for sure, but it might some thing to watch. Anyway I would expect SQL Server to throw an error for violating the...

It's hard to follow the forum formatting, but are you sure this works. Just asking because I tried

select datalength(@query1), datalength(@query2),datalength(@query3),datalength(@query4)

which returns

----------- ----------- ----------- -----------

190         270         NULL        387

(1 row(s)...

Thanks!

Yes, I know the app won't explicitely insert values, but do you know what else it is doing?