I guess these are the two different queries that you are trying, (sorry if I've not understood ur requirement)

select * from @GlueRoomStock order by case_code, scheduleddate, shift

Should not it read...

Yeah that makes sense too from developer perspective, 5 major DML enhancements,

OUTPUT Keyword

Common Table Expressions

PIVOT...

Thanks:)

you're welcome 🙂

How about this?

select ee_occup_levels, [1] as M, [2] as F

from (select ee_occup_levels, gender, race

...

thatok (10/13/2009)

---

Hi

can someone please tell me what is wrong with this query

select ee_occup_levels, gender, race

from (select ee_occup_levels, gender, race

from dtiheadcount inner join reportingstructure

on dtiheadcount.costcenter = reportingstructure.costcenter

where (period =...

i am also not sure why you say that it only matches the first row in t2. when i do this

select

t1.*,

...

dvora.id (10/12/2009)

---

i mean system data base.

when i try to open the sQL 2005 after the installation i get a error during the connection, but i don't understend because I don't...

Just to honour it 🙂

SELECT dateadd(dd,datediff(dd,0,getdate()),0)

What Mike is saying could apply in this case also since its using function...

When you say basic databases, do you mean to say system databases. It will be under system databases folder under databases, if you are talking about test (sample) databases, its...

This might also help you, (developer perspective!)

http://download.microsoft.com/download/3/d/d/3dd4aa9f-e84c-4c63-a246-d4f3d1bd5d7b/MSDN/DEV/SQL%20Server%202005%20-%20A%20Developer's%20Perspective%20-%20online.ppt

Not sure what you are trying to achieve with this, but syntax would be this,

UPDATE PS

SET ps.StatusID = 2

FROM profiles p, profiles_submitted ps

WHERE p.ProfileID = ps.ProfileID and p.Visited is...

Sorry may not be able to answer all ur questions, but regarding book, I thought this is good!

MCITP Self-Paced Training Kit (Exam 70-441): Designing Database Solutions by Using Microsoft® SQL...

Ohh, sorry I just dint see that! 😉

But I dont know if I am missing something here, but this query below...

I would suggest to read the article as suggested by Garadin before using this, but crosstab query would look like this,

CREATE TABLE PIVOTIN(ID int, [date] datetime, Parameter Varchar(50), [Value]...

How about this?

Select * from (Select *, Row_Number()

OVER (PARTITION BY studentid order by issuedate desc) as rownum

from scenario) urtable where rownum = 1