Please try:

SELECT mst.CICS_DIM.CUST_KEY

FROM mst.CICS_DIM

INNER JOIN stg.STG_CUSTOMER_INTEG

ON mst.CICS_DIM.CUST_CICS_ID = STG_CUSTOMER_INTEG.CUST_CIS_ID

INNER JOIN SOURCE_SYSTEM_REF

ON mst.CICS_DIM.SRC_SYS_KEY = SOURCE_SYSTEM_REF.SRC_SYS_KEY

AND SOURCE_SYSTEM_REF.SRC_SYS_ID IN ('CIS','CRD','CSS','WST','VSA')

INNER JOIN stg.CONTROL_RUN

ON mst.CICS_DIM.TRANS_END_DT = CONTROL_RUN.PROC_END_DT

AND mst.CICS_DIM.TRANS_EFF_DT <= CONTROL_RUN.PROC_EFF_DT

Utilizing code posted by Mark:

SELECT Emp, Id, MIN(Date) BlockStart, MAX(Date) BlockEnd, COUNT(*) AS NumberInBlock

FROM (SELECT Emp, Date, Id

,(SELECT COUNT(1) FROM dbo.Test t2

...

Please try:

CREATE TABLE #Test (

MyChar1 varchar(10) NOT NULL,

ApplID varchar(10) NOT NULL)

CREATE TABLE #ErrorHistory (

ApplID varchar(10) NOT NULL,

...

This might help:

-- populating test data

DECLARE @matltran TABLE (trans_num INTEGER IDENTITY

,item NVARCHAR(30)

,qty DECIMAL(18,8)

,cost DECIMAL(18,8))

DECLARE @x TINYINT

SET @x = 1

WHILE @x < 200

BEGIN

INSERT INTO @matltran (item, qty, cost)

SELECT 'Test1', 5.5, 0.7

UNION...

Please try:

SELECT [Process_ID]

,[User_ID]

,[Pat_ID]

FROM ACCESS_LOG

WHERE Process_ID NOT IN (SELECT Process_ID

...

Yes, Ramesh is right, it should be > 2

Try:

SELECT dbo.forum.Product

,dbo.forum.Supplier

,dbo.forum.SupplierCrossReference

,dbo.forum.DateLastQuoted

FROM dbo.forum

WHERE SupplierSequence = '500'

...

Please try (but if values in DateLastQuoted are the same it will update all records with the DateLastQuoted):

UPDATE dbo.Forum SET SupplierSequence = '500'

FROM dbo.Forum f1

INNER JOIN (SELECT Product, MAX(DateLastQuoted) DateLastQuoted

FROM...

Please try:

DECLARE @test-2 Table (UserID INT, UserName VARCHAR(50), billed BIT, grossamt MONEY)

INSERT INTO @test-2 (UserID, UserName, billed, grossamt)

SELECT 30681,'Smith Jane',0,1500.40 UNION ALL

SELECT 30681,'Smith Jane',0,26.00 UNION ALL

SELECT...

Please try:

SELECT @Count = COUNT(DownloadID)

FROM dbo.tblDownload

WHERE VendorID = @VendorID

AND (@Action NOT IN (‘a’,’b’)

OR (@Action = ‘a’ and DownloadStatusID IN (1,2))

...

Maybe this will help: (based on http://www.sqlservercentral.com/articles/XML/61618/)

DECLARE @test-2 TABLE (t1 VARCHAR(100))

INSERT INTO @test-2

SELECT 'Value1,Value2' UNION ALL

SELECT 'Value2' UNION ALL

SELECT 'Value2,Value3'

--IF more than 2 values per row...

Please try:

SELECT ProductId

,COUNT(1) OrderCount

,CASE WHEN COUNT(1) = 1 THEN SUM(MAN)/NULLIF(SUM(MANCount),0) ELSE AVG(MAN) END MAN

,CASE WHEN COUNT(1) = 1 THEN SUM(PUR)/NULLIF(SUM(PURCount),0) ELSE AVG(PUR) END PUR

...

Please try:

SELECT ProductId

,COUNT(1) OrderCount

,CASE WHEN COUNT(1) = 1 THEN SUM(MAN)/MANCount ELSE AVG(MAN) END MAN

,CASE WHEN COUNT(1) = 1 THEN SUM(PUR)/PURCount ELSE AVG(PUR) END PUR

FROM...

yes, you are right, it should be sum(case...

It will calculate the total cost of the element per order and then average cost for the element based on last 5 orders,...

Please replace "SUM(CASE...." with "AVG(CASE...."

That should work.