Comments by chints786 (Top 28 by date)

I will not serve my purpose because i want the identity column to work and generate the identity number.

The readonly property is not an issue because it is set to off:

read_buffer_size 262144
read_only OFF
read_rnd_buffer_size 524288

I did this one too and set the variable to some value and yes it did populate rv.value=test.

Thanks Richard.

I did go through the links and I was able to read a simple pdf.

however i am getting error when i am trying to install textract. I am using the command pip install textract. but it throws me the below error:-

ERROR: Failed building wheel for pocketsphinx

I have installed Anaconda and i am using it on windows 10

I haven't asked for complete code out here. A guidance to the question was required.
Also dont jump to conclusions as to I am getting paid or it is my grade. If you cannot help then there is no problem.

apology for the delay. yes you are right. but after getting the desired result i had copied to excel and then I had a macro created which transposed the data as per my need.

Thanks CHiLL60 and apologies for the late response.

I was able to get the result using unionall

SELECT TOP 1 'itemid', [Att Name 1], [Att Name 2], [Att Name 3]
from TEST
UNION ALL
SELECT [itemid], [Att Value 1], [Att Value 2], [Att Value 3]
from TEST

Thanks a lot for your help!!!

Can you write the code and give?

how is it possible with case?

Thanks Santosh!! Can you please let me know what if I have data in fraction say

Col1
1/2
2/3
4/5
0.123
0.345
0.222

I want only the fraction part i.e

Col1
1/2
2/3
4/5

Col1
1/2
2/3
4/5

Done.

Thanks once again!!

Thanks a ton Maciej. I was able to do the necessary changes. Once again thanks for your help!!!

Probably i tried changing some code based on your comments but i may be wrong.

'you need to change a code-context!
'read below comments
Set srcWsh = Sheet1 'refers to first worksheet in a workbook - source worksheet
Set dstWsh = sheet2 'refers to second worksheet in a workbook - destination worksheet
dstWsh.Cells.Delete xlShiftUp 'clean up first!
With dstWsh.Range("A1")
.Value = "ID"
.Font.Bold = True
.Interior.Color = vbGreen
End With

was this which was required?

Hi Maciej,

I am getting error "subscript out of range"

Richard i want to create a macro, I haven't created it anytime
so please help me to create it.

I havent created a macro yet. so I dont know how it is made.

On internet i found the below code


Option Explicit


Sub ATransProd()
Application.ScreenUpdating = False
Dim s1 As Worksheet, s2 As Worksheet
Set s1 = Sheets("Input")
Set s2 = Sheets("OutputX")
s2.Range("A1") = s1.Range("A1")
s2.Range("B1") = "Producto"
s2.Range("C1") = "Unidad"
s1.Range("L1:N1").Copy s2.Range("D1")
Dim lr As Long, lr2 As Long, i As Long
lr = s1.Range("A" & Rows.Count).End(xlUp).Row
With s1
For i = 2 To lr
lr2 = s2.Range("B" & Rows.Count).End(xlUp).Row
.Range("A" & i).Copy s2.Range("A" & lr2 + 1)
.Range("B" & i & ":F" & i).Copy
s2.Range("B" & lr2 + 1).PasteSpecial xlPasteValues, , , True
.Range("G" & i & ":K" & i).Copy
s2.Range("C" & lr2 + 1).PasteSpecial xlPasteValues, , , True
.Range("L" & i & ":N" & i).Copy s2.Range("D" & lr2 + 1)
Next i
End With
Application.CutCopyMode = False
lr2 = s2.Range("B" & Rows.Count).End(xlUp).Row
For i = lr2 To 2 Step -1
If s2.Range("C" & i) = "" Then
s2.Range("C" & i).EntireRow.Delete
End If
Next i
With s2
For i = 3 To lr2
If .Range("A" & i) = "" Then
.Range("A" & i) = .Range("A" & i - 1)
.Range("D" & i) = .Range("D" & i - 1)
.Range("E" & i) = .Range("E" & i - 1)
.Range("F" & i) = .Range("F" & i - 1)
End If
Next i
End With
Application.CutCopyMode = False
Application.ScreenUpdating = True
MsgBox "completed"
End Sub

@Richard:- Thanks a lot for the solution. However there is a small fight with this solution and I should have mentioned in the beginning that my SQL Server 2008 R2 is what I am using right now and the built in function (DateFromParts) is applicable from 2012.

Will be helpful if you could share replacement solution for this function.

yes Tsql only

I have included the flags in table a and table b . the confusion is say for eg if initially the record came in first file is Ryan and the updateidentifier is N, then both the tables will have that record.. but in the second file if the name comes as ryandev and update identifier U i need to update the same record and increement the flag variable to 1...how can i achieve that

can you help me with the code to implement?

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/799ecbe6-306d-4cdc-8e41-35b65a8c1d9c/ssrs-2008-inconsistency-with-excel-export-functionality?forum=sqlreportingservices

The same issue i am facing.

The thing is that the same sp was used to fetch the data till 24th jan and the report was getting downloaded completely. Now also the report gets downloaded but only for a month. The moment the data range is increased from one month to 2 months i get that error. That is the precise error msg which I receive.

Please share your email address i will share the screenshot as well.

Hi Chilli60,

Apology for not responding properly. The SP works fine becoz data gets populated on the SSRS report and also on SSMS. The code consists of select statement pulling columns from multiple tables based on join.

The error msg is below:-

The reportname.xls download was interrupted.

Hi CHilli60

The report takes 2 parameters start date and end date. So I pass those 2 paramters and click on view report.

An sp gets called based on which the report populates the data.

while exporting the data for a month it works fine, but the moment i change the date range from one month to 2 months say december 01 2016 to 31st Jan 2017 the reports loads with the data but throws the error while exporting in excel.