How about a kind of split function that returns a table. (tvf)

and performing a left outer join to the same tfv with the new contend.

declare @mycolumn varchar(max)

select @mycolumn =...

search the SSC forums "developer sysadmin" and you'll find many hits .

Actualy best practise still is using Dr. Codd's rules fo Normalization of the Data Base Relational Model. http://www.sqlservercentral.com/articles/Advanced/coddsrules/1208/

An identity is just an incrementing number (altough you can increment with a...

FYI

Actualy with SQL2005 this would not make sence at all !

Reason ?

The ssis service only fulfills the role of "gateway" to if you want to manage the packages via...

you need to set you destination connection parameter

"retainsameconnection" to true (false by default) to be able to use

#tmp tables !

first it will try to find the (unqualified) object using username.object, if it cannot

find that, it will try with dbo.object.

If the connected user is the actual database owner, his db-username...

IMO the big difference is that the user assigned by sp_changedbowner can

create objects like "create table xyz (col1 int)" and the object will be created as dbo.xyz.

Members of the...

like it says: "check sqlserver errorlog" !!

dbid 2 = msdb

Perform DBCC checkdatabase for msdb !

You can even post the results within this thread. :hehe:

just to add ...

if you are planning to use reporting server, keep in mind it only supports accounts with a maximum character length of 20 characters!!

You'll need another filegroup.

Keep in mind that the clustering index actualy contains all table data, you may not want to move that to your indexes filegroup.

Also keep in mind, you...

you could install a second instance of sql2005 and use Windows system resource manager (WSRM)

to govern CPU usage %.

WSRM is also available for x64 !

Mark (2/5/2008)

---

Here's 'GrpBal' using XML

WITH CTE AS (

SELECT a.AccountID,

(SELECT b.Date AS "@Date",

...

I'd suggest you use a nested table expression, meaning

select nestedTSel.*

, [Monthly Pac] ....

from ( select 'Monthly Pac' = CASE

WHEN tPolicyBillPrem.POL_BILL_TYP_CD = '4' AND tPolicyA.POL_CSTAT_CD = '1' THEN tPolicyBillPrem.POL_SNDRY_AMT

ELSE 0

END,

'Annualized Premium'...

Script your SSMS changes to the table and you'll see it does something

completely different than you think.

Using SSMS it will not perform alter table alter column ...

but it will...