• Register

Recent questions tagged sql

0 votes
1 answer 1 view
problem: how i solve this errors of sql select distinct values and count of each .
asked 4 hours ago ashik 12.9k points
0 votes
1 answer 1 view
Problem: Why am I seeing "you do not have permission to use the bulk load statement" in SQL Server?
asked 16 hours ago anika11 5.1k points
0 votes
0 answers 1 view
Problem: Could you please give me a method for this ssql query with multiple values in a single field?
asked 19 hours ago jamuna1 18.1k points
0 votes
1 answer 1 view
Problem: Magento: Paypal is taking shipping address as default instead of billing address.How I can pass billing as default instead of shipping?
asked 1 day ago sumaiya simi 16.3k points
0 votes
1 answer 2 views
Question: I know that multiple inheritances between Interfaces is possible, e.g.: public interface C extends A,B {...} //Where A, B and C are Interfaces But is it possible to have a regular Class inherit from multiple Interfaces like this: public class A implements C,D {...} //Where A is a Class and C and D are interfaces
asked 1 day ago munim01 12.9k points
0 votes
0 answers 1 view
Problem: How to check if a table exists in SQL Server 2000/2005 using SQL Statements?
asked 1 day ago zayed1 35.6k points
0 votes
1 answer 1 view
Problem: How to find the solution of sql unknown column in field list?
asked 1 day ago ashik 12.9k points
0 votes
1 answer 1 view
Question: I have the following issue in SQL Server, I have some code that looks like this: DROP TABLE #TMPGUARDIAN CREATE TABLE #TMPGUARDIAN( LAST_NAME NVARCHAR(30), FRST_NAME NVARCHAR(30)) SELECT LAST_NAME,FRST_NAME INTO #TMPGUARDIAN FROM TBL_PEOPLE When I do this I get an error 'There is already an object named '#TMPGUARDIAN' in the database'. Can anyone tell me why I am getting this error?
asked 1 day ago munim01 12.9k points
0 votes
1 answer 2 views
Question: I have the following issue in SQL Server, I have some code that looks like this: DROP TABLE #TMPGUARDIAN CREATE TABLE #TMPGUARDIAN( LAST_NAME NVARCHAR(30), FRST_NAME NVARCHAR(30)) SELECT LAST_NAME,FRST_NAME INTO #TMPGUARDIAN FROM TBL_PEOPLE When I do this I get an error 'There is already an object named '#TMPGUARDIAN' in the database'. Can anyone tell me why I am getting this error?
asked 1 day ago munim01 12.9k points
0 votes
2 answers 1 view
Problem: How to solve the following issue>how to connect sql database in c# step by step
asked 1 day ago ashik 12.9k points
0 votes
1 answer 1 view
Problem: I need to create a query that returns only the rows which have the minimum values in a specific column.Someone please help me to fix this problem,"SQL | Return MIN values | multiple rows dynamically".
asked 1 day ago Supti 1.7k points
0 votes
1 answer 1 view
Question: How can I solve the error in the following procedure? CREATE PROCEDURE cards @salesman VARCHAR(10), @RCV10 INT, @RCV09 INT, @RCV15 INT, @GPRS15 INT, @RCV20 INT, @RCV25FTT INT, @RCV25 INT, @RCV31 INT, @RCV30 INT, @RCV35 INT, @RCV50 INT, @RCV55 INT, @SIM ... /2013' gives the following error: Msg 8114, Level 16, State 5, Procedure cards, Line 0 Error converting data type varchar to datetime
asked 2 days ago Atik03 10.1k points
0 votes
1 answer 1 view
Question: I'm trying to install a gem using gem install mygem or update RubyGems using gem update --system, and it fails with this error: ERROR: While executing gem ... (Gem::FilePermissionError) You don't have write permissions for the /Library/Ruby/Gems/2.0.0 directory. Does anyone have an idea how to solve this?
asked 2 days ago Atik03 10.1k points
0 votes
1 answer 1 view
Question: I keep getting MySQL error 1054, when trying to perform this update query: UPDATE MASTER_USER_PROFILE, TRAN_USER_BRANCH SET MASTER_USER_PROFILE.fellow=`y` WHERE MASTER_USER_PROFILE.USER_ID = TRAN_USER_BRANCH.USER_ID AND TRAN_USER_BRANCH.BRANCH_ID = 17 It's probably some syntax ... instead and other alterations, but I keep getting the same message: Unknown column 'y' in 'field list'
asked 2 days ago Atik03 10.1k points
0 votes
1 answer 2 views
Problem: Need to see that how to extract apk file in android studio?
asked 2 days ago jamuna1 18.1k points
0 votes
1 answer 1 view
Problem: How can I group only by month from a date field (and not group by day)? Here is what my date field looks like: 2012-05-01 Here is my current SQL: select Closing_Date, Category, COUNT(Status)TotalCount from MyTable where Closing_Date >= '2012-02-01' and Closing_Date <= '2012-12-31' and Defect_Status1 is not null group by Closing_Date, Category
asked 2 days ago Atik03 10.1k points
0 votes
1 answer 2 views
Question: How would i write this sql statement without a hard coded value? resultSet = statement .executeQuery("select * from myDatabase.myTable where name = 'john'"); // this works rather have something like: String name = "john"; resultSet = statement . ... ); // Unknown column 'john' in 'where clause' at // sun.reflect.NativeConstructorAccessorImpl.newInstance0...etc... Thanks in advance.
asked 2 days ago Atik03 10.1k points
0 votes
1 answer 2 views
Problem: Please solve me the question how to use group by in r?
asked 2 days ago padma1 22.4k points
0 votes
1 answer 2 views
Problem: How can I execute the sp_change_users_login so that it will auto-fix all local sql accounts?
asked 2 days ago sumaiya simi 16.3k points
0 votes
1 answer 1 view
Question: I have two tables, Table1 and Table2. I want to select distinct rows in Table2 that are not contained in Table1. Here is an example: Table1 | A | | sem| ------------------ 1. | aa | | 1 | --------------- 2. | bb | | 1 | ---------------- 3. | aa ... | ee | ------ I would want the those row who is not common in this two table when sem = 1 like output for sem = 1 result | B | | cc | | ee |
asked 2 days ago Atik03 10.1k points