1) Check...

cimbom_kid (11/30/2010)

---

Hi Chris Morris,

Many thanks for your help, but the query doesn't return the results i need. The resulting query should be:

linenum, fileline, group_id

1 a, 1

2 b, 1

3 c, 1

4...

DROP TABLE #TMP_LOADER

CREATE TABLE #TMP_LOADER (

linenum int IDENTITY (1, 1),

fileline varchar(max),

group_id int)

INSERT INTO #TMP_LOADER (fileline)

SELECT 'a' UNION ALL

SELECT 'b' UNION ALL

SELECT 'c' UNION ALL

SELECT '------' UNION ALL

SELECT 'd' UNION...

You're welcome Dan, thanks for the generous feedback.

Don't forget in future to always include sample data.

Thanks Dan.

SELECT rn = ROW_NUMBER() OVER(ORDER BY JobNo, Line),

Line, JobNo, PropRef, Cont, RepDate, RepTime, LogDate, LogTime, ShortDesc, Access, JobDesc, ClientJob

FROM (

SELECT Line, JobNo, PropRef, Cont, RepDate, RepTime, LogDate, LogTime,...

Try this, untested of course - no sample data to test against!

DROP TABLE #Table

CREATE TABLE #Table (

JobNo CHAR(5),

...

Dan, if you set up the sample data like I suggested, it will be instantly usable. Not many folks will be inclined to do the formatting for you.

SELECT 'JobNo', 'Ref',...

Dan

Copy the following code and paste it into an SSMS window. Correct the DDL to match your table then amend the INSERT script to provide say 10 rows of data...

Yes you can but it's rarely a good idea.

darunsurey (11/29/2010)

---

I have a student table, employee table,...

Haha! That's how I ended up posting "What's next"!

Sorry my bad - this matches your original requirement in your first post.

You would benefit from experimenting with the code and understanding how it works:)

DECLARE @Today DATETIME, @nMonths TINYINT

SET...

Which query are you running? If you altered the code, best post it here.

You might...

Kelvin Phayre (11/25/2010)

---

One last thing.

From your data.

INSERT INTO @Table2 VALUES (01,'P1','01/01/2010',100),

...

-- Make a couple of sample tables

CREATE TABLE #Table1 (wh CHAR(2), item CHAR(2), stock INT)

INSERT INTO #Table1 (wh, item, stock)

SELECT '01','P1',1 UNION ALL

SELECT '02','P1',1 UNION ALL

SELECT '03','P1',1

CREATE TABLE #table2 (wh...