Viewing 15 posts - 1,246 through 1,260 (of 2,894 total)
SELECT f1, COUNT(*) AS CountOfQ6_BRANCH
FROM (
SELECT format(WEEK_DATE, "YYYYMM") as f1 FROM TBL_AML_ERRORS
WHERE Q6_BRANCH...
September 11, 2012 at 7:43 am
Brandie Tarvin (9/11/2012)
They are both incorrect syntax. You will get an error if you try to use either of them..
Until
in case #1: Select * from table.col
"table"...
September 11, 2012 at 5:01 am
lianvh (9/11/2012)
September 11, 2012 at 4:19 am
Looks like you are looking for "Dynamic Pivot":
September 11, 2012 at 4:12 am
Googling it out would give you the answer quite easily:
http://msdn.microsoft.com/en-us/library/ms186981(v=sql.105).aspx
September 11, 2012 at 4:06 am
CELKO (9/10/2012)
September 11, 2012 at 4:01 am
CELKO (9/10/2012)
I need to insert empty row in a temp table within a stored procedure.
Where is the DDL? There is no such concept in RDBMS.
...
What kind of...
September 11, 2012 at 3:39 am
One of the column you return in one of your "selects" (I think it's a first one
) is of smalldatetime data type (we don't know which column exactly, as you...
September 11, 2012 at 3:30 am
dwain.c (9/11/2012)
Sean Lange (9/10/2012)
You know simply repeating a vague description does nothing to help me understand it.
"Insanity is doing the same thing over and over again and expecting different results."
--...
September 11, 2012 at 3:20 am
I have gt this idea suggest me if i can do it in a better way .........
The much better way would be to contact DBA (if you cannot change it...
September 11, 2012 at 3:11 am
ScottPletcher (9/7/2012)
1. Columns are fields!
Technically they are not.
But in practice, many people refer to SQL columns as "fields", so you just have to accept that and move on.
What do...
September 10, 2012 at 3:49 am
...
Galileo was the only one which tried to oppose the common knowledge about geocentric model of the Universe.
So, who was wrong and who was right?
I cannot believe you are comparing...
September 7, 2012 at 3:19 am
Columns are not fields. Did you learn anything? Have you looked up ISO-11179 or read a book on basic data modeling yet? Why did you fail to follow minimal Netiquette...
September 7, 2012 at 2:56 am
CELKO (9/6/2012)
[ "Granite! Use big hunks of granite!". I would add also: polish it first!
It's cheaper than a screwdriver, and from performance point of view it can be much faster......
September 7, 2012 at 2:42 am
Luis Cazares (9/6/2012)
CELKO (9/6/2012)
September 6, 2012 at 10:56 am
Viewing 15 posts - 1,246 through 1,260 (of 2,894 total)