Err... did you read Steve's post correct?

You have to specify a name for the column if you use SELECT INTO.

... which creates a new table and requires a name...

Good answer! I thought about five...

Paul White (4/30/2009)

---

It is a lovely sunny and crisp day in Wellington. The sunlight is sparkling off the sea in the harbour, and all is good with the world.

I...

Hi

tschilling (4/30/2009)

---

1 - I could not dynamically build a connection string in my c# program and pass it to my SQL request to toggle the data source dynamically without jumping...

Hi

I think you downloaded the wrong version 😉

Follow this link and download the "CI" databases:

http://www.codeplex.com/MSFTDBProdSamples/Release/ProjectReleases.aspx?ReleaseId=4004

Greets

Flo

I confirm all other posts. More information imply better answers. Maybe have a look to the link in my signature.

For now a very basic way to handle this:

DECLARE @t TABLE...

Due to your severity -1. Use something between 11 and 19 to get it work.

For further information see BOL for RAISERROR

Greets

Flo

If the postfix is always to characters use this:

SELECT * FROM sys.databases WHERE name LIKE '%/___' ESCAPE '/'

If only a "_" has to be found use this:

SELECT * FROM sys.databases...

Hi

If you just mean SELECT from sys.databases try this:

SELECT * FROM sys.databases WHERE name LIKE '%/_PA' ESCAPE '/'

Otherwise you should provide more information 😉

Greets

Flo

Correct. If there are only one or two additional status to be deleted it could become part of the CASE-clause. If there are more I would probably suggest a mapping...

Hi Gail

Also thanks a lot from my side! 🙂

Greets

Flo

Apologize twice...

1st) I didn't see Lynn's answer

2nd) I forgot the "WHERE Status = 'Completed'" in my statement. Just corrected.

Greets

Flo

Hi

I hope I got you. Try this;

DECLARE @t TABLE (Id INT NOT NULL IDENTITY, OrderId INT, DeliveryDate DATETIME, Price Money, UnitId INT, Status VARCHAR(100))

INSERT INTO @t

...

Hi

Usually you should avoid functions in the WHERE clause to ensure better index usage.

What about OR? Try this:

DECLARE @t TABLE (Id INT NOT NULL IDENTITY, AnyGuid UNIQUEIDENTIFIER)

INSERT INTO @t

...

Hi Rock

I'm not completely sure if I got you, but I think you want to get this result from your dynamic SQL:

SELECT column1 + '_' + column2 FROM YourTableFromOtherTable

So you...