Viewing 15 posts - 1,321 through 1,335 (of 2,452 total)
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 21, 2014 at 6:16 am
rtopal1907 (7/21/2014)
Also how do I change Colum header name? For...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 21, 2014 at 5:54 am
rtopal1907 (7/21/2014)
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 21, 2014 at 5:41 am
is this as simple as changing
@captured_column_list = N'CountryId,CountryName,CountryCode'
to
@captured_column_list = N'CountryId,CountryCode'
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 21, 2014 at 4:04 am
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 21, 2014 at 3:42 am
rtopal1907 (7/21/2014)
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 21, 2014 at 3:17 am
halifaxdal (7/20/2014)
J Livingston SQL (7/18/2014)
halifaxdal (7/18/2014)
I think the issue is the last column, like...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 21, 2014 at 12:36 am
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 20, 2014 at 8:11 am
ibrahim46fattakh (7/19/2014)
If it doesn't work, this means the database is severely...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 19, 2014 at 12:32 pm
...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
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 19, 2014 at 10:15 am
will GROUP BY and MAX do it to get the new rows?
edit...whats the business rule for IDKEY...??
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 19, 2014 at 2:38 am
halifaxdal (7/18/2014)
I think the issue is the last column, like I indicated in previous...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 18, 2014 at 1:22 pm
OP...what is the correct answer for the count of "repetitive days"...seems my answer is different than the others ???
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 18, 2014 at 9:14 am
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]...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 18, 2014 at 7:30 am
pmadhavapeddi22 (7/18/2014)
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 18, 2014 at 4:44 am
Viewing 15 posts - 1,321 through 1,335 (of 2,452 total)