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...

shahsn11 (7/31/2012)

---

I want that the record in another table i.e in our case emp2 should be overwritten. In my case there can be some records in emp2 which would already...

Following on from Jeff's comment - if you remove the GROUP BY, you should be able to check whether more rows are being returned than you expect/want.