Relative Content

Tag Archive for sqlsql-server

Convert Nvarchar to datetime data type

I have a legacy database. This database has stored the data in the format '02/10/2015 14:26:48'.

How can I get this additional aggregate for ContactCd to work correctly in my bigger query?

I am trying to incorporate so that each ContactCd does not create a new row. I don’t know how to make my example less complex. If I dumb it down won’t it take out all the joins that are necessary for my query?

How can i put a value in a calculated field in sql? [closed]

Closed 4 days ago.

Create a grouping then group by it with filters

I have a table that contains two sets of IDS: IDA and IDB, as well as an asofdate filter.

Calculate average completion rate per content_type [closed]

Closed 3 days ago.

Choosing price selecting from 2 customers

I have to find a price by choosing the correct price out 3 options in a hierarchy

Query with joins to build product with options

I have created the below select query that joins 5 SQL tables. The modifier table either uses the NAME column to display the modifier name or the ITEM_RECORD_KEY column to reference the RECORD_KEY of the ITEM row from the ITEM table to display the Modifier name.

Query that returns the majority verdict of reviews and the percent of that majority

My tables:

SQL query that would return the majority verdict of reviews and the percent of that majority