And please don't post multiple threads with the same question.

jbalbo (6/25/2013)

---

Hi

Looking for some samples on how to create a matrix report to show all days of the month even if there is no data for that date

so if the...

Thanks for posting the proc that you are working with. As I said previously we need to have ddl and sample data. These both seem to be missing from your...

No your sample data does not work as posted. Here is the script after removing all the references to EDMS.

CREATE TABLE [dbo].[tblDocuments](

[Originator] [nvarchar](255) NOT NULL,

[Document Type] [nvarchar](255) NOT NULL,

[Unit] [nvarchar](255)...

tonyarp05 61903 (6/25/2013)

---

I am really sorry.

I couldn't provide data, its having more data and also i couldn't get it for specific data for sample.

please give me some idea how this...

Any suggestion on what might be causing a stored proc to execute as a previous version of itself rather than it's modern version? If so, how can I force the...

Thanks for posting ddl and sample data. There seems to be something a little wrong with your sample data. It will not run because it violates some of your foreign...

Hi and welcome to the forums. I would agree that getting rid of the cursor is a good way to go. In order to help we will need a few...

What have you tried? Did you read through this thread (which...

Just like you would with any other select statement that you would use as the source of an insert...

For an existing table:

Insert into YourExistingTable

SELECT *

FROM (

SELECT

year(invoiceDate) as [year],left(datename(month,invoicedate),3)as [month],

InvoiceAmount as...

jbalbo (6/24/2013)

---

Here is snippet of the code

SELECT Client.LName + ', ' + ISNULL(Client.FName, ' ') AS clientname, RECORDED_SERVICE.STARTTIME,

...

Pretty spare on the details here. I will take a shot in the dark. Maybe you can use ROW_NUMBER and group by date?

If you want more detail help we will...

I know you are brand new...

yes. Look up xp_sendmail. Or you could create an...

Larry.Findley (6/24/2013)

---

In the following NON-CORRELATED subquery

DELETE

FROM dbo.DimCustomer_LLF

WHERE CustomerKey in (SELECT DISTINCT(CustomerKey) FROM dbo.cdc_states);

GO

we should get a syntax error. CustomerKey is not a column in dbo.cdc_states. If we...