Roger Abram (9/2/2010)

---

Thanks everybody so far... here is what I have that is generating a syntax error.

What I am trying to accomplish... dynamically create the table name with today's date......

As long as the location name exactly matches:

DECLARE @Location TABLE (LocationID int, LocationName varchar(10))

INSERT INTO @Location

SELECT 1, 'Location A' UNION ALL

SELECT 2, 'Location A' UNION ALL

SELECT 3, 'Location B' UNION...

Can you clarify a couple things?

Based on your sample data, service #10 links to specification #10 and specification #11, so how are we determining which spec's value to use?

Also,...

sounds like you didnt paste the first single quote. I can't test the executesql statement but I did test the assignment statement, which seems to be where you're getting...

Can you give us some test data as it would be stored in the table (formatted as an insert statement)?

Try:

declare @db_name nvarchar(max),@SQLString nvarchar(max)

declare @create_date datetime

set @db_name='TestDB'

set @create_date = '2009-08-20'

--select @SQLString ='select @db_name'

--exec (@SQLString)

select @db_name

select @SQLString ='select ' + @db_name + ' as databse,type_desc,create_date,modify_date from [' + @db_name + '].sys.procedures

where...

What do you mean by required?

You won't get an error if you dont do it. And depending on what you do with your query window/connection to the DB, you...

drew.allen (8/30/2010)

---

I think he's inserting into a temp table, then deleting from the temp table, and then inserting the remaining records into the production table.

If that is the case, you...

To make sure I understand your problem, you are defining a view and compiling it, and when you later choose "Script View As" to view its definition, you dont like...

Is there a reason you are deleting and inserting instead of updating?

I wouldnt say it qualifies as worst ever. Its long, but its also one table with few conditions and its easy to figure out what its doing. The...

This would be the join syntax (not tested as I dont have ddl) if you dont want a subquery.

WITH rpfnot (e_id) AS

(

SELECT DISTINCT e_id

FROM RPF

WHERE U_S = 'PPP' ...

Try running ux2dos on the file (on unix) before trying to load it ...

But based on the error it might not be a unix file issue at all. I assume...

Its possible to water your lawn with a shotglass.

But if you have a sprinkler...

Nelson Petersen (8/24/2010)

---

Some questions come to mind:

1.) If the purchased application is poorly designed or inadequately indexed, who made the decision to buy that software? The decision making...