Aside from the obvious MySql you have the word WHERE twice. You can't have two where clauses in a single query. You can have multiple condition. Remove the second WHERE...

NOLOCK has far...

astrid 69000 (10/8/2013)

---

Thanks for your help.

I did a few changes on the query, but i am still encountering a few problems.

it is not summing the clickcount, i do get a...

Please respond to the forum not a private message. That way others who may have the same issue can understand as well.

Think about ordering book titles by name.

Alphabet

Axe Murdering...

amolsingh9372 (10/8/2013)

---

select * from empolyee where name > 'ax'

IDNAME SALARY DEPT PREVIOUS_SAL

1 amol singh 2000...

astrid 69000 (10/8/2013)

---

i am trying to get

on the columns the dates

on the rows the hours (from those dates)

and the sum of the clicks as a measure.

the same i gave has...

For anybody else coming along here is the sample data in a format that is consumable.

CREATE TABLE clicks (RecordDay datetime, ClickCount INT)

GO

INSERT INTO clicks (RecordDay, ClickCount)

select '2013-10-05 13:23:44', 2 union...

Excellent. Now what I don't understand is what do you want from this sample data?

prb (10/8/2013)

---

Hi,

We have a script with insert statements in between BEGIN TRANSACTION and COMMIT.The data from those insert statements should populate few tables. When two of us run the script...

Your post is lacking any level of detail required for anybody to understand the problem, let alone the question. In order to help we will need a few things:

1. Sample...

I am not really sure what you are trying to do or what the question is.

cmcfarland 51322 (10/8/2013)

---

Good Morning!

I'm trying to update a column based on a WHERE statement that uses a SELECT statement as the qualifier.

My goal is to find duplicate records in my...

SrcName (10/7/2013)

---

you can make this on this way

alter procedure w AS

exec('ALTER TABLE t ADD x char(1)')

exec('UPDATE t set x = 1')

But you can run only once. next time will be...

Glad you were able to figure it out. 😛

Nevyn (10/7/2013)

---

It appears that unpivot sets the sort order according to the order given in the IN clause, which is what you want anyway.

If you don't trust that, or something...