Click here to Skip to main content
15,567,585 members

Comments by Shweta N Mishra (Top 200 by date)

Shweta N Mishra 12-Jul-16 6:46am View    
dynamic Pivot does not work until and unless you use dynamic query. i.e. you need to prepare a query string with dynamic columns and then execute it.
Shweta N Mishra 12-Feb-15 8:40am View    
What i crossed ?

did you tried the code

check this

Create table #Barcode(Barcode Varchar(100))

insert #Barcode select '2014-1024'
insert #Barcode select '2014-1025'
insert #Barcode select '2014-1026'
insert #Barcode select '2014-1027'
insert #Barcode select '2014-1028'
insert #Barcode select '2014-1030'
insert #Barcode select '2014-1031'
insert #Barcode select '2014-1029'

select
*
from #Barcode
where
Convert(int,Replace(barcode,'-',''))>=20141026
and Convert(int,Replace(barcode,'-',''))<=20141030

Shweta N Mishra 4-Feb-15 3:55am View    
What is the datatype of your columns in table
Shweta N Mishra 23-Jan-15 11:35am View    
explain the result you want with data and i guess you are missing a join on OrderDetailID
Shweta N Mishra 19-Jan-15 7:21am View    
what have you tried ?