altering a table...adding/removing columns,creating or altering procs views, etc etc requires ddl_admin permissions.

in this specific example, i cannot get it to raise the error, but I've encountered other situations where i must issue the GO command after an ALTER TABLE command before...

your example's messing you up... a row of data is just that: each element is related to the others. grabbing a value from another row? why?

if you substitute names for...

At one place I interviewed at, I had a good preliminary interview with a couple of people, one a manager, and the other an HR-type, but it was all high...

a quick google lead me to this solution posted from Dalton from http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=70901

declare @myString varchar(255)

select @myString = 'BarCode 1'

-- Define the string of characters that we'll need to pull the...

I'm in the same camp of not worrying about the trace impact after this article about the near-zero impact of a server side trace where someone actually compared the...

the integer division, 5,2 is evaluated before the round occurs.

if you divide two integers in SQL, the result is returned in the same datatype...an integer.

That behavior is kind of unique...

I know if you right click the diagram in 2005 and above, there is a "Copy To Clipboard" option, but it copies as an image/bitmap, so you can paste it...

those "ISO-11179 rules" aren't rules, they are guide lines, or at least an attempt at best practices; calling them anything other than is misleading.

no DBMS system anywhere prevents you from...

the trick here is to the the SUM of a CASE which tests the columns you are after;

take a look at my example below;

based on your post, something like this...

here's something i put together a long time ago; this requires one tablescan for the EXISTS() of every table that has a char/varchar/nchar/nvarchar column in it's definition...

so if you have...

standard answer...it depends: experience is based on challenges and problems you learn to overcome, right? it depends ont he work environment.

if you write reports, you could expect your...

what have you tried so far?

SQL supports the TOP command, ie

--last 90 days of data

SELECT TOP 50 ColumnList From MyLogTable Where SomeDate > dateadd(dd,-90,getdate())

i got thru turning your post into consumable data, and ran out of gas....

if the data was already in consumable format, i probably would have worked on a solution instead.

here's...

No we are on the same page.

a mailmerge substitutes [Fieldname] in the word document with whatever value is coming from the database. but in many cases, you wan thte value...