No announcements
Found 1849550 threads
-
4 VotesDynamic set query
Forecast” set, with both [Fiscal Year] and [Scenario Name] members: PivotTable Named Sets in Excel 2010 - DeepakAnswered | 7 Replies | 5594 Views | Created by rok1 - Thursday, August 5, 2010 3:58 PM | Last reply by Deepak Puri - Friday, August 6, 2010 5:25 PM
-
0 Votes
problem setting variable dynamically and executing dynamic query
[HEAD_ID] WHERE FPA_CYCLE_ID='+@FPA_CYCLE_ID EXEC (@STRING_Employee_FPA_distribution_QUERY) ..i mean would this be the correct way to write dynamic ...Answered | 11 Replies | 4540 Views | Created by Sandeep.Handa - Sunday, November 21, 2010 8:22 AM | Last reply by Naomi N - Monday, November 22, 2010 2:04 PM -
3 Votes
Openrow set and dynamic query
I was just trying to answer on how to form dynamic SQL .Answered | 6 Replies | 8809 Views | Created by Vaishu - Saturday, January 4, 2014 4:55 AM | Last reply by Erland Sommarskog - Saturday, January 4, 2014 11:47 AM -
2 Votes
Dynamic Query
Hi there, declare a variable like varchar. build the query as a string based on your conditions.Answered | 2 Replies | 1917 Views | Created by Biru395 - Thursday, February 28, 2013 10:26 AM | Last reply by Kumar muppa - Friday, March 1, 2013 12:55 AM -
0 Votes
Dynamic queries?
Hi Ivan; Entity Framework does support dynamic query natively with the use of Entity Framework ESql, Entity SQL, the information can be found ...Answered | 5 Replies | 2116 Views | Created by Cryo75 - Saturday, May 12, 2012 3:45 PM | Last reply by Fernando Soto - MCSD - Sunday, May 13, 2012 7:21 PM -
1 Votes
SSIS package - dynamic query, how to set database name dynamic ?
Using Execute SQL Task to get the database names in a object variable, use this SQL: SELECT TableName = ...Answered | 5 Replies | 1948 Views | Created by JaguarsJag - Friday, February 12, 2016 4:38 PM | Last reply by Sary Awwad - Friday, February 12, 2016 7:53 PM -
0 Votes
help with dynamic query for openrow set
I did a query against table checking pdf field if not Null.Answered | 17 Replies | 1138 Views | Created by hart60 - Saturday, February 9, 2019 2:17 PM | Last reply by hart60 - Thursday, February 14, 2019 1:25 PM -
0 Votes
Dynamic Query
Hello Adurs, Before you use this, you need to create a variable in SSIS , tye datatime let say you have the variable MyData type datetime in SSIS You will write ...Answered | 4 Replies | 4120 Views | Created by adurs - Tuesday, February 23, 2010 4:21 PM | Last reply by José.Cruz - Tuesday, February 23, 2010 11:52 PM -
6 Votes
dynamic query
sorry I forgot to mention that during my query I am going to call @city more than one time.Answered | 8 Replies | 1387 Views | Created by azolfaghari - Thursday, January 23, 2014 9:58 AM | Last reply by azolfaghari - Thursday, January 23, 2014 12:22 PM -
0 Votes
Dynamic query in T SQL
Try declare @BOE varchar(50) SELECT top (1) @BOE = BOE from OT_Inbound_Shipment_Info print @BOE SELECT @BOE ...Answered | 5 Replies | 3415 Views | Created by Ajay Singh Rawat - Monday, September 19, 2011 7:25 AM | Last reply by Naomi N - Monday, September 19, 2011 2:00 PM -
6 Votes
dynamic query
Then after you get the max number, manually add more columns behind @cols in dynamic query: set @query = N'SELECT pid, vid, ...Answered | 9 Replies | 900 Views | Created by Neilcse - Monday, August 20, 2018 1:14 AM | Last reply by Visakh16 - Monday, August 20, 2018 9:00 AM -
0 Votes
Add a subquery to a dynamic query
I think this could be refactored to not use dynamic SQL.Answered | 9 Replies | 5095 Views | Created by Hugh Self Taught - Sunday, April 21, 2019 9:12 PM | Last reply by Rachel_Wang - Tuesday, April 23, 2019 7:21 AM -
0 Votes
To read the dynamic query.
I used BEGIN PRINT (@Query) END to read the dynamic ...Answered | 2 Replies | 8691 Views | Created by engloon - Thursday, July 1, 2010 2:58 AM | Last reply by engloon - Sunday, July 25, 2010 6:06 PM -
0 Votes
How to write these queries dynamically ?
If you have a DataTable and not just an IEnumerable<DataRow>, you can use DataTable.Select(string filterExpression), otherwise you may be able to use the LINQ Dynamic ...Answered | 1 Replies | 4507 Views | Created by fndoomed - Thursday, August 5, 2010 2:22 PM | Last reply by Fabrice MARGUERIE - Monday, August 9, 2010 1:55 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 | 6909 Views | Created by William_616 - Wednesday, November 10, 2010 10:49 PM | Last reply by KristoferA - Friday, November 12, 2010 2:24 AM -
1 Votes
Dynamic Query and formulating an IN clause
Same query without COALESCE.Answered | 5 Replies | 707 Views | Created by ITBobbyP - Thursday, May 7, 2015 6:35 PM | Last reply by davidbaxterbrowne - Thursday, May 7, 2015 8:29 PM -
0 Votes
Dynamic SQL query
As an aside, I think this means I cannot parameterise dynamic queries that generate temporary objects to be used further in their scope.....Answered | 7 Replies | 576 Views | Created by MohanSQL - Thursday, December 7, 2017 5:45 AM | Last reply by MohanSQL - Friday, December 8, 2017 3:23 AM -
0 Votes
Dynamic Linq Query?
Hi, This should help you.Answered | 2 Replies | 3373 Views | Created by Sivakanth trichy - Tuesday, November 29, 2011 5:30 AM | Last reply by Sheldon _Xiao - Wednesday, November 30, 2011 6:26 AM -
0 Votes
set seed in identity dynamically
arkiboys, I dont really get the requirement of addition of columns DYNAMICALLY to a given table.Answered | 3 Replies | 1621 Views | Created by arkiboys - Thursday, March 27, 2014 9:50 AM | Last reply by Erland Sommarskog - Thursday, March 27, 2014 11:34 AM -
4 Votes
URGENT : Dynamic Set
In Analysis Services, when creating a named set, if you set HIDDEN, the set can't be either visible or not to other users who query the cube.Answered | 7 Replies | 1322 Views | Created by Nimish Rao - Wednesday, April 15, 2015 4:02 PM | Last reply by Nimish Rao - Monday, May 11, 2015 5:20 AM - Items 1 to 20 of 1849550 Next ›
No announcements
