Viewing 15 posts - 5,461 through 5,475 (of 10,143 total)
Lokesh Vij (10/5/2012)
I might be wrong as well. Let jdelorino confirm!
Exactly.
October 5, 2012 at 3:51 am
naga.rohitkumar (10/5/2012)
one of my application user asking to give access to execute a storedprocedure where ever he wants to execute in any database it it possible? if so how...
October 5, 2012 at 3:50 am
SQLDBA ARJUN (10/5/2012)
hi,i need a script which will give present existing Job names in the sql server instance.
thanks
Arjun
October 5, 2012 at 3:30 am
sqlstud (10/5/2012)
...How will we do this using SSIS 2005?
Regards
Sql
SSIS is a bit overkill for this.
INSERT INTO ...
SELECT... FROM ... WHERE ...
October 5, 2012 at 3:10 am
EdA ROC (10/5/2012)
It's known as UPDATE FROM, and it's typically used to update a table with data from another and / or update a table filtered by a join with...
October 5, 2012 at 2:50 am
jdelorino (10/5/2012)
thank you sir for your reply,but the column for totalcount displays only 0 not the actual value of the totalcount column.
It works for me:
CREATE TABLE #SourceTable (
TERMINALID VARCHAR(15),
TERMINALDESC...
October 5, 2012 at 2:44 am
What will the table [dbo].[Entity.cat] contain, other than cities?
October 5, 2012 at 2:39 am
hoseini_akram (10/4/2012)
helloSorry, I'm Convert one of the fields of Table Nvarchar(10) to integers
Please help me
If you are having problems doing this, it's because the column contains...
October 5, 2012 at 2:25 am
kapil190588 (10/5/2012)
Hi,It should be
UPDATE table_name
SET RefreshDate = '20120822 08:00';
rather than
UPDATE cjs
SET RefreshDate = '20120822 08:00';
else it will throw error
Almost, but not quite. The OP's statement is
UPDATE cjs
SET...
October 5, 2012 at 2:23 am
-- CROSSTAB query
SELECT ERRORCODE, ERRORDESC,
Terminal_1 = MAX(CASE WHEN TERMINALID = 'Terminal_1' THEN TOTALCOUNT ELSE 0 END),
Terminal_2 = MAX(CASE WHEN TERMINALID = 'Terminal_2' THEN TOTALCOUNT ELSE 0 END)
FROM #SourceTable
GROUP BY...
October 5, 2012 at 2:17 am
Mark-101232 (10/4/2012)
I've waited five years, but finally I've got a reply!
Shame it's not billable Mark, we could all have gone out for a beer on the interest!
October 5, 2012 at 1:51 am
Trout (10/2/2012)
hello i have one column that I need split into two, the colum records age value, and the name of the colum is ageatdeathresults for eg are:
51years
62years
45years...
What...
October 5, 2012 at 1:49 am
TheSQLGuru (10/4/2012)
October 4, 2012 at 9:49 am
Eugene Elutin (10/4/2012)
dwain.c (10/4/2012)
...
This is kinda obscure too.
SELECT IDENTITY(INT,1,1) AS N
INTO #t
FROM (VALUES($),($),($),($),($),($),($),($),($),($))a(N)
CROSS JOIN (VALUES($),($),($),($),($),($),($),($),($),($))b(N);
There I go thinking about fortune and glory again! Well fortune anyway. 😛
No way you...
October 4, 2012 at 8:45 am
SELECT
nameid,
telephone1 = MAX(CASE WHEN rn = 1 THEN telephone END),
telephone2 = MAX(CASE WHEN rn = 2 THEN telephone END),
telephone3 = MAX(CASE WHEN rn = 3 THEN...
October 4, 2012 at 8:36 am
Viewing 15 posts - 5,461 through 5,475 (of 10,143 total)