Database

Kujtim Hyseni wrote:

Yes I hit 'test' but I got the following message:

Kujtim Hyseni wrote:

And ... ?

CREATE TABLE #Temp
(
	ID INT IDENTITY(1,1),
	col1 VARCHAR(50),
	Col2 VARCHAR(50),
	Col3 VARCHAR(50),
	position VARCHAR(50)
)


CREATE TABLE #Temp2
(
	col1 VARCHAR(50),
	Col2 VARCHAR(50),
	Col3 VARCHAR(50),
	position VARCHAR(50)
)


 
INSERT INTO #Temp
SELECT 'aaa', 'rack1', '1-3', '3' UNION
SELECT 'bbb', 'rack2', '22-23', '2' UNION
SELECT 'ccc', 'rack3', '19-20', '2' 



DECLARE @TotalRowCount  INT
DECLARE @RowCount INT
DECLARE @Positon INT
DECLARE @I INT

SET @RowCount = 1

SELECT @TotalRowCount = COUNT(*) FROM #Temp

WHILE @RowCount <= @TotalRowCount
BEGIN

	SELECT @Positon = Position FROM #Temp WHERE Id = @RowCount

	SET @I = 1

	WHILE @I <= @Positon
	BEGIN

		INSERT INTO #Temp2
		SELECT Col1, Col2, Col3, (SUBSTRING(Col3,0,CHARINDEX('-',Col3)) + @I - 1) FROM #Temp  WHERE Id = @RowCount
		
		SET @I = @I + 1
	END
	
	SET @RowCount = @RowCount + 1
	
END

SELECT * FROM #Temp2



DROP TABLE #Temp
DROP TABLE #Temp2

Member 9131839 wrote:

plz help & provide code

Member 9131839 wrote:

I have to make

Bastard Programmer from Hell

Member 9131839 wrote:

provide code

jrahma wrote:

VALUES (<layer>param_slip_month, param_slip_year)

SELECT
    C.name AS Client,
    B.Detail AS Detail
FROM
    tableC C
INNER JOIN
    tableA A
    ON (C.clientID = A.bID)
LEFT JOIN
    tableB B
    ON (C.clientID = B.clientID)
WHERE
    aID = '100'

declare @loopDate as datetime
declare @dateRange as table ( aDate datetime )

set @loopDate = @beginDate
insert into @dateRange (aDate) values (@loopDate )  -- beginning of your date range

while @loopDate < @endDate 
begin
  Dateadd(day, @loopDate, 1)
  insert into @dateRange (aDate) values (@loopDate )
end

select aDate, isnull(quantity, 0)
from 
yourTable a
left outer join @dateRange b on
  b.aDate = a.Productiondate