oops...too hasty in my response...."Current" is a reserved word...this can be overcome by enclosing in square brackets or alter the name to something that isn't reserved...

rtopal1907 (7/21/2014)

---

you were right I missed commas, it has been fixed now and working perfectly thank you very much for your help.

Also how do I change Colum header name? For...

rtopal1907 (7/21/2014)

---

thanks for your reply I get these error messages

1- incorrect syntax near the keyword'CASE'

2- incorrect syntax near the keyword'age31to60'

3- incorrect syntax near the keyword'age61to90'

I have put the...

is this as simple as changing

@captured_column_list = N'CountryId,CountryName,CountryCode'

to

@captured_column_list = N'CountryId,CountryCode'

as a start...does the following query give you the results you expect?

SELECT

Entities.Code

, Entities.Name

, Ac_Billbook.MatterRef

, Ac_Billbook.BillDate

, Ac_Billbook.Ref

, Matters.FeeEarnerRef

, Users.FullName

, Ac_Billbook.OutstandingTotal

, CaseTypes.CodeName

, CaseTypes.Description,

, CASE WHEN DATEDIFF(day, Ac_Billbook.BillDate, getdate()) Between...

rtopal1907 (7/21/2014)

---

Dear all

I have a data table which has list of bills with date and outstanding total.

If the bills dates between 0 and 30 I like to insert...

halifaxdal (7/20/2014)

---

J Livingston SQL (7/18/2014)

---

halifaxdal (7/18/2014)

---

Here is the format file, .xml is changed to .txt to get uploaded on this forum. Thanks.

I think the issue is the last column, like...

as an example of what may work for you...........

I have a spreadsheet called JLS.xlsx that is always stored in C:\xlimport (C:\xlimport\jls.xlsx)

it has a worksheet named "data" that I want...

ibrahim46fattakh (7/19/2014)

---

You can try to Compact and Repair your corrupt database. This is the very first solution you must try.

If it doesn't work, this means the database is severely...

...and here is a link that defines your problem exactly...including poor grammar and spelling errors....hmmmmm:-)

http://p2p.wrox.com/access/28374-ms-access-mdb-ldb-database-corrupted.html

will GROUP BY and MAX do it to get the new rows?

edit...whats the business rule for IDKEY...??

halifaxdal (7/18/2014)

---

Here is the format file, .xml is changed to .txt to get uploaded on this forum. Thanks.

I think the issue is the last column, like I indicated in previous...

OP...what is the correct answer for the count of "repetitive days"...seems my answer is different than the others ???

this is just for your "repetitive days"

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[temp_tbl]') AND type in (N'U'))

DROP TABLE [dbo].[temp_tbl]

GO

CREATE TABLE [dbo].[temp_tbl](

[tbl_id] [bigint] NULL,

[cs_id] [int] NOT NULL,

[USERID] [int]...

pmadhavapeddi22 (7/18/2014)

---

twin,

we have two date columns like assgn_dtm and complet_dtm.

Need to calculate the difference of these two dates

for a given cs_id and userid

cs_id and userid can have multiple rows...