Viewing 15 posts - 1,861 through 1,875 (of 2,894 total)
CELKO (3/19/2012)
I wonder what kind of coding standards do You refer to? Are any industry-wide recognised standards available? What is ISO number for them?
The ISO-11179 is one. MS also...
March 19, 2012 at 9:27 am
Artoo22 (3/19/2012)
...Why doesn't Microsoft use T-SQL coding standards?
...
Microsoft wants to show by example, that not using coding standards, ends up with great "dog's breakfast" :hehe:
I wonder what kind of...
March 19, 2012 at 6:25 am
gerald.hoole (3/19/2012)
Here is a sample query and not sure how to get last year sales values for the same date as current year
...
AND TRANDATE >=...
March 19, 2012 at 6:20 am
Charmer (3/16/2012)
Eugene Elutin (3/16/2012)
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...
March 16, 2012 at 11:23 am
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...
March 16, 2012 at 10:01 am
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...
March 16, 2012 at 7:05 am
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,...
March 15, 2012 at 12:49 pm
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,...
March 15, 2012 at 12:44 pm
ColdCoffee (3/15/2012)
Eugene Elutin (3/15/2012)
March 15, 2012 at 12:05 pm
itskanchanhere (3/15/2012)
the fact that "print" and "go" do not work proves that SQL Teradata is not compatible with SQL Server. Am I right??
1. Yes, for "Print" as it's T-SQL command....
March 15, 2012 at 12:02 pm
ColdCoffee (3/15/2012)
IF OBJECT_ID('TempDB..#Temp') IS NOT NULL
DROP TABLE #Temp;
CREATE TABLE #Temp
(
iD INT --IDENTITY(1,1)
,AMT_DIFF ...
March 15, 2012 at 11:49 am
sunnyepgc (3/15/2012)
Urgent Help required in implementing below using SQL SERVER 2008.I have a table with the following data.
...
"I have a table with the following data", especially when "Urgent Help required"...
March 15, 2012 at 11:41 am
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...
March 15, 2012 at 11:16 am
It's too late today for doing all preparation work. Please follow here:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
March 15, 2012 at 10:43 am
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...
March 15, 2012 at 10:38 am
Viewing 15 posts - 1,861 through 1,875 (of 2,894 total)