Phil Parkin

Forum Replies Created

Viewing 15 posts - 2,026 through 2,040 (of 13,877 total)

Reply To: Error while altering SP

Without knowing more about dbo.[spAmount_V1], I can't do that.
Please post the 'signature' of that proc. That is, the following bit
CREATE PROCEDURE <procname> <parameters>
AS
In particular, you should have an OUTPUT parameter...

June 8, 2021 at 8:16 am

#3893283
Reply To: Error while altering SP
Stored procedures return results differently from functions. Here is an example proc and how to call it:
```
CREATE PROCEDURE dbo.DuffProc @RetValue VARCHAR(50) OUTPUT
AS
BEGIN
    SET @RetValue...
```
June 7, 2021 at 9:29 pm

#3893135
Reply To: Insert data using view
Try changing this part
(SELECT BirthYear = n + 1921, Age = YEAR(GETDATE()) - n - 1921) calcs
JOIN GroupInfo g
ON calcs.Age
BETWEEN g.StartAge AND g.EndAge
ORDER BY Tally.n DESC;
to this
```
(SELECT...
```
June 7, 2021 at 4:25 pm

#3893042
Reply To: Insert data using view
piu.scorpio wrote:
Hi @SSC Guru
I Just get a list of Distinct birth years from Customer table. So then based on that list I need to further calculate the other values
June 7, 2021 at 2:48 pm

#3893006

Reply To: Insert data using view

As you have not provided any DDL or sample data, and your sample results do not appear to include a single reference to your customer data, I had to guess:

June 7, 2021 at 2:05 pm

#3892974

Reply To: Updating and Loading Data using SSIS

I cannot not see any question here.

June 3, 2021 at 8:41 pm

#3891652

Reply To: How to Insert Column in and existing table

OK, understood. Unfortunately, I do not have time today to help any further. If no one else answers in the meantime, I will try to get back to you in...

May 28, 2021 at 4:03 pm

#3889294

Reply To: SSIS Package loading CSV failing

Are there embedded carriage returns in that file?

Have you set a text qualifier? (")

May 28, 2021 at 4:00 pm

#3889279

Reply To: Invoking .dtsx file via Excel - different behavior

As packages usually run within the context of an unattended process, message boxes within them should be avoided (unless developing or debugging).

I notice you mentioned users running this. For them...

May 28, 2021 at 1:26 pm

#3889220

Reply To: How to Insert Column in and existing table

Also, how is the value of ColumnType determined?

May 28, 2021 at 1:13 pm

#3889219

Reply To: How to Insert Column in and existing table

OK, that helps.

So you are looking for a routine which imports only the first row of a spreadsheet/CSV file, transposes that row of data into separate rows and adds them...