Viewing 15 posts - 316 through 330 (of 462 total)
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...
October 13, 2009 at 8:40 am
webtekkie (10/13/2009)
Hi,Looking at this from another perspective, you could say that the difference is 5.
😛
Martin
Yeah that makes sense too from developer perspective, 5 major DML enhancements,
OUTPUT Keyword
Common Table Expressions
PIVOT...
October 13, 2009 at 6:28 am
PP was quicker
Thanks:)
thatok (10/13/2009)
Beautiful, Thanks a lot to both of you
you're welcome 🙂
October 13, 2009 at 4:03 am
How about this?
select ee_occup_levels, [1] as M, [2] as F
from (select ee_occup_levels, gender, race
...
October 13, 2009 at 3:39 am
thatok (10/13/2009)
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 =...
October 13, 2009 at 3:20 am
i am also not sure why you say that it only matches the first row in t2. when i do this
select
t1.*,
...
October 13, 2009 at 2:45 am
dvora.id (10/12/2009)
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...
October 13, 2009 at 1:27 am
Garadin (10/12/2009)
The dateadd/datediff method that someone will likely post shortly......
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...
October 12, 2009 at 12:59 pm
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...
October 12, 2009 at 8:44 am
This might also help you, (developer perspective!)
October 12, 2009 at 4:48 am
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...
October 11, 2009 at 3:56 am
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...
October 10, 2009 at 2:38 am
Those two aforementioned articles are one in the same ;-).
Ohh, sorry I just dint see that! 😉
But I dont know if I am missing something here, but this query below...
October 10, 2009 at 2:13 am
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]...
October 9, 2009 at 1:31 pm
How about this?
Select * from (Select *, Row_Number()
OVER (PARTITION BY studentid order by issuedate desc) as rownum
from scenario) urtable where rownum = 1
October 9, 2009 at 6:57 am
Viewing 15 posts - 316 through 330 (of 462 total)