Viewing 15 posts - 10,561 through 10,575 (of 13,879 total)
By 'simple', I presume you mean without going through the packages and editing the meta data manually? I'm afraid the answer is 'no'.
August 6, 2012 at 3:18 am
You are calling the function wrongly. Try this:
select dbo.t1('test')
August 4, 2012 at 6:54 am
You have to CREATE the function before you can ALTER it.
August 4, 2012 at 12:51 am
Wouldn't be the biggest shock to find that I am confused, but length is the last argument, and it is -2 to my eyes.
Just as a riposte to your fish-frying...
August 2, 2012 at 11:06 am
herladygeekedness (8/2/2012)
I created a simple expression using -2 as length and was unable to save the expression due to...
August 2, 2012 at 9:08 am
herladygeekedness (8/2/2012)
Devesh_Srivastava (8/1/2012)
Then how come the above expression is working where the exact string is used instead of a variable and still negative value is accepted!!!...
August 2, 2012 at 8:08 am
Can you post the full text of the error message?
August 2, 2012 at 7:19 am
Mister Ken (8/1/2012)
The destination has Field1, Field2, Field3 and a last column called dtEndDate.
The source has Field1,...
August 2, 2012 at 1:47 am
August 2, 2012 at 1:41 am
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))
August 2, 2012 at 12:58 am
Please post the expression which you tried - the one which gives the error.
August 1, 2012 at 8:12 am
Not possible without access to the MS developers.
August 1, 2012 at 5:13 am
laurie-789651 (8/1/2012)
SELECT a.DayCount,
...
August 1, 2012 at 4:01 am
mrichardson 57577 (7/31/2012)
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...
July 31, 2012 at 1:50 pm
Viewing 15 posts - 10,561 through 10,575 (of 13,879 total)