I wonder why MS does not restrict altering more than one column within one month.

I think he ment this:

SELECT *

FROM yourtable

WHERE Dep_name = 'prod'

ORDER BY Member_Name

SELECT *

FROM yourtable

WHERE...

SELECT QUOTENAME('abc[]def', '"')

Debra, take a break and spend several minutes learning SQL syntax.

declare @weight varchar(20)

set @weight = 5

declare @sql varchar(8000)

set @sql = 'select [' + @weight + '] from shippingrates with (NOLOCK)'

PRINT...

Copying images to audit table is not such a brilliant idea.

It's huge overhead which will slow down the system significantly.

But if you really sure you need to do it then...

Problem is:

@Weight char(50),

[ + @Weight + ]

becomes

[5 ...

To make it universal and manageable:

SELECT t.rowid, n.Number

FROM t

INNER JOIN [Numbers] n

INNER JOIN AllowedSymbols A ON n.Number = A.ASCIICode

WHERE SUBSTRING([column],n.Number,1) = A.Symbol

Table AllowedSymbols contains all symbols not to be...

> select * from tbl_ORD_CUST where c_order_id = x

It must be @x?

And what is the datatype of @x?

Original request was :

> Can anyone suggest a quick way to create 100,000 random numbers without using a cursor or loop ?

100,000 random numbers means 100,000 numbers, not a random...

chandrika5, to which of user records you wanna join fname2 lname2?

When you pray for long life ask nt only for yourself. Pray also for Microsoft stil to be there and support current version of MS SQL Server.

1700, 1800, 1900 were not leap years.

2100, 2200 will not be as well.

2000 was an exclusion because of "reverse compesation".

Leap year adds 6 hours to each year. Instead of 5...

You need scalar function taking string as 1st parameter and name part as 2nd one.

Then it's gonna be like this:

Select dbo.NamePart(FullName, 'FirstName') as FirstName, dbo.NamePart(FullName, 'MiddleName') as MiddleName, dbo.NamePart(FullName, 'LastName')...

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=328977

What are you trying to do?

Explain in normal words.