.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Easy Web
Imran Ghani
Post New Web Links

Compare current with previous data

Posted By:      Posted Date: September 23, 2010    Points: 0   Category :Sql Server
 
I need to compare the current price to an old price and not quite sure how to approach it. I am bringing in 3 CTE's that contain all of the data. Then # the bottom I'v got effective dates but I'm not sure how to re-write this and compare current prices to the old price that was effective before. The DNC Column is the column i have to compare in the last query
declare @dt datetime
set @dt = getdate();



With itmlvl as (


 

View Complete Post


More Related Resource Links

Set up a validator that compare the value of the current field with an other (using Dynamic Data)

  
Hi! Most of it is in the title : I'd like have a validator on the DateTime_Edit template for example that allows to compare this field with an other DateTime field. My problem is when I am in the DateTime_Edit template of my "master field" (the one I want to check), how can I access to the other field given the architecture of Dynamic Data FieldTemplates? But perhaps I'm not thinking in a good way on this control. Any advice will be welcome. Thanks Raphaelp

Merge SQL to Excel--Need .Net button to open on fly and have current SQL data!

  

           Hello all,
I do not know if this is the proper place to ask this, but my question is...
I have a SQL DB and I want to convert it to Excel Sheet (I did this using the wizard)!
In my aspx page I have a button.  So when I press this button I want the Excel sheet to open!  But I need the Excel sheet to show me the up to date information that is in the SQL DB.  

The current build operation (build key Build Key[Microsoft.Practices.EnterpriseLibrary.Data.Database

  

Hello everybody,

 

i am encountering an exception in my in my application at these lines of code.

 

DatabaseProviderFactory dbFactory =

new DatabaseProviderFactory(dataSource);// Create and return a database object.

 

return dbFactory.Create(name);

 

i am getting this exception at the create line

 

The current build operation (build key Build Key[Microsoft.Practices.EnterpriseLibrary.Data.Database, 125ba2c1-9573-45be-b8a2-b370deff980d]) failed: Exception has been thrown by the target of an invocation. (Strategy type ConfiguredObjectStrategy, index 2)

 

I have referenced the proper assemblies in my project and on  other systems, its working fine.

The connection string is DB2.My db2 connection is also good with no issues. My stack Trace

How to get "Current Date" on SharePoint Designer for Invoice Ageing Data View Report??

  
Hi Experts, I would like to know how can i get/show "Current Date" in SharePoint Designer ?? Any good tutorial ? FYI, I need this "Current Date" for my Ageing Data View Report, Purpose To offset with "Invoice Receive Date" to get total days of payment payable for the invoice. Please assists, Thanks

Set Field in Current Item to a previous version's field value

  
When using SPD, can you make a WF condition to set a field's value to it's previous version's value? Versioning is turned on for this doc library, but checkin/checkout is not on. These WF's run only after creation and editing, so I need to set a value back if a user doesn't have permission to set a choice column field to specific values. Thanks in advance, Chris

Unable to get current username via data connection

  
I'm trying to use a browser enabled form.  I've followed the directions on this site to get the current profile username. http://baigadil.blogspot.com/2008/07/get-current-user-for-infopath-and-set.html When i open the form, i get the following error message: An error occurred accessing a data source. An entry has been added to the Windows event log of the server. Log ID:6932    

Unable to get current username via data connection

  
I'm trying to use a browser enabled form.  I've followed the directions on this site to get the current profile username. http://baigadil.blogspot.com/2008/07/get-current-user-for-infopath-and-set.html When i open the form, i get the following error message: An error occurred accessing a data source. An entry has been added to the Windows event log of the server. Log ID:6932    

Ways to exctract data besed on current day

  
Dear all, I have a table which have fields like FirstNAme, LastName, StratOn, EndOn StartOn and EndOn are datatime fields This table is a kind of registration table and I would like to exctract from this table all records where the EndOn fields is corresponding to current day. I do not know in fact the correct way to compare the EndOn field in order that it correspond to the current day in term of year, month and day thnaks for help regards serge  Your knowledge is enhanced by that of others.

compare data from tow tables ?

  
HI all I have tow tables ,, i want to add Column1 from table1 to Column1 in table2 , where Column2 in table1 is bigger than Column2 in table2

Compare Data in SSIS

  
I have data from two sources that I want to take two of the columns, compare the values and if there is a difference record that value - what's the best solution for such?

How to Correlate Last weekday of previous Month and First Weekday of current Month ? - T-SQL 2005

  
Hi friends, below is my detail description. I woulld like to show busines users Previous Months Last Weekday in Drop Down List as a Parameter. Now, if they select Previous Months Last Weekday, then i need to pass First weekday of Current month. How can i correlate this things ? if you need more information, let me know.   Thanks.

Recover data on a Previous Page after navigating from the page and navigating back

  
How can i recover the data on Page1 after navigating to Page2, so that when i navigate to Page1 from Page 2 i want the unsaved data as is.

Retrieve Previous State Data on return from another page

  

Hi 
I have a list page having date in repeater control. And also having some search criteria on the page. Using that I filter the data on the page. Now in repeater I have Edit button. Which allows me to open that record details in another page.
When I come back to list after saving or cancel, the filtered data is gone. I want to keep that filtered record with selected values in filter controls (checkbox, dropdown etc).
I have two options in my mind 1) Session, 2)

How to get Email of Current User Data View Web Part Sharepoint 2010 and pass to WebService data sour

  
I have to pass in the email address of the current user to a web service data source (run time) of a Data View Web Part.

My Question is:

a) How can I get Email address of current user based  in DVWP.
I know we can get the CurrentUser using the CurrentUserName but how do we get the Email for the Current User.

b) After getting the Email how do we pass to the Web Service.


MDX to pick the data from first day of the current month

  

Hi

I need to make a mdx query to pick the data from first day of the current month.

SELECT [Measures].[Internet Sales Amount] ON COLUMNS,

[Date].[Fiscal].[Date].MEMBERS ON ROWS

FROM [Adventure Works]

 

The above query returns around 4 years of data, but I need the data from first day of the current month.

 

Could anybody help me out!!!

 

Thanks

Randy

 

 


Compare excel data on sharepoint with existing sql server data

  

I have seveal spread sheets loaded on MOSS 2007 (we have Excel Services).  We host our SP on Sql Server 2008 R2 64 Bit on a Windows 2008 64bit server. I want to be able to write a query on that SQL Server database that can somehow access excel data directly from SP and cmpare that to data in SQL. I have been able to create a linked server (using 32 bit sql server) but have only been able to link files directly off the server and NOT from MOSS.

So the Crux of the matter: Is there a way of making some love connection that would allow me to get data directly from my excel spreadsheet that resides ON SHAREPOINT, via my Sql Server?

 


how to subtract value at previous row from current row

  

column1   Column2

1                1

2                1

10              8

20             10

 


Thanks & Regards, PSWASULE
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend