you guys missed his previous post...I;m thinking this is a shared hosting server, and not anything on his own LAN or that he has Admin access to at the OS...

the interview question was a test of your basic knowledge on how to query for data.

you failed.

If you can't answer it, it would show that you have no experience...

when the old SQL 7 was upgraded, non-system databases were left at compatibility 70.

since you clearly have a need to use functions, I'd change their compatibility to 80 and be...

to do that, you need a case statement for each possible value:

[font="Courier New"]

SELECT

  SUM(CASE WHEN idstatus = 1 THEN 1 ELSE 0 END) AS STATUS1,

  SUM(CASE WHEN idstatus = 2...

jb, was my guesstimate right? were all the databases on that server at compatibility 70, but master at 80 due to an upgrade?

you are all set on that server?

yep when using a varchar for LIKE statemnts, the spaces are significant. a varchar contaning spaces at the end maintains the spaces; it's when you look for equal to a...

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)...