Please post table def and some sample data in a ready to use format so I have something to test against. (see the first link in my signature for details...

You need to change your subquery to use View_DSA instead of the tally table to use only the weeks that show up in the table. You probably need to...

I'm not sure if the syntax is correct but IIRC this is the way to code the CASE statement in ACCESS

...

Edit: Based on this link it seems like a homework...

What software is the solution for?

You posted in the ACCESS forum so Lowells solution might not help if you're looking for ACCESS code. Please clarify.

What is the table structure?

Seems like you're using commas to separate columns in one example and at the same time as result delimiter within one column.

To avoid confusion please provide...

Duplicate post regarding the same subject.

Discussion already started here.

@anil-2: Why don't you try use the sample code already provided by Wayne and see if you can get it to work...

Please search this site for "DelimitedString8K" to find a really fast T-SQL function or have a look at the TallyTable article referenced in my signature.

There is an even fast CLR...

Four people answering your post all have different, but valid, questions.

I strongly recommend you follow Waynes advice and read the article he pointed you at (which is the same article...

It seems like an "undocumented feature" (aka bug).

I just tried what you described and got the very same effect. After re-running the ALTER VIEW statement without any modification of the...

Two basic concepts I use:

1) if you want to insert just one row:

IF EXISTS (SELECT 1 FROM targetTable t WHERE t.ID = @varId)

UPDATE

ELSE

INSERT

2) If...

Steve,

you asked for some improvement ideas for the SSC site: add the option to upload (and play) sound files :-D:-D

Then we could actually hear the pronounciation of all the...

Something like the following?

I'm using a subquery to get all valid numbers that will fit into your matrix (0 to 31) and use a binary test within a CASE statement.

SELECT...

I second Wayne and will go one step further:

Please describe what you define as "DaysBetween": calendar days, working days, business days or something totally different...

If it's neither calendar (7 days...

I'm not sure how your final solution would look like...

I'd use the following approach:

DECLARE @tbl TABLE

(

start_ INT, end_ INT

)

INSERT INTO @tbl

SELECT 1, 74 UNION...

Here's how I'd do it (looks a little messy though, maybe someone else will come up with a better solution..):

SELECT

CAST (

(SELECT

COUNT(*) AS CurrencyTotalCount,

1 AS CurrencyRateInsertCount,

12 AS...