No announcements
Found 2637372 threads
-
6 VotesGet the value of a column in the parent proc
[ChildProc] ( @Input VARCHAR(11) ) AS BEGIN SELECT Col1, Col2....., Col50 FROM MyTable WHERE myVal = ...Answered | 11 Replies | 2480 Views | Created by Ram Dhilip - Wednesday, June 20, 2012 3:45 PM | Last reply by Ram Dhilip - Thursday, June 21, 2012 1:30 PM
-
0 Votes
How to update parent table identity column values in child table
We have identity column in parent table and we are using this column values in child table. We found an issue that ...Answered | 6 Replies | 3298 Views | Created by Das Bavan - Wednesday, March 4, 2020 9:18 AM | Last reply by Erland Sommarskog - Wednesday, March 4, 2020 10:40 PM -
0 Votes
Proc params with defualt values
I think you code looks fine, if you call usp 'herProc' from usp 'MyProc' and only provide 3 parameters while 'herProc' is expecting 4 param values but it will fill the ...Answered | 4 Replies | 2418 Views | Created by WIJ - Tuesday, November 1, 2011 9:25 PM | Last reply by Arbi Baghdanian - Wednesday, November 2, 2011 4:17 PM -
0 Votes
How to get the Parent column on a query in TFS online
Hello guys,I am creating a report (query) and I need to add the parent column or a column where I can get he title of the Parent.Answered | 2 Replies | 2241 Views | Created by Robert Dr - Friday, July 31, 2015 9:29 AM | Last reply by Jessica Xia - Monday, August 3, 2015 2:30 AM -
0 Votes
Non-column Stored Proc insert parameter
When the call for ExecuteMethodCall is hit, I get an exception that it cannot evalute a security function.Answered | 3 Replies | 3491 Views | Created by upfrontcs - Friday, April 23, 2010 6:36 PM | Last reply by liurong luo - Thursday, April 29, 2010 8:40 AM -
1 Votes
Get the Parent List of a child list's lookup column in code
Hello, Here is the C# code for getting the Parent List of a Look Up column using (SPSite site = new ...Answered | 5 Replies | 8662 Views | Created by Muzammil Mohammed - Tuesday, February 14, 2012 10:32 PM | Last reply by Ram Prasad Meenavalli - Wednesday, February 15, 2012 5:37 AM -
0 Votes
getting a return value from a stored proc
You need to assign a value to @GroupNames in your dynamic sql in order populate it with a value.Answered | 2 Replies | 697 Views | Created by robMerritt - Tuesday, September 13, 2016 10:28 PM | Last reply by robMerritt - Wednesday, September 14, 2016 2:12 PM -
5 Votes
Get list values by passing one column value to get the another column
SPWeb web = SPContext.Current.Web; SPList list = web.Lists["List Name"]; SPQuery query = new SPQuery(); query.Query = ...Answered | 3 Replies | 4168 Views | Created by Praveenrangu - Wednesday, January 25, 2012 4:40 AM | Last reply by krishna kumar123...KK - Wednesday, January 25, 2012 5:17 AM -
2 Votes
Trace value in stored proc
If the event was RPC:Completed, it was a call from the application, and thus the value 12345 was sent from the application.Answered | 2 Replies | 659 Views | Created by WLI863 - Saturday, November 12, 2016 5:16 PM | Last reply by Erland Sommarskog - Sunday, November 13, 2016 12:18 PM -
0 Votes
Execute Store proc for the given values
> I have a very generic store proc that is currently getting executed for single value at a time.Answered | 5 Replies | 782 Views | Created by Priya Bange - Sunday, February 7, 2016 9:45 AM | Last reply by Erland Sommarskog - Monday, February 8, 2016 11:19 AM -
0 Votes
Parent column group border
Note that the number of columns produced by the Heading column group can vary.Answered | 4 Replies | 648 Views | Created by Charles__Toray - Tuesday, August 18, 2015 3:42 PM | Last reply by Charles__Toray - Tuesday, August 25, 2015 12:04 PM -
0 Votes
Get value of Stored Proc in query
However, it seems that he wants to use the only value returned by the SP.Answered | 4 Replies | 2086 Views | Created by Pure Deal - Friday, July 20, 2012 10:32 AM | Last reply by Murali_CHN - Friday, July 20, 2012 11:06 AM -
0 Votes
How to pass paramters values in a store proc from values stored in the table
IF i schedule the store proc .Answered | 4 Replies | 858 Views | Created by Priya Bange - Tuesday, August 19, 2014 7:30 AM | Last reply by Priya Bange - Wednesday, August 20, 2014 1:32 PM -
0 Votes
Retrieve value from stored proc
Does anybody know whether it is possible to get values from a stored procedure?Answered | 2 Replies | 4344 Views | Created by linkit - Thursday, March 15, 2012 2:19 PM | Last reply by linkit - Monday, March 19, 2012 12:39 PM -
1 Votes
Get max value of column
The first column of tables is an id, which I have to increase each time I insert a new record.Answered | 2 Replies | 10561 Views | Created by ChronisK - Wednesday, December 9, 2009 5:07 PM | Last reply by COZYROC - Wednesday, December 9, 2009 5:19 PM -
0 Votes
Parent header for column group header
I got the solution though, I created a static parent group on the column group (date column in this case) and this worked.Answered | 2 Replies | 1615 Views | Created by Mohitgarg79 - Friday, June 28, 2013 10:24 AM | Last reply by Mohitgarg79 - Monday, July 1, 2013 11:06 AM -
0 Votes
Getting result from a Stored Proc in C#
To capture the return value in C# use this ...Answered | 6 Replies | 2406 Views | Created by Venktech - Wednesday, November 27, 2013 6:47 AM | Last reply by Venktech - Wednesday, November 27, 2013 10:21 AM -
0 Votes
A same chiled column refering to multiple parent column
CREATE TABLE Parent(val1 int NOT NULL, val2 int NOT NULL, val3 int NOT NULL, val4 int NOT NULL, PRIMARY KEY (val1), UNIQUE (val2), UNIQUE(val3), ...Answered | 3 Replies | 976 Views | Created by vikas kumar pathak - Thursday, December 24, 2015 6:49 AM | Last reply by Uri Dimant - Thursday, December 24, 2015 9:22 AM -
0 Votes
Dataset needs parent lookup to ensure parent child value dont match
So in ChildParent table we have a id whose value is 1 and is tied to child whose value is 20 and parent whose ...Answered | 8 Replies | 822 Views | Created by MLTC - Monday, January 18, 2016 7:50 PM | Last reply by HoroChan - Wednesday, January 20, 2016 8:42 AM -
0 Votes
Feature value in Backlog column
The only option I can see in Column Options > Available Columns is Related Link Count and it's not the count I'm looking for it's the value.Answered | 1 Replies | 374 Views | Created by JHHD - Wednesday, December 2, 2015 5:26 PM | Last reply by May Wang - MSFT - Thursday, December 3, 2015 8:09 AM - Items 1 to 20 of 2637372 Next ›
No announcements
