Hi,

You can you NOT LIKE in the below way:


select * from table A where a.column not like 'V21%'.


Does that satisfy...

Yes, you are right Drew.

Hi,

Can this be of any help?

SELECT MinDate.Account_Number
     , MinDate.MinimumDate
     , A.Account_Type
     , B.Customer_Id
     , B.Customer_InvoiceValueTotal_Gross
     , C.Is_Fuel
FROM

Hi,

You are missing the END in line no 3 at the end. It should be like:

SELECT CASE WHEN CONFIG.PremiumSignShowData>0
         THEN
                  CASE SIGN...

Hi Charles,

I can think of the following options:
1. Database diagrams - could be useful to find out primary-key foreign key relationships between the tables,

Hi Jusklikebike,

Just another thought in case if it makes sense. You can have separate set of databases. The current relational database that you are currently using would be...

Hi,

I think it will be better to normalize the table if possible. Just keep the GUID and few other common properties in the parent table and distribute the...

Hi,

You can achieve this by using the following query:


SELECT
     MAX(Firstname), FamilyName, City
FROM dbo.people
GROUP BY FamilyName, City


But, it...

You can simply get it by using TOP 1 like this:


SELECT TOP 1 FirstName, Familyname
FROM dbo.people


Hi,

Your output doesn't clarify the objective. How are you picking only one record from the set of three records? Is there any filter applied? In case I understood...

Hi,

Can you process the MTH column in the SELECT query from the view like this?

SELECT
    CASE WHEN MONTH(DOCDATE) BETWEEN 7 AND 12 THEN...

Hi,

Can the below query be accommodated in your "src" subquery?

SELECT TOP 10
     ROW_NUMBER() OVER(ORDER BY SUM(SALES)) AS RowNumber, CATEGORY, SUM(SALES) AS TotalSales
FROM...

Hi,

As I tried to replicate your JSON column values in one of my tables, but there is a flaw here. You will need to enclose the FileNumber part...

Hi,
You have a wrong statement here. In the below statement, you have used column name in place of the expected table name. Please check.
SET IDENTITY_INSERT <TableName> ON;
SET...

Please post the DDL script for the table. I think the insert operation is not happening successfully. Do you have IDENTITY set in the RegionID column?