ALTER TABLE X add acolumn smallint NULL Default 0 WITH VALUES

the optional WITH VALUES populates existing rows with the default value in the new column

rob.sellinger 92152 (9/19/2011)

---

I am still looking for a way to grab the user accounts from a list as well. Ultimately i would like to run this script to generate the...

i'm using the patindex a second time to find the comma, and then pulling the length of whatever is between the two.

with stg_reporting([column 5])

AS (

SELECT '[jobname] [RPP] Info: [RPP] Job...

rob.sellinger 92152 (9/19/2011)

---

So i get an incorrect syntax on line 7 concerning the user name? Does not matter if i try to use a sql or domain user. there was...

rob.sellinger 92152 (9/19/2011)

---

ok that may work. So do i still put in each db name or is it going through all db not under id 4? also for the user...

any chance the values could be null? it looks to me like your code might do a SELECT TOP 1 from the table , and that could reutrn NULL, but...

is that what it really looks like, or is it really tab delimited, so it's something more like this with the row of data on a single line?

SAMPLE CLIENT.⇒229-19534221 N.E....

SSIS is part of one of the paid versions of SQL Server: Standard,Enterrpsie,Developer or Datacenter;

the free version fo SQL (SQL Express) installed with Visual Studio, or downloaded for free does...

use the metadata to help generate teh required commands;

i think something like this can help:

SELECT

'USE '

+ name

+ '; IF NOT EXISTS (SELECT * FROM '

+ name...

is there some sort of logic which can be used to decide whether the grading tables belong or not, or is it a conscience decision by someone after the database...

that's just a basic Group by with the summing of columns, i think:

SELECT

State,

SUM(val1) AS val1,

SUM(val2) AS val2,

SUM(val3) AS val3,

SUM(val4) AS...

ahh nice Gail, you are right!

i ran it three more times after your post, and only when it recompiled with the first parameter i threw at it showed up in...

Based on what Jason pointed to, where you can harvest info from the execution plans, this seemed to work for me;

i ran a proc "sp_find that takes one parameter...it's basic,...

"The filename, directory name, or volume label syntax is incorrect."

that says the user running the procedure via xp_cmsshell does not have permissions to get to the file you want to...

WHERE CHARINDEX(' ',ColumnName) > 0 is one way.

WHERE ColumnName LIKE '% %' is another;

you can also count the number of spaces and use that as criteria:

WHERE DATALENGTH(ColumnName ) - DATALENGTH(REPLACE(ColumnName,'...