following up on Alvin's question, which is important...what happens when you go to the spot below...what do you see?

on every Windows machine, there is an Administrators group, and by default a specific login named Administrator. On laptops it is typical that every login on the laptop become an...

it sounds like the following occurred:

someone created the view, and when you select from the view, you get the results you saw.

Then, in Enterprise Manager, they edited the view, aliasing...

there is no need to start a new thread;

continue the thread you started on the same question here:

http://www.sqlservercentral.com/Forums/Topic643690-19-1.aspx

if you are having trouble understanding some of the answers there, add a...

Here's how i understand the advantage:

if we are talking about a script that is doing something like updating data or something, a procedure has an advantage:

I'm sure you've seen this:...

wierd, i've always used a varchar(40) for GUIDS/NEWIDs, but when i run this code, you are right, they are always 36 characters:

declare @newid varchar(200)

select @newid = newid()

select len(@newid) as...

i get that error if the database is set to compatibility mode "70"; but at 80 or above it works fine....

maybe the server you are playing with is an upgrade...

i think the error is here:

the select into would insert a column name dColumn_name:

insert into #DISTINCTC SELECT Column_Name FROM INFORMATION_SCHEMA.COLUMNS WHERE Table_Name = 'AGEN'

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

--select * from #DISTINCTC

the cursor looks for...

in that case, it is impossible, unless you modify your table to include an identity column.

create table emp

(

empID int identity(1,1) not null primary key,

emp_id char(4),

emp_name char(15),

emp_address char(15)

)

insert emp(emp_id,emp_name,emp_address) values('e001','A','x')

insert emp(emp_id,emp_name,emp_address)...

excellent!

that helps a lot, thanks. I can script and test agaisnt your example data now.

but what about the business logic?

what makes the record "e001 ...

not enough information;

what makes the record e001 A valid,

and the e001 I...

OK in another shameless adaptation of Tally examples, I'll attempt to get Jeff Moden some more recognition.

Here is a propercase function based on the Tally table. here I'm checking for...

Typically, you want to use a Tally or Numbers table to "fill in the gaps" for sequences or dates.

I couldn't get my mental arms around your example to change this...

lol I'm on the ball today...rare for me

SELECT CONVERT(VARCHAR,@YOURDATECOLUMN,101),HOUR(YOURDATECOLUMN)

FROM YOURTABLE

group by CONVERT(VARCHAR,@YOURDATECOLUMN,101),HOUR(YOURDATECOLUMN)