yep, since openrowset doesn't accept variables,(?right?) you'll be stuck with a cursor to go thru the table of file names, and dynamic SQL to do the openrowset and shredding of...

it really depends on what you are doing with the filename; they came into your temp table in a set based operation...could be thousands of file names potentially;

your example did...

i think it's just your DIR command:

exec master.dbo.xp_cmdshell 'dir c:\CIC\*.jpg /b'

*.jpg for each jpg file

/b for the brief directory style...just the file name

the database schema is the whole collection of scripts for the create tables,views,procedures, functions, etc, which should include the foreign keys of course.

foreign keys and well named columns are a...

paul of all the shared hosting i help friends with or have for myself, none give me the ability to run jobs; most do not even let me run backups.

i'm...

jadonr (1/28/2010)

---

@ Lowell

Works perfectly! I appreciate you trying to look out for me by using those extra safeguards - very nice of you.

What do I need to change to get...

jadonr (1/28/2010)

---

@Lowel

Thank you for the advice, but creating a view that features the calculation, or adding a persisted calculated column to my table won't really serve its purpose in my...

i would make eiher make a view that features the calcuation, or add a persisted calculated column to my table, and always use that for your display price:

ALTER TABLE YOURTABLE...

there is probably a more elegant way to do it, but i could only think of this:

DECLARE @IM_PRC TABLE(

ITEM_NO INT,

PRC_1 MONEY,

DESIRED_RESULTS MONEY )

INSERT INTO @IM_PRC

SELECT...

simple example on the creation:

after that you change your web.config or whereever you build your connection strings to use this username and the password you apply against it.

Lynn is so right; nothing should be using the 'sa' account. seems like you might be a little new to SQL, and that's why you are using sa for your...

hours to compile? literally? is it eight million lines of code? i'd like to see it, maybe it can be optimized.

well first, changing the database collation does not change the collation of each individual varchar,char,nvarchar and nchar columns in the tables...so you'd still have the issues because those individual...

this might help, and also the default trace can help as well:

select *

from sys.objects

where create_date > GETDATE() -30

or modify_date > GETDATE() -30

or the...

sure; simply go to the database and choose Shrink >>Files like you see above.

change the drop down from Data To Log and run it.

then if you want, you can change...