No announcements
Found 2574576 threads
-
0 VotesOptimizing 2 queries into 1 query
Try this: Select ColA , SUM(CASE WHEN ColP IN (6,7,10) THEN 1 ELSE 0 END) AS Cnt_B , SUM(CASE WHEN ColP IN (4,5,9) THEN 1 ELSE 0 ...Answered | 5 Replies | 4611 Views | Created by kesar_k - Friday, February 4, 2011 6:53 PM | Last reply by Gert-Jan Strik - Friday, February 4, 2011 10:43 PM
-
0 Votes
Query against 2 different databases
Hi There, Database views have limitations. unfortunately Count(*) is one.Answered | 6 Replies | 602 Views | Created by ahpitre - Tuesday, November 22, 2016 10:47 PM | Last reply by Albert_ Zhang - Thursday, November 24, 2016 10:04 AM -
0 Votes
1 query, 2 counts
I want to, in one query, see all of the clients, how many purchases each one made last week, and how many purchases each one made the week before.Answered | 3 Replies | 2671 Views | Created by jlimdso - Monday, June 25, 2012 10:11 PM | Last reply by kumara11 - Tuesday, June 26, 2012 7:38 AM -
0 Votes
2 Log files for 1 database
Hi, I would like to add further here that , considering your scenario when log file( File 1) on fast disk gets full and you have extra log file( file 2) ...Answered | 3 Replies | 1208 Views | Created by Andrea Caldarone - Monday, June 23, 2014 8:45 AM | Last reply by Shanky_621 - Monday, June 23, 2014 9:30 AM -
3 Votes
Linking 2 database in 1
It is in SQL transact and in Linq, however as you ask it for a database, you better can ask this in a SQL Server forum.Answered | 3 Replies | 2630 Views | Created by Can anyone help - Wednesday, August 12, 2009 4:17 AM | Last reply by Vishal Mohan - Wednesday, August 12, 2009 5:01 AM -
0 Votes
2 seperates queries in 1...
I've tried some things and this seems to work: > > var currentUserId = ...Answered | 3 Replies | 2951 Views | Created by bPlatypus - Sunday, June 12, 2011 12:39 PM | Last reply by Larcolais Gong - Wednesday, June 15, 2011 8:06 AM -
0 Votes
BOTH (1) AND (2) Query Returns same result
suppose, u have 10 queries in your proc, after each select, Engine will ask the messaging component(I am not sure what is it..) to print the message.Answered | 6 Replies | 4754 Views | Created by luckyforu2006 - Tuesday, October 26, 2010 7:03 AM | Last reply by Naomi N - Tuesday, October 26, 2010 2:11 PM -
1 Votes
Query 2 different databases and tables
I have two databases and I want to do a join between 2 tables, 1 in each database.Answered | 2 Replies | 2852 Views | Created by spark29er - Wednesday, October 12, 2011 5:49 PM | Last reply by SimpleSQL - Wednesday, October 12, 2011 6:05 PM -
0 Votes
MDX query - 2 hierarchy levels on 1 axis
Try using the DESCENDANTS function to return the 2 levels in the hierarchy DESCENDANTS([Product].Answered | 7 Replies | 8202 Views | Created by Nelson Jones - Thursday, February 21, 2013 9:24 AM | Last reply by Dhir_Mehta - Wednesday, July 19, 2017 11:17 AM -
0 Votes
Sql Query into VB.Net within 2 databases
I need to connect to 2 différent databases not in the same folder.Answered | 4 Replies | 436 Views | Created by Martin P - Thursday, June 19, 2014 9:23 PM | Last reply by Joel Engineer - Friday, June 20, 2014 12:39 PM -
0 Votes
How to insert / update table from database 1 to database 2 ??
Thanks to all who response for my queries.Answered | 5 Replies | 1041 Views | Created by Jafferpg - Monday, October 26, 2015 7:59 AM | Last reply by Jafferpg - Wednesday, October 28, 2015 11:50 AM -
2 Votes
Is it faster to write to 2 databases instead of 1?
The purpose of my question is, it doesn't matter if it's 1000 rows or 1 million rows, I was wondering if it makes any difference to the SQL engine if I saved 1million rows into 1 ...Answered | 5 Replies | 3598 Views | Created by Louis Leong - Tuesday, August 7, 2012 4:42 PM | Last reply by Papy Normand - Wednesday, August 8, 2012 8:22 PM -
0 Votes
how to use 2 servers to provide 1 domain and 1 database?
1) DNS and Active Directory can be installed on both servers.Answered | 1 Replies | 5602 Views | Created by Kotresh Kumar - Friday, June 8, 2012 5:59 PM | Last reply by PrinceLucifer - Friday, June 8, 2012 8:58 PM -
1 Votes
Querying Database
Yeah you are right, more call to the database would affect the performance.Answered | 2 Replies | 2564 Views | Created by obrienkev - Tuesday, February 7, 2012 5:29 PM | Last reply by Mike Dos Zhang - Thursday, February 9, 2012 1:36 AM -
2 Votes
INSERT Query using 2 databases
In addition to it, if Station_ECID is an identity column in db.tbl_Stations table in Production database, then try - Use Production Go INSERT ...Answered | 4 Replies | 1368 Views | Created by ChemEng - Monday, December 3, 2012 5:57 PM | Last reply by Ahsan Kabir - Monday, December 3, 2012 6:18 PM -
0 Votes
Executing the SQL query across 2 different databases
---If both the datbases are in the same server select * from DatabaseName.Answered | 2 Replies | 4313 Views | Created by paragkalra - Monday, January 25, 2010 7:23 AM | Last reply by Ramesh.M - Monday, January 25, 2010 7:28 AM -
0 Votes
Inserting data from a table in database 1 to an identical table in database 2...both databases are on the same server
If you are in database a and need to insert into database b for a table called mytable, you would write something like INSERT INTO b.dbo.MyTable(col1, col2, ...Answered | 6 Replies | 1913 Views | Created by ChemEng - Friday, January 18, 2013 9:51 PM | Last reply by Naarasimha - Friday, January 18, 2013 10:35 PM -
0 Votes
database importing 1/1/1900
In case if that option is not possible you always have a choice to use Power Query.Answered | 1 Replies | 683 Views | Created by AlexMartini - Monday, December 12, 2016 8:31 PM | Last reply by Nick Chobotar - Monday, December 12, 2016 10:00 PM -
0 Votes
2 Tables on 1 DataGridRow
If you ask LS to query from [MovieTitles] it will have no problem identifying the movie associated with each record because MovieTitle.MovieId = Movies.MovieID.Answered | 3 Replies | 2756 Views | Created by Clay Ver Valen - Friday, December 3, 2010 4:46 AM | Last reply by Wessel Swanepoel - Sunday, December 5, 2010 9:35 PM -
1 Votes
Join 2 Results into 1 ?
Hi there, simply left join your second query with first query you get your required output. check the joining conditions...Answered | 2 Replies | 2450 Views | Created by Narsa - Thursday, December 27, 2012 7:52 AM | Last reply by Kumar muppa - Friday, December 28, 2012 2:25 AM - Items 1 to 20 of 2574576 Next ›
No announcements
