I don't know that I would call that details but that certainly shows this is a duplicate thread.

Pretty sparse on the details but maybe something like this?

select Name, Order, max(ItemShipDateTime)

from SomeTable

group by Name, Order

If that isn't what you are looking for we will need a few things:

1....

pwalter83 (7/29/2013)

---

Hello,

Could someone please tell how can data be updated (refreshed) in one table if the data is refreshed on another table and both tables are linked through a primary...

kanchan 58240 (7/29/2013)

---

Hi,

Thanks for all your replies. Here is the query worked as required.

select t.cardno ,dateadd(dd, -datediff(dd, t.datetime1, 1), 1) AS date,

(select SUBSTRING(CONVERT(varchar, min(st.datetime1), 100), 13, 2) + ':'...

dubem1-878067 (7/26/2013)

---

I will try to explain the best I can the situation I am facing

I have a table with 12 'bit columns' each of them reprensent a potential specific...

Total shot in the dark because there is nothing to work and the description is very vague but maybe you want something like this?

CREATE FUNCTION dbo.Example_function_name

(

...

Not exactly sure what "level andy Myvalue" is but you can add parameters to your function,...

nitha jen (7/26/2013)

---

so there is a way to get a o/p using dynamic sql right..but how....i don't know many thing about dynamic sql....how do i insert the values in a...

ROFL. Between all of us maybe we can put together a simple query that...

Your code seems to have some concurrency issues. You are using IDENT_CURRENT to determine which value to get for a DepartureDate. How can you know that nobody else has inserted...

nitha jen (7/26/2013)

---

i have a table dbo.student_mark_details which contains 4 columns like

student_id,name,age,marks

in my usp_student_details procedure i have 2 parameters as a i/p like @columns,@values

my i/p format is

exec student_details @columns='name,age,marks',@values='a,22,85'

here...

Eric M Russell (7/25/2013)

---

We also can't assume that DateOfBirth isn't nullable.

SELECT TOP 1 *

FROM MyTable

WHERE DateOfBirth is not null

ORDER...

Or you could make this a bit simpler by eliminating the unnecessary subselect.

select cardno

, MIN(datetime1) AS MINdatetime1

, MAX(datetime1) AS maxdatetime1

,[action]

from view1

GROUP BY cardno, [ACTION]

Please read this article and think about how it pertains to what you have posted here.

http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspx

Zeal-DBA (7/25/2013)

---

hi Sean,

please find attached image , as i have written trigger, after executing it prints message what i have mentioned in code but it is allowing to insert record...