Click here to Skip to main content
15,888,113 members

Comments by saifulhaque (Top 21 by date)

saifulhaque 8-Sep-21 6:15am View    
It is working fine.Thank you so much...
saifulhaque 15-Jul-21 10:58am View    
Yes it is far

My sql query procedure

SELECT	ISH.BinLocation AS [BinLocation], I.ItemName, I.[Description], ISH.QuantityInStock, 
		CAST(
				(
					CAST(I.BoxLength AS DECIMAL) * CAST(I.BoxHeight AS DECIMAL) * CAST(I.BoxWidth AS DECIMAL) * CAST(ISH.QuantityInStock AS DECIMAL)
				) 
				/ @CubicInchToCubicFeetConversionFactor
				AS DECIMAL(18,2)
			) 
		AS [ItemVolumeCF],
		I.BoxLength, I.BoxHeight, I.BoxWeight, I.StatusEnum,ISH.SnapshotDate 
FROM Item AS I
inner join InventorySnapshot AS ISH ON I.Id =ISH.ItemId
and ISH.SnapshotDate=CAST(@SnapshotDate AS DATE)
<pre lang="SQL"><pre lang="SQL">


I am passing date from MVC view .date part only.
When I am checking with locally connected with web.cofig it is working fine.
When I published to server rows are coming before one day.

Time zone mountain standard time


If I try to add one day with date inside code it is working.I think it is because of time diffrence.How we can solve this.
saifulhaque 23-Jun-21 5:35am View    
Thank you for your efforts !! . The code is working fine .
saifulhaque 22-Jun-21 15:18pm View    
This string is not fixed.It is dynamic .I posted here an example.If the person search keyword in text box with space normally sql query will convert % and show the matching result.
We can use like this an example

Copy Code
SELECT *
FROM Item WHERE (PartNumber LIKE 'KEA%12201%N%')

May be the person search more spaces it should be show the matching result.

Example

Search key word is 'asd hjk tyu io 456 tyu' in sql direct query in management studio editor replacing space with % will show exact result.
saifulhaque 22-Jun-21 15:13pm View    
This is not working .May be EF version different