need to change where claus

Question

need to change where claus

harita

SSCrazy

Points: 2197
More actions
October 26, 2010 at 7:45 am

#225450

ORDER BY CAST(WEEKNAME AS DATETIME), SUM(QUANTITY) DESC

Viewing 15 posts - 1 through 15 (of 16 total)

You must be logged in to reply to this topic. Login to reply

GSquared SSC Guru Points: 260824 More actions · Answer 1

I can't tell what you're asking. Can you clarify your question?

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

harita SSCrazy Points: 2197 More actions · Answer 2

the code i have now gives me few items but i want all the items

GSquared SSC Guru Points: 260824 More actions · Answer 3

If by "all the items" you mean you want all the rows in a table, you can get that most easily by not having a Where clause at all. That will give you all the rows.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

harita SSCrazy Points: 2197 More actions · Answer 4

i tried using select but it didnt work i didnt get what you meen actualy

GSquared SSC Guru Points: 260824 More actions · Answer 5

Your question isn't all that clear.

Do you want all the rows in a table?

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

harita SSCrazy Points: 2197 More actions · Answer 6

harita

SSCrazy

Points: 2197

October 26, 2010 at 8:01 am

#1242281

if yes , what is your approach

GSquared SSC Guru Points: 260824 More actions · Answer 7

If yes, don't have a Where clause.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

harita SSCrazy Points: 2197 More actions · Answer 8

so what sould i replace with where claus, there should be some clouse right

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 9

If you want every single row in the table, take the where clause out completely. It's optional, doesn't have to be there.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

GSquared SSC Guru Points: 260824 More actions · Answer 10

If you absolutely insist on having a Where clause, but want all the rows, use:

Where 1 = 1

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

harita SSCrazy Points: 2197 More actions · Answer 11

harita

SSCrazy

Points: 2197

October 26, 2010 at 8:30 am

#1242322

i keep getting this error

harita SSCrazy Points: 2197 More actions · Answer 12

harita

SSCrazy

Points: 2197

October 26, 2010 at 8:30 am

#1242324

i keep getting this error

GSquared SSC Guru Points: 260824 More actions · Answer 13

The error is meaningless without the query. Can't help without that.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

ChrisM@home SSC-Insane Points: 24260 More actions · Answer 14

harita (10/26/2010)
Hi, all
the code i have now selects only selected itemname but i want to select all he items can some change the code- thanks
WHERE IT.ITEMNAME IN ('xxx','xxx','xxx','xxx','xxx','xxx') AND

If you feel better with a WHERE clause in your query then write it like this:

WHERE 1 = 1 AND ...

[font="Arial"]^{Low-hanging fruit picker and defender of the moggies}[/font]

For better assistance in answering your questions, please read this[/url].

Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]