CELKO (3/19/2012)

---

The ISO-11179 is one. MS also...

Microsoft wants to show by example, that not using coding standards, ends up with great "dog's breakfast" :hehe:

I wonder what kind of...

gerald.hoole (3/19/2012)

---

how to calculate YTD sales values

Here is a sample query and not sure how to get last year sales values for the same date as current year

...

AND TRANDATE >=...

Charmer (3/16/2012)

---

Eugene Elutin (3/16/2012)

---

You don't need to change anything.

It's not producing just 2-digit numbers

if you supply 0, the next value generated will be 1, one digit of Base36 will hold...

You don't need to change anything.

It's not producing just 2-digit numbers

if you supply 0, the next value generated will be 1, one digit of Base36 will hold any decimal upto...

Looks like you didn't look what -base encoding is. As you don't care of order in which values are incrementing, that is definitely would work for you.

As promised yesterday, here...

The easiest and most elegant way to achieve what you ask is to implement 36-based encoding. I have no time today to show how it can be done in T-SQL,...

Yep! It works!

Now is only performance left.

Yours give:

Table 'Worktable'. Scan count 6, logical reads 70, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0,...

ColdCoffee (3/15/2012)

---

Eugene Elutin (3/15/2012)

---

I'm not sure what OP wants for "UNION ALL SELECT 400 ,10 ,10 " data sample, I've read his requirements as: he only want to see the...

1. Yes, for "Print" as it's T-SQL command....

ColdCoffee (3/15/2012)

---

How about this?

IF OBJECT_ID('TempDB..#Temp') IS NOT NULL

DROP TABLE #Temp;

CREATE TABLE #Temp

(

iD INT --IDENTITY(1,1)

,AMT_DIFF ...

"I have a table with the following data", especially when "Urgent Help required"...

You don't need to put the DDL for all table, just make-up to contain columns used in the query. The same for data-sample. Few rows will do which can be...

It's too late today for doing all preparation work. Please follow here:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

You can use CHARINDEX, if you really want to:

ORDER BY CAST(NULLIF(CHARINDEX('ber',City), 1) AS BIT)

,City

I'm not sure if you will like it, especially...