UPDATE Table1

SET Quarter = 'Q' + DATENAME(QUARTER, Date) + '/' + DATENAME(YEAR, Date)

22 answers here too!

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=97159

All you need to know about DYNAMIC SQL

http://www.sommarskog.se/dynamic_sql.html

More items to your toolbox found here.

At least how to format the concatenated string

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=81254#344547

More interesting thing on how to format the concatenated string

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=81254#344547

-- Prepare sample data

CREATE TABLEtbl_Small

(

SmallID INT IDENTITY(1, 1),

SmallDesc NVARCHAR(50) COLLATE SQL_LATIN1_GENERAL_CP1_CI_AS

)

INSERTtbl_Small

(

SmallDesc

)

SELECT'Desc1' UNION ALL

SELECT'Desc2' UNION ALL

SELECT'Desc3'

CREATE TABLEtbl_Big

(

BigID INT IDENTITY(1, 1),

BigCol1 NVARCHAR(50) COLLATE SQL_LATIN1_GENERAL_CP1_CI_AS,

BigCol2 NVARCHAR(50) COLLATE SQL_LATIN1_GENERAL_CP1_CI_AS,

BigCol3 NVARCHAR(50) COLLATE SQL_LATIN1_GENERAL_CP1_CI_AS,

SmallID INT

)

INSERTtbl_Big

(

BigCol1,

BigCol2,

BigCol3

)

SELECT'asd', 'fgh',...

WHILE @@Fetch_Status = 0

BEGIN

UPDATEb

SETb.SmallID = CAST((SELECT s.SmallID FROM tbl_Small AS s WHERE s.SmallDesc = @SmallString) AS VARCHAR)

FROMtbl_Big AS b

WHEREb.SmallID = @SmallString

FETCH NEXT FROM smallCursor INTO @smallString

END

Without knowing the layout (DDL) of your tables, all I can say is

Use a CTE approach.

There are examples in Books Online how to use recursive cte.

http://www.datamodel.org/NormalizationRules.html

One table Countries

CountryID CountryName

1 USA

2 Sweden

...

Another table

CountryLinks

CountryID LinkType

1 1

1 2

2 1

3 1

3 2

3 3

Where LinkType denotes which type of link that is relevant (much like your bit approach), meaning passport,...

Here is a few examples how to use OUTPUT

http://weblogs.sqlteam.com/peterl/archive/2007/10/03/New-OUTPUT-operator.aspx

Read about @@ROWCOUNT in Books Online.

If you only want positive prices remove the comment markers "--" and make "AND MAX(Price) >= 0" part of the query.

If you leave as is, you could potentially get a...

If you want to update the view with SSMS there is.

It is not a matter if you want to...

Yes, but the phone table has both TYPE and PHONE columns, which makes me think the table is normalized liek this

TYPE PHONE

HOME 555-5687

CELL 444-45524

And then coalesce...

Don't be shy Jeff.

Why float is inprecise is discussed here and also explained why.

http://www.sqlservercentral.com/Forums/Topic356756-8-1.aspx

The basic reason is that it is not possible with binary representation to get exactly all possible...