Phil Parkin

Forum Replies Created

Viewing 15 posts - 4,576 through 4,590 (of 13,877 total)

RE: Cursor Update issue

iseedeadpeople - Wednesday, March 21, 2018 6:24 AM
Hi guys i try to update 400 rows with cursor and when i try it...

March 21, 2018 at 6:28 am

#1984108
RE: Why aren't formatting tools working for me in SSMS 2017?

hans.johnson - Tuesday, March 20, 2018 10:34 AM
I'm a long time Data Developer and have been using SSMS quite heavily since 2005....

March 20, 2018 at 11:06 am

#1983999
RE: Spilt a record into 4

Angela4eva - Tuesday, March 20, 2018 10:21 AM
Guys,
have select statement
Select salesid, salesname, salesamount from salestable
ssalesid salesname salesamount
1 ...

March 20, 2018 at 11:02 am

#1983997
RE: SSIS Package Lookup Task - Is not adding the field to the data flow

Paul Giles-Randall - Tuesday, March 20, 2018 10:16 AM
I am in the process of migration data from an old, now unsupported application,...

March 20, 2018 at 10:20 am

#1983988
RE: Using the Name of a CASE STATEMENT later on in a CONCAT

jeffshelix - Tuesday, March 20, 2018 8:56 AM
I understand why i can't do this (using CONCAT with "MOT2". For the same reason...

March 20, 2018 at 9:17 am

#1983958
RE: The type of the value (Int32) being assigned to variable "User::dteNewMaxDate" differs from the current variable type (DateTime). Variables may not change type during execution. Variable types are strict, except for variables of type Object

kartikaya.singh - Tuesday, March 20, 2018 7:16 AM
Hi Phil,
Yes this is happening at the time of deployment.
Wow, that is unusual. Can you...

March 20, 2018 at 8:32 am

#1983936
RE: Setting up CDC

Kris-155042 - Tuesday, March 20, 2018 7:56 AM
Yes
OK, the 2016 Edition Comparison suggests that it should work with SP1 installed,...

March 20, 2018 at 8:31 am

#1983935
RE: The type of the value (Int32) being assigned to variable "User::dteNewMaxDate" differs from the current variable type (DateTime). Variables may not change type during execution. Variable types are strict, except for variables of type Object

kartikaya.singh - Tuesday, March 20, 2018 3:33 AM
ï»¿Hi All, I am getting the below error when dba is trying to deploy the...

March 20, 2018 at 7:11 am

#1983911
RE: Setting up CDC

Kris-155042 - Monday, March 19, 2018 11:38 PM
I'm trying to set up CDC and I get the following error when running the...

March 20, 2018 at 7:10 am

#1983910
RE: Using CTE with Parameters in OLEDB Data Source in SSDT (or why is SSDT so braindead?)

OK, created version 2 of the query, using a DateTime2 column from the standard MDS database:
WITH SomeData
AS
(
SELECT *
FROM
(

March 19, 2018 at 12:48 pm

#1983817
RE: Using CTE with Parameters in OLEDB Data Source in SSDT (or why is SSDT so braindead?)

I created a somewhat similar 'fail query' to yours, but which should run on others' systems. Here it is:
WITH SomeData
AS
(
SELECT *
FROM
    (
     SELECT
       *
     ,    rn...

March 19, 2018 at 12:17 pm

#1983807
RE: SELECT inside job Command

lukaszpiech - Monday, March 19, 2018 5:40 AM
Hello,
I have a job that consists of two very simple steps:
Step 1:
INSERT INTO MyTable
SELECT *...

March 19, 2018 at 6:03 am

#1983740
RE: Add or subtract Fractions in sql server 2005

shiwani.plrs - Monday, March 19, 2018 5:13 AM
I am looking for a way to add or subtract fractions stored as
2/3 , 7/5...

March 19, 2018 at 5:28 am

#1983738
RE: Using CTE with Parameters in OLEDB Data Source in SSDT (or why is SSDT so braindead?)

In my opinion, embedding complex SQL logic in an SSIS package is a bad idea. Because when it comes to considering changes to a database (for example refactoring, new features,...

March 16, 2018 at 5:20 am

#1983533
RE: SSIS to Windows Clipboard

steve.alston - Thursday, March 15, 2018 9:28 PM
We need to check that missing demographic data is below 10%, so along the way...

March 16, 2018 at 5:14 am

#1983530

Viewing 15 posts - 4,576 through 4,590 (of 13,877 total)