Viewing 15 posts - 5,461 through 5,475 (of 10,144 total)
jdelorino (10/5/2012)
Thank you for your reply,your help is greatly appreciated, more power.
Can you please post the solution you are using? It provides feedback to those who have taken time to...
October 5, 2012 at 4:16 am
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
Viewing 15 posts - 5,461 through 5,475 (of 10,144 total)