What is the value for OPENDT? Is it populated from default constraint.

Depending on what your trying to do. Remember a default has to be deterministic.

This does not work

Create table temp...

Edit:

If your procedure uses dynamic sql then you will need to grant specific select/update on underlying tables/views..

Otherwise you should be okay.

I'm not sure how to solve the dynamic nature of what your discussing, but a query to return as your example requests

SELECT  A1.Geography_ID, AL1.Region_Nm, AL1.State_Nm, AL3.Data_Yr,  AL2.SalesRate

FROM TIME_PERIOD_DIM AL3,...

I personally name the ID column something about the table name. I have my on conventions that I don't want to get into, but basically for table L_Status then the...

The definition you give is a tuple as related to a multidimension Cube.

In DB terms a Tuple is a Row.

Very low level reading, Like Sql 101

http://www.tomjewett.com/dbdesign/dbdesign.php?page=tables.php&imgsize=smaller

>select 1, 6004701, 1, 0, 32, '06/27/2005 14:20:55'

union

select 2, 6004701, 1, 693, 17, '06/27/2005 14:20:55'

union

select 3, 6004706, 1, 1011, 32, '06/27/2005 14:25:55'

union

select 4, 6004706, 1, 656, 30, '06/27/2005 14:25:55'

union

select...

Log Shipping OverView

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_1_server_8elj.asp

FaQ

http://support.microsoft.com/default.aspx?scid=kb;en-us;314515

drop table PunchTrend

CREATE TABLE [dbo].[PunchTrend] (

 [Facility] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

 [District] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

 [Division] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

 [EntryType] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

 [Series]...

Actually I think we need table defs, and sample data for tables you are querying.

PUNCHEVENT, LABORACCT, DATASOURCE

Can you post a Table definition, and some sample data?

http://www.aspfaq.com/etiquette.asp?id=5006

When you say percentage, Percentage of what?

Is this what you mean?

Value, Percentage

9        %40

5        %23

8        %37

Cool, So just wrap that field in a coalesce(fieldName,'') and you should be all good.

Err, I deleted my post, Because I'm not sure that was the problem,

But start out by setting @sqlstring = ''

But in Debugger, check the line that it gets set...

Create table Dups (pk int identity, Foo char(1))

Insert into Dups (foo)

Select 'a'

union all

Select 'b'

union all

Select 'c'

union all

Select 'd'

union all

Select 'e'

union all

Select 'a'

union all

Select 'c'

union all

Select 'e'

-- Shows each combination of...

Not quite, Notice on 6004706, there are 4 records, 2 w/ sourece iD 1, and 2 with sourceId 2. output needs 2 more columns, if no cousreid 2, then these...

Inherently sql server handle's memory very well, but the in memory temp tables have some sort of bottleneck. When there are a ton of rows 100's vs 10,000s, Then the...