wasn't there something in the Development folder on this?

I have known unhelpful messages but this has gotta be the worst

no advice from me, but a certain amount of moral support

getting back to the topic at hand - for those of us more interested in Ave Maria (Rudy Galindo's 1997 figure skating routine which won him the US Mens Championship...

like a lot of youse guys (and Lynn, and Gail, etc)

at the end of the day this is a useful and helpful site and I have learned so much from...

once again

lakhs is a large measure - I think it is from the Hindi

por favor (please, in Spanish)

if you use a non-english term, please define it

dank U (Dutch)

I too didn't care for the t-shirt but that was because it didn't fit in with my personal impression of what a computer professional dressed like. I go back...

We're by no means all Americans on this board....

I've been a programmer for over 30 years and rules of appearance have greatly eased up in those 3 decades. The...

I haven't encountered a company recently where suit and tie was required for men. For someone who is strictly back office and rarely encounters outside clients that is a...

CREATE FUNCTION [dbo].[FormattedSKU]

(

@SKU VARCHAR(20)

)

RETURNS VARCHAR(20)

AS

BEGIN

DECLARE @strSKU VARCHAR(20)

SET @strSKU = @SKU

IF LEN(@SKU) = 12

BEGIN

SET @strSKU = SUBSTRING(@SKU,1,1) + '-'

SET @strSKU = @strSKU + SUBSTRING(@SKU,2,5) + '-'

SET @strSKU = @strSKU +...

Check out table functions as an option, depending of course on what you are trying to do.

not a T-SQL book per se but I use Programming SQL Server 2005 by Stephen Forte (hey Steve!) a lot

he is very active in the New York City .NET User...

I found that generating random numbers is a task best done in code. Generating random numbers in SQL betrays a pattern, which makes repetitive executions predictable.

yup, that does the trick

thanks

Marianne

😛

let's say the data is like this:

ID 1 Amount 10.00

ID 1 Amount 20.00

ID 2 Amount 10.00

then the results I want is

ID Amount

1 30.00

2...

lacs is not a computer term (nor even a dairy term :))

I believe the poster meant to say lakhs, a word in Hindi meaning a large number

I had an unattributed...