40511 is the serial date in excel for 29/11/2010

Excel holds dates as days from 01/01/1900 (where 01/01/1900 = 1)

So your method of...

please post the format file as your columns do not match the data

SSRS IN operator works on Arrays, convert your string list to array using Split

First you need to change your query to produce the following

MonthCategoryCategoryValueDistrictnameStorenameEmployeename

JanCAT15district1store1employee1

JanCAT15district1store1employee1

JanCAT15district1store1employee1

JanCAT24district1store1employee1

JanCAT24district1store1employee1

JanCAT24district1store1employee1

FebCAT110district1store1employee1

FebCAT110district1store1employee1

FebCAT21district1store1employee1

FebCAT21district1store1employee1

MarchCAT13district1store1employee1

MarchCAT13district1store1employee1

MarchCAT13district1store1employee1

MarchCAT22district1store1employee1

MarchCAT22district1store1employee1

MarchCAT22district1store1employee1

Then using the wizard create the matrix like this

madan.kapil-1069442 (1/15/2014)

---

Koel - I've a requirement to run 2 separate sql commands and post both result sets in separate csv tabs (sheet1.. sheet2) within a single csv file.. Can you...

What do you mean by 'sum(CAT1) for Jan month'

CAT1 is a category

What value do you want below each month for each category, your query seems to have a few summed...

Note sure exactly what your'e after, but if it is to show months under each category and the count of rows under each month then

Add a matrix to the body...

patrickmcginnis59 10839 (1/14/2014)

---

In this snippet:

sqlcmd = "Create table #Eft_Transfer( " & vbCrLf _

& " EFT_No varchar(20), null , " & vbCrLf _

& " Effective_Date datetime , " & vbCrLf _

&...

You cannot cast 'EFT0000000220' to bigint.

You can cast the numerical part, ie CAST(SUBSTRING('EFT0000000220',4,10) as bigint)

What is the expression that is failing?

;WITH result (category,ids) AS (

SELECT category,

STUFF((SELECT ',' + CAST(b.id as varchar(10))

...

Grant Fritchey (1/10/2014)

---

ChrisM@Work (1/10/2014)

---

Grant Fritchey (1/10/2014)

---

Jeff Moden (1/8/2014)

---

rodjkidd (1/8/2014)

---

Weather update, as Grant has discovered it gets dark here very quickly, that and the rain and wind seems to be the...

;WITH a (bill_no,cust_det,product,Price,bill_date,rowid)

AS (SELECT bill_no,cust_det,product,Price,bill_date,ROW_NUMBER() OVER (PARTITION BY bill_no ORDER BY price DESC) FROM Bill_max)

SELECT bill_no,cust_det,product,Price,bill_date

FROM a

WHERE rowid = 1

ORDER BY bill_no ASC

I would concur with MM it could be the trigger.

Can you post the full code for the trigger?

Depending on what the trigger does, running the code in query window may...

DECLARE @sid varbinary(39)

SET @sid = 0x0105000000000005150000008BB113BE47890628D2E79F97E8030000

SELECT 'S-1-5-21-'

+CAST(CAST(CAST(REVERSE(CONVERT(binary(4),'0x'+sys.fn_varbintohexsubstring(0,@SID,13,4),1)) as varbinary(4)) as bigint) as varchar(10))

+'-'+CAST(CAST(CAST(REVERSE(CONVERT(binary(4),'0x'+sys.fn_varbintohexsubstring(0,@SID,17,4),1)) as varbinary(4)) as bigint) as varchar(10))...