View Complete Post
I can't find a way to stop unauthorized users from sending documents to a Records Center site. Can someone please help me? Do i need to configure anything to restrict it to the members of the web submitters group?
I'm still using MOSS2007
can anybody plz tell me how to stop re-loading of page after selecting a date from a calendar control in a aspx page.
I want to show the selected date in a Textbox control but i don't want to re-load the page.
I want to get all records that are 7 days pass today's date and not equal to today's date. Don't know how to write it so I can get records 7 days old but with this procedure I'm still getting records that are due today. Hope this makes sense. Can someone assist me.
select * from libraryrequestwhere duedate > getdate() and duedate != getdate()
I tried finding a QA which already addressed this idea, but with no luck. Sorry if it's been addressed before.
I have a table where sales pricing is managed; it contains history of pricing where every price record has an 'effective date'. Currently when a user needs the 'active' price for a customer/item combination, the table is queried by the record that has the
most recent 'EffectiveDate' before GETDATE(). Here is the def for table 'tim_PriceSheet'
ItemKey int, not null
EffectiveDate datetime, notnull
ListPrice decimal (15,5)
The primary key is set on ItemKey, EffectiveDate
ItemKey EffectiveDate CurrID ListPrice
45 2010-07-01 00:00:00.000 CAD 100.00000
45 2010-09-14 00:00:00.000 CAD 110.00000
45 2010-10-01 00:00:00.000 CAD 112.00000
63 2010-09-01 00:00:00.000 CAD 45.00000
63 2010-09-01 00:00:00.000 USD 45.00000
63 2010-09-18 00:00:00.000 CAD 40.00000
63 2010-10-01 00:00:00.000 USD 40.00000
63 2010-10-15 00:00:00.000 CAD 41.00000
63 2010-10-21 00:00:00.000 USD 41.00000
My challenge is this:
I want to return a record set which shows the current price for each distinct item and currency code; in the example below the result would be based on the date being September 16, 2010
I have to tables with dates, table Employments with all employements of all employees, with start date and end date, and a table Mutations with mutations (e.g in salary) with start dates.
Now I try to write a query which returns a record for each day an employee is in employment, with the correct salary. SO at first, it should return all days between the employment start date and the first mutation date, then the number of days between
the first mutation date and the second mutation date etcetc, and at last the number of days between the last mutation date and the employment end date. The number of mutations varies for each employment, and employees cna have multiple employments (history, so
not at the same time) in the employments table.
How to do this?
I have two pages, the first is datepicker.aspx and it contains a textbox where I enter in a date in YYYY-MM-DD format and a button that performs a postback to results.aspx. Results.aspx has a gridview where I'd like to see records from the journal table in my SQL database that have the date I entered back in datepicker.aspx only the gridview never produces results.
I'm using the following query in the datasource, if I test it in the datasource wizard it works and it also works when I run it directly against the database.
SELECT * FROM QM.Jou
I have a table that contains records with a start and end date.. within our application we have another table that contains a retention number.. its a number 1 thru 100 or -1 indicating retain forever.
Now i need to pull back all records that are in the table that have a deviceID = 231 and that have a startdate < the retention period.. So what i was expecting was records that have a startdate less than the retention time from todays date..
I have the following 2 queries that return the same results.. and not really sure which logic would be correct.. for this example, there are 15 records for that ID.. and 2 of which are older than 20days ago. So which logic should i use?
DECLARE @retention_time intDECLARE @id bigint
SET @retention_time = '20'SET @id = '231'SELECT * FROM DeviceInfo WHERE Id = @id AND DATEDIFF(day, startDate,GETDATE()) > @retention_timeSELECT * FROM DeviceInfo WHERE Id = @id AND startDate < (GETDATE() - @retention_time)
I've created a matrix report that displays the quantity of different products set to expire by month/year. The stored procedure returns records for a variety of products and each record contains an expiration date. If there are no products/records that contain an expiration date of lets say 6/2010 then 6/2010 will not appear as a column in the report.
I need a way to force these month/year columns to appear in the report.
Does anyone have a suggestion on how I can make that happen?
I need to select records in my database based on todays date. I have a date field that saves a future scheduled ship date for orders and need to use a select statement that would use todays date as a parameter. I am able to do this by manualy entering the date in the select statement but when I use todays date with inline code in the select statement it does not work. Please look at the code segment below:
<%Dim strTodaysDate As StringstrTodaysDate = "'" + Date.Now.AddDays(9).ToString("MM/dd/yyyy") + "'"%>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:DAVINCIORDERTRACKINGConnectionString %>" SelectCommand="SELECT * FROM [OrderTracker] WHERE (CONVERT(char(10), ScheduledShipDate, 101) <> '<% =strTodaysDate %>')"> </asp:SqlDataSource>
The segment above returns all records. And if I just enter the date manually in the select statement like below it returns the correct records:
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:DAVINCIORDERTRACKINGConnectionString %>"