Doug,

There is no way that I know of to do what you want to acheive, which is to dynamically change the variable name and use the same insert statement for...

Not sure just what you are asking about the 'Filters'.

Are you trying to insert the select statement from each If block into #DLFiltered, insert the select statement into another table,...

I am making a couple assumptions here:

1. the @intId is the primary key from the Master Table

2. You will have a max of 4 child records to the...

Instead of:

SELECT {list of fields}

INTO {temp table}

FROM ....

try:

INSERT INTO {temp table} ({list of fields from the temp table})

SELECT ...

FROM ....

Dave

Matt,

At least they handed you a SQL Server book to start with. All they gave me was the instructions: 'Here is a SQL Server database. Make it...

Sure,

Create the Temp table with a CREATE TABLE

and then do an INSERT INTO instead of SELECT INTO

Dave Novak

I am not sure on this, but I...

john.arnott (4/21/2008)

---

I wonder about why one would want to append a constant ".html" to a particular column and store the result in the database. For any larger number of...

I would do this as two SQL statements. The first one is an update statement to set the flag in TMain to 1 or Y for a match in...

Not that I know of with out reviewing the SP you are calling.

Basically, if there are two datafiles for a database, you want two @WithMove input parameters. If there are three, then three @WithMove input parameters. and etc...

You could do...

Replace the select statement in the SP with the following IF block:

IF (@ItemName IS NULL OR @ItemName = '')

AND (@ItemGroup IS NULL OR @ItemGroup = '')

AND (@ItemPrice IS NULL OR...

I have never been a fan of dynamic SQL when I do not have to. There is a solution to this as a SP that does not need dynamic...

check out CHARINDEX(param1, param2, param3)

param1 -- [string expression] --What you are looking for. In your sitaution ','

param2 -- [string expression/column] --What to search for param1 in

param3 -- [int]...

It looks like you have multiple titles for your consultants in the:

sharedDimension..DimConsultantTitle s ON t.CurrentLevelXID = s.XID

Is it possible for your consultants to have multiple active Job Titles?

or is there...