Recent questions tagged sql

0 votes

1 answer 1 view

sql select distinct values and count of each

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

You do not have permission to use the bulk load statement.

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

Sql query for multiple values in single field.

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

How to change billing address on paypal?

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

Can a normal Class implement multiple interfaces?

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

Check if table exists in sql server.

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

sql unknown column in field list

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

Temporary table causing ' There is already an object named' error

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

Temporary table in SQL server causing ' There is already an object named' error

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

how to connect sql database in c# step by step

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

Sql select min value from multiple rows.

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

Error converting data type varchar to datetime

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

How to install a gem or update RubyGems if it fails with a permissions error?

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

Error: Unknown column in 'field list' error on MySQL Update query.

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

How to extract apk file in android studio?

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

How to group by month from Date field using sql?

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

SQL select statement with where clause

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

How to use group by in r?

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

Sp_change_users_login auto_fix

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

Select rows with no match between two tables by sem

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

Log In

Register

Recent Posts

Recent questions tagged sql