CELKO (3/21/2012)

---

Please post DDL, so that people do not have to guess what the keys, constraints, Declarative Referential Integrity, data types, etc. in your schema are. If you know how,...

Nope, they can have different names

Andy

Thats no way to speak to such a helpful chap as Jeff 😛

I use template packages quite a bit (one for each of my data warehouses) and...

Your welcome 🙂

Hi

Here is a piece of code that I use to accomplish this:

SET NOCOUNT ON

--Get a summary of the entire database.

EXEC sp_spaceused

--Declare needed variables.

DECLARE

@max-2 INT,

@min-2 INT,

@owner NVARCHAR(256),

@table_name NVARCHAR(256),

@sql NVARCHAR(4000)

DECLARE @table TABLE(

ident...

I think I need to go...

Eugene Elutin (3/15/2012)

---

Andy, actually, use of CHARINDEX for ORDER BY here will not satisfy OP requirements. Try to add another City like that:

UNION ALL SELECT'Zberlin'

You query will place it straight...

Eugene Elutin (3/15/2012)

---

Please, read the article from the link at the bottom of my signature

-- to help your helper you should provide

-- "I have table like that:" like that:...

Hi

Does do what you need?

DECLARE @temp AS TABLE

(City VARCHAR (20))

INSERT INTO @Temp

SELECT'Aberlin'

UNION ALL SELECT'Berlin'

UNION ALL SELECT'Berlina'

UNION ALL SELECT'Zedberlin'

UNION ALL SELECT'Youberlin'

UNION ALL SELECT'Irrelevant'

UNION ALL SELECT'MoreIrrelevant'

SELECT *

FROM @Temp

WHERE

City...

Not a stupid question at all! 🙂

Your welcome

Andy

D'oh spot on! Forgot to add...

As far as I know no not using single quotes - you need to use double quotes.

use msdb

go

sp_help_job

@job_name = N'Daily ''full'' backup',

@job_aspect = N'all'

Hi

SELECT

Encounter

FROM

JeffTest

WHERE

Encounter NOT IN ( SELECT Encounter FROM JeffTest WHERE DocType = 305 )

Andy

For renaming a column the syntax is:

EXEC sp_rename 'Table.OldColumnName', 'NewColumnName', 'COLUMN'

Andy