Viewing 15 posts - 541 through 555 (of 1,114 total)
I hope you got the below output. Right ?
11
12
13
14
15
16
17
18
19
110
21
22
23
24
25
26
27
28
29
210
31
32
33
34
35
36
37
38
39
310
41
42
43
44
45
46
47
48
49
410
51
52
53
54
55
56
57
58
59
510
61
62
63
64
65
66
67
68
69
610
71
72
73
74
75
76
77
78
79
710
81
82
83
84
85
86
87
88
89
810
91
92
93
94
95
96
97
98
99
910
101
102
103
104
105
106
107
108
109
1010
July 31, 2008 at 4:14 am
Christopher,
SELECT
a.N AS AccountNum
,b.N AS DM_Source_Id
FROM (SELECT TOP 10 N FROM Tally)...
July 31, 2008 at 4:10 am
rbarryyoung,
any updates about your article ? is it published ?
July 31, 2008 at 2:44 am
Umm...I forgot to include the below line
and a.N <= 1000
July 31, 2008 at 2:19 am
Is there a way to run
EXEC ('Select * INTO #INS From INSERTED') in trigger?
I think SELECT INTO command not allowed within a trigger.
July 31, 2008 at 2:12 am
I think if we change his code from
select
a.N as AccountNum
,b.N as...
July 31, 2008 at 2:08 am
Can you attach it once again ? Because i am unable to see any attachments.
July 31, 2008 at 1:55 am
I have executed the below code and note down the result.
Query:
---------------------------------------------------------------------------
select
a.N as AccountNum
...
July 31, 2008 at 1:52 am
Unable to see your attachments. Post it once again.
July 31, 2008 at 1:39 am
which one will provide good performance ?
My code :
insert into @customers2
select a.N as AccountNumber ,b.N as DM_Source_ID,b.N as Address
from Tally a , Tally b
where b.N <= 1000
Christopher's Code:
INSERT INTO @customers2
(AccountNum,DM_Source_Id)
select...
July 31, 2008 at 1:35 am
Karthik, why not just join the two tables on Eno?
Chris,
I do agree with you. We can use Join also.:D
July 31, 2008 at 1:25 am
what is the total rowcount without any conditions?
what is the total rowcount when Dept = 'ABC' ?
what is the total rowcount when Dept = 'XYZ' ?
July 31, 2008 at 1:22 am
SELECT * FROM EMPLOYEEINFO WHERE DEPARTMENT ='ABC'
what is the query plan ?
SELECT * FROM EMPLOYEEINFO WHERE DEPARTMENT ='XYZ'
what is the query plan ?
July 31, 2008 at 1:20 am
Execute each statement seperately and paste the query plan here.
what is the output ?
July 31, 2008 at 1:17 am
Viewing 15 posts - 541 through 555 (of 1,114 total)