Tagged Questions
0
votes
0answers
8 views
I can't create Link Server to MySQL in SQL Server
I am trying to access data stored on MySQL from SQL Server.
I have followed the instructions on this site
http://www.sqlservercentral.com/Forums/Topic340912-146-1.aspx
I created the linked server ...
3
votes
6answers
50 views
SQL Query Across Multiple Joined Tables
I've got three tables: Resource, Timesheet, TimePeriod. A Resource has many Timesheets and a Timesheet has one TimePeriod. This used for us to keep track of employee timesheets. I'm trying to figure ...
0
votes
3answers
23 views
Mysql how is ISNUMERIC() available?
In MSSQL i am using query like below, and it will make different queries depending what i have in $search: text or numbers.
$query="
IF (isnumeric('$search')=0)
SELECT ...
1
vote
0answers
13 views
MYSQL Data Source could not be found in my Add Connection from Server Explorer and Entity Data Model Wizard, asp.net
I already downloaded MySQL Connector/Net and reference the assembly MySql.Data.dll. But I still couldn't find the MYSQL Data Source in my Add connection from Server Explorer and Entity Data Model. Is ...
-5
votes
1answer
61 views
Find the max(sal),min(sal),avg(sal) in one single query [on hold]
table structure has empID,name,sal,deptID
department table had two fields deptID ,deptName
Find the max(sal),min(sal),avg(sal) in one single query
4
votes
2answers
67 views
sum of columns that are already sum in sql
SELECT DISTINCT emp_no, sum(CASE WHEN isnull(PresAbs,0)='WO' THEN 1 ELSE 0 END) WO,
sum(CASE WHEN isnull(PresAbs,0)='WP' THEN 1 ELSE 0 END) WP,
sum(CASE WHEN isnull(PresAbs,0)='HL' THEN 1 ELSE ...
1
vote
2answers
59 views
SQL group query to get data from two table
I have a department table and user table and it is obvious that each associate is in different departments.
I want to get all the users of each department separately. Can I do it by group by or...?
...
-1
votes
0answers
48 views
Find the difference between rows of same column depending on some condition
I have the following query
DECLARE @EventWithRowNum TABLE(
RowNum INT NOT NULL,
CardNo VARCHAR(10) NOT NULL,
PRIMARY KEY (CardNo,RowNum),
-- ...
1
vote
1answer
33 views
How to retrieve all values from xml in SQL
I am pretty new in SQL and stuck in a very common scenario. I have a xml with nested child as input parameter in my Stored Procedure
<XML>
<Id>1</Id>
...
-2
votes
0answers
54 views
What does it mean to have strong sql skills? [on hold]
In a job posting I saw one of the requirements was - Strong SQL skills. What exactly does this mean? How can I know whether I have the skills or not?
0
votes
3answers
65 views
SQL Server: Want to use between clause with dates, but dates in string form (YYYY.MM.DD)
Help! One column in my database is for dates. All of my dates are unfortunately in the String form (YYYY.MM.DD). I have a MASSIVE database (300+GB) so ideally would like to avoid transformations.
...
1
vote
1answer
34 views
converting true false string to boolean while using “load infile data”
I needed to transfer data from MSSQL (Microsoft SQL Server) to MySQL, and the best option for me was to write a python script that exported data as csv from MSSQL and then import this csv into mysql. ...
0
votes
3answers
79 views
How to delete a specific row in a 28GB delimited text file?
I'm trying to delete row 10,754,960 in my very large delimited text file. Ideally I'd like to see what text is on this row - SQL server import is telling me there is an error (I believe some data ...
0
votes
0answers
20 views
MySQL Migration error: Invalid timestamp literal detected
I am trying to migrate a MS SQL 2008 R2 database to MySQL 5.6 CE. I am using the MySQL WorkBench 5.2. The migration finished with tons of errors.
Most of the errors are [WRN][ copytable]: ...
0
votes
2answers
8 views
Putting timestamp on the data fetched from remote sqlserver to local mysql
I am pulling data from remote sqlserver to local mysql server using jdbc .
In remote sqlserver server I have 2 columns
Name Count
In local mysql I have 3 columns made
Name Count Time_stamp
...
