Friend: Check out the following link

http://www.youtube.com/watch?v=c-Zfgg5Ayyc&feature=related

Short and simple answer:

If your flat file is fixed width (delimited) use CHAR data type else use VARCHAR

Further to add on; scalar functions are always deterministic.

- Lokesh

Why to extend names of foreign keys. We can keep domain for both the tables same. Like this:

Department

=========

Dept_ID (PK)

DName

Employee

=======

ID (PK)

Name

Dept_ID (FK)

Here Dept_ID in Employee table is a foreign key to...

Function Categorization:

1) System Functions

2) User Defined Functions

2.1) Scalar Functions

2.1) In-Line table valued Functions

2.1) Multi-statement table...

Thanks for the update. I was also thinking in the same fashion.

- Lokesh

Another link for you with good examples:

http://www.sql-server-helper.com/tips/tip-of-the-day.aspx?tkey=4ab06421-e859-4b5f-a948-0c9640f3108d&tkw=uses-of-the-substring-string-function

Not sure why are you using all this for range --> use substring instead

Check this link:

http://msdn.microsoft.com/en-us/library/ms187748.aspx

Kindly post some logs. How are you so sure that the value is truncated?

Will check the logs and let you know.

- Lokesh

I do agree with Lynn on performance perspective.

- Lokesh

cool...Thanks Jason.

Much appreciated!

- Lokesh

🙂

works for x % 10 where x >= 10

Thanks

use @@rowcount after your insert statement to check if there is any data inserted

Refer this link:

http://technet.microsoft.com/en-us/library/ms187316.aspx

Jason: I always wonder when I use CTE to delete duplicate rows.

CTE being ANSI compliant, why does it let us delete data from CTE? I am sure ANSI norms does...

better way optimize for modulo 10 would be to use RIGHT function.

RIGHT(value,1) -- check if this helps