Correct Jeff Moden   start date should be 2006-08-02 instead of 2004-08-02,  hat was a type .

Well basically my Rundate column is in ascending order and I have to  setstart and enddate range every time row is null or empty. so after null column will be...

I have a Parameter which has two Values H1 and H2 and then in tablix properties visibility section I have choose show and hide based on expression and...

Bingo,

well life is so much easier with SQL2005. I was trying to do it with cursor it was very cumbersome below is what I had but you...

well I have a linked Server which is 2005 , I can use that to extract data from 2000 add the rownum() and put the table back in 2000...

well I have a linked Server which is 2005 , I can use that to extract data from 2000 add the rownum() and put the table back in 2000...

there is no Primary key , table is populated by a text file. does setting up SKU columnas Primary key help

This was really close but when I ran this test data below My first row is coming up as all Null values

becuase ExpDate1 and Expdate 2 are same

SKU ...

no it doesn't matter which rows values are in PO1,QTY1 and in Date1 they can be random, but Date1 and QTY1 should be related to PO1.

so in the example above

when...

Arun,

MY format is like this

SKU PO# QTY DATE

Abc w1 12 2009-03-12

Abc...

Hi Bob,

I am creating a Report , which shows for every stock unit what are the sales , inventory and

how many open Purchaseorder(PO) are out there , so if one...

Our business rule don't allow more than 3 purchase order with in the Date range I am using for this Query

The max number of Purchase order are three same with...

that how the data is

SKUPO# QTYDate

1'640050193''X1234' 122'03/13/2009'

2'640050193''V3344' 244'02/11/2009'

3'640050193''A1233' 43'02/9/2009'

I want to cnver it inot column this way

SKU ...