Viewing 15 posts - 1 through 15 (of 233 total)
Unfortunately I cannot add a new column in the table TypeOfVisitas the table schema is already freezed. No further change is allowed.
So please explain, I can get the first letter...
March 5, 2020 at 7:03 pm
Thanks Neil for your valuable answer. You made my day.
Also grateful to Thom for explaining more on this.
February 18, 2020 at 3:49 pm
My requirement is as follows:
I am getting two input parameters in my stored procedure namely
Year & Quarter from the UI form.
@QuarterID bigint
@Year ...
February 17, 2020 at 9:53 am
What if I have a column CreatedBy which is having datatype NVarchar(256) NULL instaed of QuarterID. I have changed my query like the one below. Will it be ok?
January 27, 2020 at 1:39 pm
Thanks Phil !! Both the columns NodeID & QuarterID are having records starting from 1. Hence it won't be a issue.
January 24, 2020 at 2:38 pm
Thanks for the reply. I changed my above query accordingly i.e. the way you have suggested. I hope it will work.
With ExpandedDataset as (
select NodeID, QuaterID
from Nodes
union...
January 24, 2020 at 11:42 am
When the above query in the ExecSQL task returns 0 rows, the task is getting failed due to 'Single Row' property.
What can be done to avoid this error & keep...
January 23, 2020 at 12:46 pm
Table schema I have provided, is the one required. IDENTITY property is defined on that table. Hence I am using IDENTITY_INSERT ON.
Data is populated from the application & not inserted...
January 13, 2020 at 8:58 am
Yes, I am replacing TRUNCATE with DELETE. There are around 150 tables in total & for around 80 tables I have to reset the identity. Rest, of the tables, I...
January 10, 2020 at 12:02 pm
Thanks for the replies. From your expert comments, I could reckon that the query I am using can be changed to the following one, which will serve my purpose.
January 10, 2020 at 9:27 am
DELETE will be happening as TRUNCATE is not supported, even though I disabled the table constraints. Si I have replaced DELETE instead of TRUNCATE.
I have tested this script by executing...
January 9, 2020 at 9:51 am
Thank You Phil..It worked like charm. Both query tweak & SSIS tip worked great for me.
December 23, 2019 at 6:48 am
How can it be done? Please explain the steps.
December 12, 2019 at 2:41 pm
Yes, this query returns a value 4. This value 4 needs to be passed as input parameter value for input parameter @QuaterID.
December 12, 2019 at 2:40 pm
Thanks, I am using the OLEDB connection.
I want to pass the following query resultset value as input parameter value for @QuaterID.
SELECT QuaterID FROM Nodes WHERE NodeID =...
December 12, 2019 at 1:58 pm
Viewing 15 posts - 1 through 15 (of 233 total)