No announcements
Found 2383634 threads
-
1 VotesDynamic Columns based on the Data Set
The store procedure returns 5 columns next month it will return 10 columns .Answered | 2 Replies | 880 Views | Created by Priya Bange - Wednesday, April 30, 2014 3:16 PM | Last reply by Murali dhar - Wednesday, April 30, 2014 3:28 PM
-
1 Votes
No Column information was returned by the SQL command.
Hi Harry, Try adding below command before your code block - ...Answered | 8 Replies | 12787 Views | Created by Mimosa Arts - Friday, November 13, 2015 5:49 PM | Last reply by Roul174 - Wednesday, February 12, 2020 3:22 PM -
0 Votes
No column information was returned by the SQL command while accessing the data from a cube.
For some of the Queries depending upon the data entry there might be data available or not.Answered | 3 Replies | 1275 Views | Created by Vin Sho - Thursday, June 9, 2016 3:03 PM | Last reply by ArthurZ - Thursday, June 9, 2016 7:27 PM -
0 Votes
Dynamic columns with cube data
Get your measures on Columns and Dates on Rows in the above query and then in your matrix add date/month to the column and add a column grouping on it and add measures on ...Answered | 1 Replies | 1985 Views | Created by dbwrangler - Thursday, September 6, 2012 4:04 PM | Last reply by Dattatrey Sindol (Datta) - Friday, September 7, 2012 7:18 AM -
0 Votes
SSRS - Very dynamic columns
Hi Mark, From your description, you want to retrieve the table information which rows that failed the cleaning process, right?Answered | 2 Replies | 3760 Views | Created by Mark B Roworth - Wednesday, March 13, 2013 6:06 PM | Last reply by Mark B Roworth - Saturday, March 23, 2013 12:17 PM -
1 Votes
Binding to data source with dynamically created columns in DataGrid
Your more informed comments on this approach will be very welcome.Answered | 5 Replies | 6479 Views | Created by Sebastian Crewe - Friday, December 6, 2013 4:06 PM | Last reply by Terrence-Jones - Wednesday, December 11, 2013 5:01 AM -
4 Votes
Error at Data Flow Task: No column information was returned by the SQL Command
If there is data in all the tables, then your statement SHOULD return data.Answered | 9 Replies | 10517 Views | Created by ironryan77 - Tuesday, August 7, 2012 3:50 PM | Last reply by ironryan77 - Wednesday, August 8, 2012 2:16 PM -
0 Votes
Dynamic Column
Not sure if I fully understand your question but I think you're describing dynamic datasets?Answered | 3 Replies | 1298 Views | Created by vamsi1980 - Wednesday, June 12, 2013 8:22 AM | Last reply by SathyanarrayananS - Wednesday, June 12, 2013 11:15 AM -
0 Votes
Inserting data in dynamically-created columns
Hi WindowsRich, To know more about Dynamic Column mapping in SSIS, read this ...Answered | 2 Replies | 4788 Views | Created by WindowsRich - Friday, June 17, 2011 9:25 PM | Last reply by Arunraj.C - Sunday, June 19, 2011 11:18 AM -
0 Votes
Dynamically change source columns
If you can use third-party solutions, check the commercial CozyRoc Data Flow Task Plus.Answered | 3 Replies | 2217 Views | Created by Debaser19 - Monday, February 13, 2012 10:32 PM | Last reply by COZYROC - Wednesday, February 15, 2012 3:40 AM -
0 Votes
Compare data and return the different columns
Good Afternoon, I am trying to compare the data in two tables and return only the columns and data where there is a difference.Answered | 1 Replies | 903 Views | Created by Steveajones45 - Friday, January 3, 2014 12:02 PM | Last reply by Visakh16 - Friday, January 3, 2014 12:56 PM -
2 Votes
Dynamically hide columns on missing dataset column
the data for this report is returned from a pivot table so I don't know which columns of data will be returned.Answered | 5 Replies | 3129 Views | Created by moondaddy - Friday, August 16, 2013 4:56 AM | Last reply by Charlie Liao - Monday, August 19, 2013 3:02 AM -
0 Votes
Dynamic column names
And correct me if i am wrong, the numbers of fields must be the same if you are using a DFT that has a table Destination?Answered | 7 Replies | 3741 Views | Created by Jamal112 - Thursday, January 14, 2010 4:08 PM | Last reply by Nik - Shahriar Nikkhah - Thursday, January 14, 2010 5:53 PM -
0 Votes
how to combine multiple stored procedure which return dynamic columns
Already when you have dynamic columns you are bending the rules, but as I say, if it is the last thing you do before you return data to the ...Answered | 7 Replies | 2682 Views | Created by swat3003 - Thursday, December 20, 2012 6:42 AM | Last reply by Erland Sommarskog - Thursday, December 20, 2012 1:09 PM -
0 Votes
SP return vale not correct
reVal = cmd.ExecuteScalar() Although ExecuteNonQuery returns no rows, any output parameters or return values mapped to parameters are ...Answered | 3 Replies | 4423 Views | Created by IP Arun - Tuesday, September 6, 2011 1:29 PM | Last reply by Naomi N - Tuesday, September 6, 2011 11:29 PM -
0 Votes
Processing dynamic query returns
I've tried using ToList() from the query returned when using the dynamic library Scott Gu wrote.Answered | 3 Replies | 6741 Views | Created by William_616 - Wednesday, November 10, 2010 10:49 PM | Last reply by KristoferA - Friday, November 12, 2010 2:24 AM -
0 Votes
ssrs dynamic columns
Hi siera, In case you returning the dynamic list of column, you have to decide pre hand what is the max column you are gning to return ...Answered | 2 Replies | 6720 Views | Created by siera_gld - Wednesday, May 1, 2013 6:41 AM | Last reply by SathyanarrayananS - Wednesday, May 1, 2013 8:12 AM -
0 Votes
Returning Rows as Columns
--I created that dummy column to link the three different years data together.Answered | 10 Replies | 2616 Views | Created by kris0 - Tuesday, July 26, 2011 9:10 PM | Last reply by Arbi Baghdanian - Wednesday, July 27, 2011 8:52 PM -
0 Votes
SqlDataReader Index Out Of Range Exception when correct column count is returned
If you use 'SELECT @UserIDChar', Then it will return two Datatables.Answered | 9 Replies | 9049 Views | Created by Pingpong689 - Tuesday, August 2, 2016 11:45 PM | Last reply by Zhanglong Wu - Monday, August 8, 2016 9:11 AM -
0 Votes
Dynamic DB, Tables and Columns
The @FINALSQL string concatenation gave me weird results where sometimes only the last column would be returned in the Table DDL.Answered | 12 Replies | 1331 Views | Created by ProgrammerMatt - Friday, October 7, 2016 9:36 PM | Last reply by ProgrammerMatt - Monday, October 10, 2016 11:16 PM - Items 1 to 20 of 2383634 Next ›
No announcements
