If a table was dropped, it's indexes went...

george here's one way to do it;

i'm using a function CHARINDEX2, which finds the Nth occurrance of a string within the string.

with that, i can find the first CrLf and...

here's one way to do it; in this case, i put the total Hours a s acolumn in the same row...not normalized, repetative, but the data is there.

this is based...

not true.

when it comes to compiling...

it's just a bit bigger: (19,4)

here's an example:

create table money(

mymoney money)

select * from sys.columns where name = 'mymoney'

select type_name(system_type_id) ,

type_name(user_type_id),

'('+ convert(varchar,precision)+ ','+ convert(varchar,scale) + ')'

from sys.columns where...

in SQL server, there is always more than one way to skin a cat:

this should provide the same logic...the order by is the key:

create table #NoName(

ProdCode varchar(30),

Width ...

Richard

for my DDL database trigger, I'm using execute as without an issue;

here's how my trigger starts:

CREATE TRIGGER [ReturnPREventData]

on DATABASE WITH EXECUTE AS 'dbo'

FOR

CREATE_PROCEDURE, DROP_PROCEDURE, ALTER_PROCEDURE

AS

here's a complete exampel for...

while you are running on 2005, your database seems to be set for compatibility 80.

row_number function is compatibility 90 and above

you'll want to try my code featuring row_number at the bottom of the example i pasted.

let me know if that works for you.

George the display of the chars depends on the presentation application; what program is viewing the data as squares

SSMS in gridview mode replaces vbCrLf(CHAR(13) + CHAR(10) )with a single space.

SSMS...

here's how i would do it, not sure if it is what you want:

in the example you gave, there was only one possible solution for Width : 1.5 Height :...

bugop (11/9/2009)

---

What is the difference between these two database roles?. and which one has the full control of the database. As i understand it dbo, is the owner of the...

Thanks Gail; for proof of concept i changed one of my databases, and here's a screenshot of the results: it's found in the Application...

sometimes using the UPDATE FROM syntax can keep you from fatfingering the correlated subquery like that; i know i did that same error to an invoices table a long time...

need a clarification: your procedure had two spelling errors in it, as well as a syntax error for the cursor declaration;

select [MemberID], [TransactionType], ClosingBalance

from temp_SchemeDetails

group by [MemberID], [TransactionType]

Msg 8120, Level...