It looks vaguely familiar - possibly the output of the Crystal query designer?

zahid_7777 (10/8/2012)

---

I just like to know the command to copy data (specific range like 10 rows) containing in a COMPANY_CODE and will be copied to another COMPANY_CODE starting with a...

Welcome to ssc. There's an excellent article linked in my signature block "please read this" - have a read, it will help you get faster, more accurate answers to your...

Grant Morton (10/9/2012)

---

Thanks for the responses everyone.

I tried the following code which ChrisM@Work suggested:

SELECT dgs.Shift, SUM(dgs.Value) AS ShiftTotal

FROM Reporting.fctDeltaGammaShift dgs

INNER JOIN Reporting.dimLifeLicence LifeLic

ON dgs.LifeLicenceID = LifeLic.ID

AND LifeLic.LifeLicence IN ('LL','LA','CAL')

INNER JOIN...

Jeff Moden (10/8/2012)

---

I did say that I needed to make a change to get it to work and...

Carl0s_ (10/8/2012)

---

Thanks for reply ChrisM@Work

I have the same structure in my city table, I refer to (state region) with entity cat (federative entity), my doubt here is, is correct to...

Have a look here: http://sqlserverfaq.com/%5B/url%5D

Skanda (10/8/2012)

---

Hi,

Function is working fine,

but when ever i call the function, it should return single value only,

if i call 10 times - 10 alphanumeric values should be written...

Sean Lange (10/8/2012)

---

blakmk (10/8/2012)

---

I have a requirement to return a batch of records and then mark the batch complete. I was thinking to acheive this with a select and the...

ChrisM@Work (10/8/2012)

---

Carl0s_ (10/8/2012)

---

Can someone tell me an opinion about this design?, is bad to use composite key in that way, is better to use subrogate? and what is better way...

Carl0s_ (10/8/2012)

---

Can someone tell me an opinion about this design?, is bad to use composite key in that way, is better to use subrogate? and what is better way to...

You will need to persist the values which have already been generated, or read them from the table in which they are being used.

Create a table outside of the...

Grant Morton (10/8/2012)

---

Thanks for the response. I don't think it's related to the link you sent because I'm not using INTERSECT. Here is the query which generates the error:

SELECT Shift,...

dwain.c (10/8/2012)

---

Chris - I'm gonna keep moanin' until I win one of these performance races against you.

So I'll submit this (stealing your Tally table):

;WITH Tally (n) AS (

...

You need to replace the SELECT * with actual column names.