Duplicate post. Replies here.

Just as a riposte to your fish-frying...

herladygeekedness (8/2/2012)

---

Not talking about the result, talking about the length argument.

I created a simple expression using -2 as length and was unable to save the expression due to...

herladygeekedness (8/2/2012)

---

Devesh_Srivastava (8/1/2012)

---

substring ("Archive_Full_20120731200002",1, (FINDSTRING( "Archive_Full_20120731200002","Full_", 1)-2))

Then how come the above expression is working where the exact string is used instead of a variable and still negative value is accepted!!!...

Can you post the full text of the error message?

Mister Ken (8/1/2012)

---

I'm working with a DataFlow Task and have the souce and destinations set.

The destination has Field1, Field2, Field3 and a last column called dtEndDate.

The source has Field1,...

It looks like a dynamic crosstab query might help. Have a look here[/url] for an example.

Works for me. I suspect that you may have got your variable syntax wrong. Here is my version:

Substring (@[User::TestString],1, (FINDSTRING(@[User::TestString] ,"Full_", 1)-2))

Please post the expression which you tried - the one which gives the error.

Not possible without access to the MS developers.

laurie-789651 (8/1/2012)

---

Having looked at the article, it looks like the 'AS' clause is in the wrong place. It should be like this, I think

SELECT a.DayCount,

...

mrichardson 57577 (7/31/2012)

---

this is working now.

used:

SELECT TOP 100 PERCENT

WebFormData_2.FieldValue AS Surname,

WebFormData_7.FieldValue AS SpecialReq

FROM db.R

JOIN db.WebFormData WebFormData_2

ON db.R.WebFormRowId = WebFormData_2.WebFormRowId

and WebFormData_2.WebFormFieldId =98

left JOIN db.WebFormData WebFormData_7

ON db.R.WebFormRowId = WebFormData_7.WebFormRowId

and WebFormData_7.WebFormFieldId...

Are you trying to boost your points by...

I'm afraid that what you are asking for is not clear enough for me to offer a solution.

Please see the link in my signature for details of how to post...

Mike John (7/31/2012)

---

In your original question you did say the records had to be INSERTED in to the new table, which is what my statement did.

Can you post full DDL...