there's a couple of script contributions:

there's several threads on the same subject as well.

http://www.sqlservercentral.com/search/?q=number+to+words

garth i could not get a result to work the way you said; we would need something equivilent to this to test with:

With TableA (,col)

AS

(SELECT 1,'1308064*8' UNION ALL

SELECT 2,...

UPDATE SET [col] = [col]

Seriously? that is the trigger body? updating the column to itself, with referencing the INSERTED virtual table?

Remember we are not in your cube looking...

Minnu (12/20/2012)

---

Am having a table called products with 4 columns, whenever any new insert or update happens,

column "Product_Name_Expiry" will be udpated with prouduct_Name : Product_expriry_date.

IDProduct_NameProduct_Expiry_Date ...

something like this?

note you have to modify the role everytime a proc/function is dropped and created, or new ones added.

CREATE ROLE MyExecProcRole;

CREATE ROLE MyExecFuncRole;

--GRANT EXEC permissions to all SPs and...

If the Mayans were so good at predicting the future, wouldn't there still be Mayans left?

yes exactly...listing the specific columns, which would of course be unique to your table and text files.

for your other question, i don't see any value to fiddling with the data...

well, one way is to use the delimitedSplit8K function to chop the string into bitesize peices.

from there, you might need to cross apply, modifying the WHERE statement to limit it...

well it depends on the details Brian;

in situations where the target table does not exactly match the columns (different column order, subset of columns)

you can attack it a different way:...

BULK INSERT works well, BCP IN,The Import DaTa Wizard or a full blown SSIS package are your options I can think of offhand.

here's a simple example of bulk insert:

CREATE TABLE...

well, here's...

Minnu (12/19/2012)

---

Hi Team,

Am having a trigger, which will update a column when insert / update occurs,

for new inserting or updating records trigger is working fine, but

am having a table, which...

Abrar Ahmad_ (12/18/2012)

---

[font="Verdana"]Lowell, your support was superb, but is there any solution to the following new issue :doze:

That in previous releases i can define shortcut keys for my own purpose...

neither of those two flags are going to have any significant performance gains:

minimally logged inserts:

http://www.google.com/search?q=sql+server+trace+flag+610&rls=com.microsoft:en-us&ie=UTF-8&oe=UTF-8&startIndex=&startPage=1&rlz=

grow the files at once:

http://www.google.com/search?q=sqlserver+trace+flag+1117&rls=com.microsoft:en-us&ie=UTF-8&oe=UTF-8&startIndex=&startPage=1&rlz=

I'm skipping over the possibility of undersized hardware, memory, or slow disks...

Google says it can be found here:

http://adventureworksdw2008.codeplex.com/releases/view/86762