I believe this is what you are looking for

use pubs

go

-------------------------------------------------

Create table taba(

Customer_ID int

,COST money

,TRIP_ENDDATE datetime

)

Insert into taba select 001, 200.00, '01/14/1997'

Insert into taba select 001, 300.00, '03/06/1997'

Insert into taba select...

This should work,

use pubs

Create Table Trip(

SeqNum int

,Product varchar (50)

,Van varchar(50)

,Driver varchar(50)

)

Create table ConsignmentCalls(

ForeignSeq int

,Location varchar( 50 )

)

insert into Trip

Select 123, 'ProductA', 'WER1234', 'Joe'

insert into Trip

Select 124, 'ProductB', '3535TRE', 'Mick'

Insert...

Your problem is similar if not the same as one discussed a few weeks ago with the subject line something like ....dynamic cross join query ... will see if I...

Analysis services have a useful tuturial that works with foodmart2000 that will teach you the basics of creating calculated members

The number is generated from the SPID or GUID used to create the object

The issue with dates comes up frequently in my experience. I use one of two ways to avoid the Problem: Either I send it as '20030629' (yyymmdd) or more...

I came across a tool that could recommend different ways to execute a given query. It would test the options for there relative speeds and highlight those that were...

Yes there is. You can use vb / C++???? to create dts packages. Check BOL for the DTS object model

I decided to not to use the ftp task for this type of operation, can not remember the error I was getting. I Decided to create a script file...

It looks like you need a query for each Store left joined to each other on ItemNum To look like

Select * from

(

Select ItemNum, S1_Traited, S1_Valid

from SourceTable

Where Store = 1

)...

How About this:

Create Table #Sales( Value Varchar(50) )

Insert into #Sales Select 123

Insert into #Sales Select 1230

Insert into #Sales Select 12300

Insert into #Sales Select 123000

Insert into #Sales Select 1230000

Insert into #Sales...

Trying to do manipulation in the transfer is not always a great idea. I would suggest writing a dynamic script that cycles through the columns in the sql table...

I noticed that no one has used Lotus Notes.

For some types of applications it would kick SQL's ass the same way SQL does to Access. I particularly dislike Access...

Anbu, I am not to sure what you want to do with the dimension. Please explain

Create a calculated Member with

the formula

Sum( YTD(), [Measure].[unit sales])