No announcements
Found 2413164 threads
-
2 VotesMulti-dimensional parameter in T-SQL
T-SQL supports table-valued parameters: http://www.sqlusa.com/bestpractices2008/table-valued-parameter/Kalman Toth Database & OLAP ...Answered | 3 Replies | 1188 Views | Created by silverskunkdoc - Friday, May 31, 2013 3:08 PM | Last reply by Kalman Toth - Wednesday, June 12, 2013 3:55 PM
-
0 Votes
dimensional Datadabse and relational database
That simply implies how it stores.Answered | 2 Replies | 5945 Views | Created by Shanu_Shri - Saturday, May 14, 2011 4:28 AM | Last reply by Vinuthan - Saturday, May 14, 2011 1:05 PM -
0 Votes
T SQL Equivalent Sub Query in dimensional DB
Hmmm, not too sure why you are doing nested sub-queries there but I would hazard a guess that the reason you only see one city is because the inner most sub-query ...Answered | 7 Replies | 6235 Views | Created by Ibrar-QAU-IslamAbad - Monday, July 19, 2010 9:43 AM | Last reply by Philip Stephenson - Tuesday, July 27, 2010 7:47 AM -
1 Votes
Relational Model to Dimensional Modeling
I would second the Kimball suggestion.Answered | 2 Replies | 1067 Views | Created by san463 - Wednesday, October 14, 2015 8:07 PM | Last reply by greggyb - Wednesday, October 14, 2015 9:12 PM -
0 Votes
multi-dimensional reporting tool suggestions
Hi kvd123, I suggest you using SQL Server Data Tools – Business Intelligence for Visual Studio(formerly known as Business Intelligence Development ...Answered | 3 Replies | 1892 Views | Created by kvd123 - Friday, January 30, 2015 8:56 PM | Last reply by Zaim Raza - Monday, February 2, 2015 8:28 AM -
0 Votes
Multi-database query
Then you can run a multi-database query as you like.Answered | 5 Replies | 1046 Views | Created by Israr Haq - Sunday, September 27, 2015 12:52 PM | Last reply by Dan Guzman - Monday, September 28, 2015 11:59 AM -
0 Votes
Multi Tenant on SQL database
I'd suggest taking a look at the elastic database capabilities for Azure SQL DB:Answered | 1 Replies | 1498 Views | Created by rtyuioo - Friday, February 19, 2016 3:48 AM | Last reply by Torsten Grabs (MSFT) - Saturday, February 20, 2016 10:14 PM -
0 Votes
Can i consume dimensional data from Sybase ?
you want to use ODBC connection for sybase source, Here "Choose A Data Source" dialogue, select ...Answered | 1 Replies | 1295 Views | Created by swapna499 - Saturday, May 2, 2015 4:03 PM | Last reply by AV111 - Sunday, May 3, 2015 10:04 AM -
0 Votes
Returning single-element multi-dimensional arrays
I think it's arguable whether $b = (,$a) produces a properly multi-dimensional array to return.Answered | 8 Replies | 23741 Views | Created by Spike15 - Friday, March 12, 2010 1:50 AM | Last reply by wtgreen - Friday, March 12, 2010 4:16 PM -
0 Votes
Related Items - SQL query
Hi Eugene, To start with - which database are you querying?Answered | 2 Replies | 1260 Views | Created by Eugie88 - Thursday, October 27, 2016 3:27 AM | Last reply by Eugie88 - Thursday, November 17, 2016 6:02 AM -
1 Votes
How to do this with T-SQL ?
I must only have one returned and I don't care which one.Answered | 6 Replies | 855 Views | Created by AllTheGoodNamesWereTaken - Monday, November 20, 2017 2:43 AM | Last reply by Naomi N - Thursday, November 23, 2017 2:45 AM -
0 Votes
Data modeling and dimensional modeling
I want a scenario based learning..Answered | 3 Replies | 6119 Views | Created by Eswararao C - Monday, March 22, 2010 2:15 PM | Last reply by Darren Gosbell - Wednesday, March 24, 2010 5:21 AM -
0 Votes
Re: How to converting from PL/SQL query to T-SQL query
It will convert whole Oracle databases, or single queries or PL/SQL stored procedures.Answered | 5 Replies | 12953 Views | Created by sreenivas.bijje - Monday, June 24, 2013 10:03 AM | Last reply by Dan.Akelson - Monday, June 2, 2014 7:06 AM -
0 Votes
Plotting Longitude and Latitude with Power View from a Multi-Dimensional Source
I thought SSAS couldn't handle binary data, or would you then convert Geography data type in the view?Answered | 9 Replies | 3408 Views | Created by BeardyMan - Tuesday, September 2, 2014 9:15 PM | Last reply by Jane Leung - Monday, June 20, 2016 6:28 PM -
0 Votes
How do you set an SQL 2008 Database to Multi user in the SQL 2008 console
Or, just run the following in a new query window: ALTER DATABASE dbname SET SINGLE_USER WITH ROLLBACK IMMEDIATE GO :-) Beyond ...Answered | 2 Replies | 8649 Views | Created by jet card - Thursday, August 20, 2009 5:08 PM | Last reply by Jacob Sebastian - Friday, August 21, 2009 5:54 AM -
0 Votes
T-SQL Query Problem
I'm basically trying to run this stored procedure provided by RedGate SQL Backup, which restores a database from backup.Answered | 5 Replies | 3613 Views | Created by philjfry - Sunday, June 3, 2012 11:13 PM | Last reply by Psalm3_3 - Tuesday, June 5, 2012 10:12 PM -
0 Votes
Single T-SQL query to suspend data movement on all alwayson databases
Hi There, To generate the suspend script run the below query.Answered | 3 Replies | 2535 Views | Created by Aadhira - Thursday, February 11, 2016 4:04 PM | Last reply by Kumar muppa - Friday, February 12, 2016 3:37 AM -
0 Votes
How can I do cross Database queries in Azure SQL??
Hi Ritesh, You can use Elastic Query to query data from one db to another.Answered | 1 Replies | 1063 Views | Created by Ritesh Verma Intellisoft - Monday, February 29, 2016 1:03 PM | Last reply by Silvia Doomra [MSFT] - Monday, February 29, 2016 4:08 PM -
0 Votes
T-SQL Query
Please post DDL, so that people do not have to guess what the keys, constraints, Declarative Referential Integrity, data types, etc. in your schema are.Answered | 9 Replies | 4451 Views | Created by lata456 - Tuesday, January 11, 2011 9:00 PM | Last reply by NSMP - Tuesday, January 11, 2011 11:05 PM -
0 Votes
Understanding the T SQL Queries
Great article http://rusanu.com/2013/08/01/understanding-how-sql-server-executes-a-query/ Best Regards,Uri Dimant SQL Server ...Answered | 1 Replies | 775 Views | Created by Hemadribabu - Monday, May 2, 2016 5:27 AM | Last reply by Uri Dimant - Monday, May 2, 2016 5:46 AM - Items 1 to 20 of 2413164 Next ›
No announcements
