dcarpenter (7/16/2009)

---

I have a table in my database like the one below

Table - placementconsultant

placementid PK

...

How is the data stored currently? Is your problem at the importing stage, IE in the text file it's split like that? Or is it in the database already, in...

It's hard to say from the code you've posted, since there's no example data or table structure, but this seems off to me:

Create Procedure Test (@Name varchar(100))

As

Declare @DupName varchar(100)

Declare @TempName...

Here you go. Adapted one of my earlier queries to fit. Note that there's a few limitations - you can't have more than a certain number of columns in a...

If you need each date in a separate column, and you know exactly how many date values you can have, then you can use a Pivot table to pivot the...

There is one other approach you can use, and that's to use the system stored proc sp_MSforeachtable. It's a...

Looks like you're right - didn't realize that. Unfortunate :/

well, not really sure what you mean by automate it, but if you want the script to create a column with a default value, it's:

ALTER TABLE [TableName] ADD [ColumnName] DEFAULT...

This should do what you need, though of course, the condition statements will probably be more complex 😛

Keep in mind that you can have nested CASE statements, and you can...

You could probably do it with a Pivot table. It might not present you the results the same way you want to see them though. EG:

DECLARE @TempTable TABLE

(

ID INT,

[Description] VARCHAR(100)

)

INSERT...

In that case i think your best bet is to just stick with what you have. Any other solution is going to involve a more complex WHERE clause which will...

The two cases look identical, am I missing something?

Depending on what you want to do, you could do something like:

declare @OtherAddressDetails nvarchar(1000)

set @OtherAddressDetails ='member address' -- or to whatever...

if you just want to change that field to an empty string, maybe dropping the column and then making a new column with the default value of empty string would...

terrance.steadman (7/10/2009)

---

Greetings,

This might not be a way to cause it to process in the correct order, but it would still work.

SELECT

field1

FROM devTable

WHERE

ISNUMERIC(field1) = 1

AND...

That being said, you should be careful about doing an update on a large number of rows, in a production database, since the operation will lock the rows that are...