Viewing 15 posts - 7,036 through 7,050 (of 10,144 total)
mister.magoo (11/16/2010)
I don't know if I like being hashed like that! :hehe:
LOL! It's a gate, mate 😉
November 16, 2010 at 7:42 am
mister.magoo (11/16/2010)
@chris-2 - but how do you select only the 3rd Salary?
Very quickly!
SET ROWCOUNT 3
SELECT *
INTO #Magoo
FROM #sal
ORDER BY Salary DESC
SET ROWCOUNT 1
SELECT *
FROM #Magoo
ORDER BY Salary
November 16, 2010 at 7:34 am
steveb. (11/16/2010)
if you are having trouble getting the test data into a usable form for help, there is a nice script here that may help.
Thanks Steve.
November 16, 2010 at 7:13 am
Paul White NZ (11/16/2010)
Hah! No, seriously then, I would have given up on that thread a good while ago. Not eager to help himself is he?
Some of his...
November 16, 2010 at 7:04 am
Amusing, but unhelpful. Now if you could just put in all the commas, quotes, SELECTs etc. to make this a runnable script, we'd have a terrific set of data to...
November 16, 2010 at 6:54 am
Paul White NZ (11/16/2010)
Chris Morris-439714 (11/16/2010)
I never know when to take you seriously Paul, even when there's a shiny bit of code visible 😛That must be really irritating.
Only on tuesday...
November 16, 2010 at 6:51 am
CREATE TABLE #SAL(
[name] [varchar](12) NULL,
[salary] [int] NULL
)
INSERT INTO #sal ( name,salary)...
November 16, 2010 at 6:47 am
Paul White NZ (11/16/2010)
Chris Morris-439714 (11/16/2010)
Am I being too harsh with this poster?You are the very model of self-restraint.
I never know when to take you seriously Paul, even when there's...
November 16, 2010 at 6:36 am
Am I being too harsh with this poster?
November 16, 2010 at 6:18 am
brainblower13 (11/16/2010)
...In that whole StoredProcedure , final Select Query Of SP output giving difference...
It's lunchtime here in the UK, I've got a whole hour to spend on this if...
November 16, 2010 at 6:16 am
Eswin (11/16/2010)
1)Is it possible to call a Stored procedure from a SQL query
Kind of:
...INSERT INTO...EXEC...
The target table columns must match the output of the stored procedure - sequence and datatype.
Eswin...
November 16, 2010 at 5:50 am
Please be patient, and don't contact me again by personal mail. By posting your scripts here, you are inviting others to assist you, which helps with the diagnosis of your...
November 16, 2010 at 4:20 am
The script for creating the table works fine, thank you.
The script for populating the table with three rows of data does not run:
Msg 205, Level 16, State 1, Line 22
All...
November 16, 2010 at 3:54 am
This runs with errors:
Msg 102, Level 15, State 1, Line 4
Incorrect syntax near 'varchar'.
Msg 102, Level 15, State 1, Line 22
Incorrect syntax near 'ID'.
Msg 102, Level 15, State 1, Line...
November 16, 2010 at 3:11 am
brainblower13 (11/16/2010)
ID main ID SplitIDstreamIDOffered TimeTerminated TimeCallerANICallerDNISIVR DigitMenuNamePrevIVR DigitPrevMenuNAmeNext IVR DigitNectMenNameIVR DISCONNESTED1211602D021A083004300:44.01:34:0091417414529141155155Main Menu1Product and promotion1
Thank you, but there isn't a CREATE TABLE statement.
The data isn't presented as INSERT statements.
We...
November 16, 2010 at 2:28 am
Viewing 15 posts - 7,036 through 7,050 (of 10,144 total)