Jeff,

Love the phrase:

🙂

Just trying to visualize it now...

Bits of silicon smeared all over the server room walls... nice!

Obviously not screaming loud enough for me to hear, doh! :blush:

Aren't you missing a table to relate the hours to the project and employee?

IF OBJECT_ID('tempdb..#Employee') IS NOT NULL

DROP TABLE #Employee

IF OBJECT_ID('tempdb..#Project') IS NOT NULL

DROP TABLE #Project

IF OBJECT_ID('tempdb..#ProjectEmployeeHours') IS NOT NULL

DROP...

odanwada (5/19/2011)

---

I dont know exactly why my manager is asking like that.. but he strictly told that do not use SPROCS, Cursors or Temp Tables...

I think my manager wants the...

This may help, but first you need to read about splitting delimited strings in the Tally table article referenced in my sig below.

CREATE PROCEDURE MyReport(@years VARCHAR(max)=null)

AS

DECLARE @t TABLE(FiscalYear int)

INSERT @t...

Absolutely!

Subscribe to the daily email, read the articles and discussions.

You will learn a lot, I know I have.

Buy a book?

Go on a course?

Read online tutorials?

All of the above?

Hi,

Would like to help:

i. Could you provide some more information to work with here.

ii. What you're asking for...

Excellent question !

This post is nearly 2 Years old !!! 😀

Similarly:

DECLARE @t TABLE(s CHAR(6), i INT, d decimal(19,5))

INSERT @t(s,i,d)

SELECT TOP 20

'ABCDEF',

10,

125.5

FROM Tally

SELECT s,i,d FROM @t

Have a look at this:

http://www.sqlservercentral.com/articles/T-SQL/62867/[/url]

understand it well, then this:

http://www.sqlservercentral.com/articles/Tally+Table/72993/[/url]

I would suggest you ask your question on one of the Visual Dataflex forums:

http://support.dataaccess.com/Forums/forum.php

James Goodwin (4/13/2011)

---

Ok, I thought about this a bit more and I don't like the loop. So I came up with the following that requires a Tally Table (A...

Way too complicated!

No need for any while loops just a good old Tally (Numbers) table:

DECLARE @search VARCHAR(20)

DECLARE @find VARCHAR(2)

SELECT @search = '-ABCDABFGHABXYZ.', @find = 'AB'

SELECT

...