Hey kalit.sikka

Tnx for your follow up post on ur resolution.

please post insert scripts in future.

try this

select a.TeamID, a.OD OrderDate, b.value

from

(select TeamID, max(OrderDate) OD

from yourtable

group by TeamID) a

join yourtable b

on a.TeamID=b.TeamID

and a.OrderDate=b.OD

repeated thread

http://www.sqlservercentral.com/Forums/Topic1046318-391-1.aspx

Here you go...

Not the most effecient solution, but it will do

set dateformat ymd

declare @start datetime

declare @increment float

declare @end datetime

set @start=(select cast('2000/01/01' as datetime))

set @end =(select cast('2031/01/01' as datetime))

if exists(select...

create the ssis package and schedule it from sql server agent

Howdy EML,

Did the solution provide resolution?

(sound like a rapper :-))

Chris is right

replace

convert(char(10), OrderDate, 120) with

OrderDate

from the solution

the Code i was asking for is the create statements and insert dummy data, created below

this should resolve your problem. let me know how it goes

---Create Table

create table test( smalldate...

El Gato (11/10/2010)

---

Hi guys, our developer is not in today and I need help to generate the following query in a dynamic fashion:

SELECT *

FROM dbo.ZNodeOrder NO

INNER JOIN dbo.ZNodeOrderLineItem NOLI

ON...

I would look towards partitioning. Although the end user will see 1 table, the physical file groups will be stored on different drives for speeds of access.

Possibly create non-clustered indexes...

Edward-445599 (11/10/2010)

---

Hi,

I am trying to create a partition on an existing table and I am struggling

The only way I can think of doing this is to create a blank...

Please paste some DDL code and sample data.

In theory, I would have the working day column as a bit data type. if 0 non working day, if 1 working day.

on...

please check your scripts. you got 4 columns and inserting 3 values.

Not too sure on the p-sql

but heres t-sql

declare @p int

begin

if @p is null

select * from dataset

else

select * from dataset where @p=' values'

end

beat by 27 sec. 🙂