USE [Skuss]

GO

/****** Object: Table [dbo].

---

Script Date: 2021/11/19 14:41:12 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].

---

(

[Name] [varchar](50) NULL,

[LeaveTypeName] [varchar](50) NULL,

[DateFrom] [varchar](50) NULL,

[DateTo] [varchar](50) NULL,

[WithPayNoOfdays] [varchar](50) NULL,

[WoutPayNoOfDays] [varchar](50) NULL,

[LeaveStatus] [varchar](50) NULL,

[DateApprovedSupervisor]...

USE SKUSS

SELECT DISTINCT COUNT (NAME) FROM [dbo].

---

USE SKUSS

SELECT COUNT (*) FROM [dbo].

---

Thank You

Please provide a code with a sample parameter and one without?

 

CREATE TABLE [dbo].[CreditCardBalance](

[ID] [int] NOT NULL,

[CustomerID] [int] NULL,

[BalanceDate] [date] NULL,

[Balance] [decimal](18, 2) NULL

) ON [PRIMARY]

GO

CREATE TABLE [dbo].[BondBalance](

[ID] [int] NOT NULL,

[CustomerID] [int] NULL,

[BalanceDate] [date] NULL,

[Balance] [decimal](18, 2)...

See attached.

See https://drive.google.com/file/d/1NlImnhE35Zattw4KKH7gVrQcGcMsSlRJ/view?usp=drivesdk

 

 

Can you show me please what that code will look like?

SSIS does not recognise any of my tables in the MySQL/Maria DB. That  is the problem.

Yes, I can complete thos process easily when i do it within a TSQL DB, but this is giving me errors in thise case, data types differences.

Please give me the completed converted TSQL code?

Thank you for the assistance.

 

If i bring in Status, what would the syntax look like?

 

 

Here is the data: https://drive.google.com/file/d/1LoaPrLoz_nlAD1wnrkNaEFQDYkVmKweB/view?usp=sharing

 

Yes, i know this is for mssql only. Any idea what the mysql equavalent look like?

Yes, i know this is for mssql only. Any idea what the simialar code or equavalent for mysql is? data attached

Here it is:

 

CREATE TABLE order (

uid int(10) unsigned NOT NULL AUTO_INCREMENT,

delivery_address varchar(256) NOT NULL,

complex_unit_no varchar(200) DEFAULT NULL,

delivery_latitude varchar(20) NOT NULL,

delivery_longitude varchar(20) NOT NULL,

store_uid int(10) unsigned NOT NULL,

app_version varchar(10) DEFAULT NULL,

delivery_fee...