Viewing 10 posts - 16 through 25 (of 25 total)
Check your TCP/IP connection enabled in Server and client place which can be found in SQL server configurations.
July 17, 2008 at 6:53 am
Hi,
Please let me clear my existing set up and further requirements.
1.Sorry I have SQL server 2005 standard edition not Enterprise edition.
2.Our currenct production server have 4 processors.
3.Other server where planning...
April 3, 2008 at 2:42 am
HI,
I have situation where we have production server where all database are resides and planning to have seprate Reporting server on other machine but it will connect to production server...
April 2, 2008 at 10:13 am
Hi,
Thanks for your reply.
It cant be all the time max value and it could be any value.
If I select max value then it will be wrong.
Regards
November 17, 2007 at 12:25 am
Thanks for your reply.
I know what you have done but I need further more complicated out out.
I am looking for YearValue from there onwards value become stagnant.
Regards
November 16, 2007 at 9:08 am
I get result with 5 columns which are as mentioned in my previous post.
You can see in the data that from yearvalue >=30 all the values become stagant.
I need to...
November 16, 2007 at 8:29 am
There is small correction in the data and I need find min Yearvalue from there onwards value become -stagnant
IDDateValueValueYearValueMonthvalue
340517/10/20074.986700
346117/10/20075.176401
316717/10/20075.222802
290517/10/20075.19603
235617/10/20075.150904
447917/10/20075.105705
422017/10/20075.060606
397317/10/20075.013907
402117/10/20074.967208
378117/10/20074.920509
108017/10/20074.8864010
82817/10/20074.8522011
118317/10/20074.818110
354917/10/20074.793411
313417/10/20074.768812
286117/10/20074.744113
273317/10/20074.729614
247817/10/20074.715115
445717/10/20074.700616
419717/10/20074.693817
408217/10/20074.687118
382917/10/20074.680319
100617/10/20074.6752110
74317/10/20074.6701111
138217/10/20074.66520
114817/10/20074.667421
338117/10/20074.669822
303117/10/20074.672223
282817/10/20074.676224
250417/10/20074.680325
467717/10/20074.684326
435317/10/20074.69427
420817/10/20074.703628
389017/10/20074.713329
370017/10/20074.721210
94817/10/20074.7286211
157817/10/20074.736330
132417/10/20074.744131
348917/10/20074.751932
322017/10/20074.759733
295117/10/20074.763634
268617/10/20074.767535
242817/10/20074.771436
455917/10/20074.779637
429517/10/20074.787838
405117/10/20074.79639
381217/10/20074.8045310
112217/10/20074.813311
62017/10/20074.821540
83417/10/20074.831841
100917/10/20074.84242
377817/10/20074.852343
396017/10/20074.859244
427817/10/20074.866145
445917/10/20074.87346
241017/10/20074.882147
257417/10/20074.891348
291217/10/20074.900449
310117/10/20074.9088410
346017/10/20074.9173411
53217/10/20074.925750
58017/10/20074.933951
95517/10/20074.942252
362817/10/20074.950453
377417/10/20074.958254
401417/10/20074.965955
440317/10/20074.973756
465017/10/20074.981257
240917/10/20074.988658
266117/10/20074.996159
308417/10/20075.005510
336117/10/20075.014511
44517/10/20075.022960
39617/10/20075.031261
63917/10/20075.039462
88117/10/20075.047763
384217/10/20075.055864
409417/10/20075.06465
433917/10/20075.072166
459917/10/20075.079767
455317/10/20075.087468
242417/10/20075.09569
269117/10/20075.1026610
295217/10/20075.1101611
5517/10/20075.117770
55317/10/20075.122571
71517/10/20075.127272
103417/10/20075.13273
92517/10/20075.135674
367517/10/20075.139375
385617/10/20075.142976
418017/10/20075.146977
466917/10/20075.150978
263117/10/20075.154979
281217/10/20075.1581710
315817/10/20075.1614711
24917/10/20075.164680
417/10/20075.170981
41217/10/20075.177282
64717/10/20075.183583
103917/10/20075.189884
372717/10/20075.196185
412817/10/20075.202486
437517/10/20075.208287
419317/10/20075.21488
444917/10/20075.219989
248317/10/20075.2257810
273817/10/20075.2315811
189817/10/20075.237390
39317/10/20075.242291
5417/10/20075.247192
86917/10/20075.252193
113017/10/20075.25794
80817/10/20075.261995
405617/10/20075.266896
374417/10/20075.27297
454617/10/20075.277198
421417/10/20075.282399
267317/10/20075.2874910
234217/10/20075.2926911
178917/10/20075.2977100
200217/10/20075.3018101
45317/10/20075.3058102
19717/10/20075.3099103
91717/10/20075.3139104
67717/10/20075.318105
385917/10/20075.322106
360417/10/20075.3261107
381617/10/20075.3301108
470717/10/20075.3342109
431217/10/20075.33821010
286617/10/20075.34231011
230717/10/20075.3464110
179117/10/20075.3504111
40517/10/20075.3545112
13517/10/20075.3585113
16217/10/20075.3626114
104917/10/20075.3666115
79717/10/20075.3707116
413817/10/20075.3747117
357717/10/20075.3788118
447617/10/20075.3828119
422717/10/20075.38691110
275417/10/20075.39091111
221017/10/20075.395120
212517/10/20075.3975121
177817/10/20075.4122
29117/10/20075.4025123
25517/10/20075.405124
107017/10/20075.4075125
73617/10/20075.41126
400117/10/20075.4125127
399917/10/20075.415128
366817/10/20075.4175129
450217/10/20075.41991210
417317/10/20075.42241211
120717/10/20075.4249130
230317/10/20075.4274131
188817/10/20075.4299132
48317/10/20075.4324133
37817/10/20075.4349134
10917/10/20075.4374135
86417/10/20075.4399136
62117/10/20075.4424137
409717/10/20075.4449138
383917/10/20075.4474139
460217/10/20075.44991310
433417/10/20075.45241311
141017/10/20075.4549140
120117/10/20075.4574141
213317/10/20075.4599142
186317/10/20075.4624143
47417/10/20075.4648144
21517/10/20075.4673145
108717/10/20075.4698146
83917/10/20075.4723147
57917/10/20075.4748148
389617/10/20075.4773149
362917/10/20075.47981410
454517/10/20075.48231411
191517/10/20075.4848150
212117/10/20075.4863151
119417/10/20075.4877152
145317/10/20075.4892153
169217/10/20075.4907154
76917/10/20075.4922155
103117/10/20075.4936156
14617/10/20075.4951157
42817/10/20075.4966158
423817/10/20075.498159
450617/10/20075.49951510
359917/10/20075.5011511
180217/10/20075.5025160
192317/10/20075.5039161
232517/10/20075.5054162
139017/10/20075.5069163
149617/10/20075.5083164
59217/10/20075.5098165
98217/10/20075.5113166
8617/10/20075.5128167
19417/10/20075.5142168
45017/10/20075.5157169
440917/10/20075.51721610
465717/10/20075.51861611
292917/10/20075.5201170
178017/10/20075.5216171
212317/10/20075.5231172
125817/10/20075.5245173
129217/10/20075.526174
162317/10/20075.5275175
77017/10/20075.529176
110017/10/20075.5304177
3717/10/20075.5319178
35917/10/20075.5334179
424017/10/20075.53481710
456817/10/20075.53631711
281617/10/20075.5378180
270517/10/20075.5393181
177017/10/20075.5407182
204217/10/20075.5422183
141217/10/20075.5437184
166617/10/20075.5451185
74817/10/20075.5466186
100417/10/20075.5481187
97617/10/20075.5496188
8117/10/20075.551189
35117/10/20075.55251810
417017/10/20075.5541811
242717/10/20075.5554190
280717/10/20075.5569191
201217/10/20075.5584192
228117/10/20075.5599193
210817/10/20075.5613194
117317/10/20075.5628195
157117/10/20075.5643196
66817/10/20075.5657197
103217/10/20075.5672198
14717/10/20075.5687199
54117/10/20075.57021910
435117/10/20075.57161911
262417/10/20075.5731200
239517/10/20075.5734201
272417/10/20075.5736202
186017/10/20075.5739203
218917/10/20075.5742204
132317/10/20075.5745205
165817/10/20075.5747206
81917/10/20075.575207
60317/10/20075.5753208
91417/10/20075.5755209
9617/10/20075.57582010
43817/10/20075.57612011
313917/10/20075.5763210
278017/10/20075.5766211
236517/10/20075.5769212
210317/10/20075.5772213
228217/10/20075.5774214
202017/10/20075.5777215
159317/10/20075.578216
134617/10/20075.5782217
93217/10/20075.5785218
69217/10/20075.5788219
29217/10/20075.5792110
4417/10/20075.57932111
303817/10/20075.5796220
311417/10/20075.5799221
291917/10/20075.5801222
258017/10/20075.5804223
208417/10/20075.5807224
173717/10/20075.5809225
155317/10/20075.5812226
121817/10/20075.5815227
135917/10/20075.5817228
102117/10/20075.582229
83817/10/20075.58232210
53417/10/20075.58262211
355617/10/20075.5828230
297617/10/20075.5831231
271117/10/20075.5834232
245817/10/20075.5836233
250617/10/20075.5839234
223117/10/20075.5842235
197517/10/20075.5844236
170617/10/20075.5847237
115617/10/20075.585238
89917/10/20075.5853239
66217/10/20075.58552310
42517/10/20075.58582311
346617/10/20075.5861240
339417/10/20075.5863241
295917/10/20075.5866242
269217/10/20075.5869243
259817/10/20075.5871244
233017/10/20075.5874245
191917/10/20075.5877246
163817/10/20075.5879247
151717/10/20075.5882248
125017/10/20075.5885249
85017/10/20075.58882410
61217/10/20075.5892411
365917/10/20075.5893250
342617/10/20075.5895251
323017/10/20075.5896252
288317/10/20075.5898253
267517/10/20075.5899254
234617/10/20075.59255
216017/10/20075.5902256
180417/10/20075.5903257
164117/10/20075.5905258
131617/10/20075.5906259
113217/10/20075.59082510
80917/10/20075.59092511
85317/10/20075.5911260
109617/10/20075.5912261
135017/10/20075.5914262
160817/10/20075.5915263
186417/10/20075.5917264
213917/10/20075.5918265
239917/10/20075.592266
265717/10/20075.5921267
292117/10/20075.5923268
318117/10/20075.5924269
346317/10/20075.59262610
372317/10/20075.59272611
75017/10/20075.5929270
97717/10/20075.593271
115917/10/20075.5932272
149717/10/20075.5933273
168717/10/20075.5935274
202817/10/20075.5936275
221717/10/20075.5938276
256817/10/20075.5939277
270417/10/20075.5941278
306417/10/20075.5942279
328817/10/20075.59432710
362217/10/20075.59452711
67117/10/20075.5946280
70717/10/20075.5948281
110817/10/20075.5949282
136517/10/20075.5951283
148317/10/20075.5952284
174017/10/20075.5954285
216817/10/20075.5955286
242917/10/20075.5957287
255817/10/20075.5958288
280217/10/20075.596289
324217/10/20075.59612810
350717/10/20075.59632811
29417/10/20075.5964290
79317/10/20075.5966291
105217/10/20075.5967292
130117/10/20075.5969293
128117/10/20075.597294
154117/10/20075.5972295
179417/10/20075.5973296
206917/10/20075.5975297
260917/10/20075.5976298
287317/10/20075.5978299
313717/10/20075.59792910
341117/10/20075.59812911
49817/10/20075.5982300
1537617/10/20075.5982301
1537717/10/20075.5982302
1537817/10/20075.5982303
1537917/10/20075.5982304
1538017/10/20075.5982305
1538117/10/20075.5982306
1538217/10/20075.5982307
1538317/10/20075.5982308
1538417/10/20075.5982309
1538517/10/20075.59823010
1538617/10/20075.59823011
1538717/10/20075.5982310
1538817/10/20075.5982311
1538917/10/20075.5982312
1539017/10/20075.5982313
1539117/10/20075.5982314
1539217/10/20075.5982315
1539317/10/20075.5982316
1539417/10/20075.5982317
1539517/10/20075.5982318
1539617/10/20075.5982319
1539717/10/20075.59823110
1539817/10/20075.59823111
1539917/10/20075.5982320
1540017/10/20075.5982321
1540117/10/20075.5982322
1540217/10/20075.5982323
1540317/10/20075.5982324
1540417/10/20075.5982325
1540517/10/20075.5982326
1540617/10/20075.5982327
1540717/10/20075.5982328
1540817/10/20075.5982329
1540917/10/20075.59823210
1541017/10/20075.59823211
1541117/10/20075.5982330
1541217/10/20075.5982331
1541317/10/20075.5982332
1541417/10/20075.5982333
1541517/10/20075.5982334
1541617/10/20075.5982335
1541717/10/20075.5982336
1541817/10/20075.5982337
1541917/10/20075.5982338
1542017/10/20075.5982339
1542117/10/20075.59823310
1542217/10/20075.59823311
1542317/10/20075.5982340
1542417/10/20075.5982341
1542517/10/20075.5982342
1542617/10/20075.5982343
1542717/10/20075.5982344
1542817/10/20075.5982345
1542917/10/20075.5982346
1543017/10/20075.5982347
1543117/10/20075.5982348
1543217/10/20075.5982349
1543317/10/20075.59823410
1543417/10/20075.59823411
1543517/10/20075.5982350
1543617/10/20075.5982351
1543717/10/20075.5982352
1543817/10/20075.5982353
1543917/10/20075.5982354
1544017/10/20075.5982355
1544117/10/20075.5982356
1544217/10/20075.5982357
1544317/10/20075.5982358
1544417/10/20075.5982359
1544517/10/20075.59823510
1544617/10/20075.59823511
1544717/10/20075.5982360
1544817/10/20075.5982361
1544917/10/20075.5982362
1545017/10/20075.5982363
1545117/10/20075.5982364
1545217/10/20075.5982365
1545317/10/20075.5982366
1545417/10/20075.5982367
1545517/10/20075.5982368
1545617/10/20075.5982369
1545717/10/20075.59823610
1545817/10/20075.59823611
1545917/10/20075.5982370
1546017/10/20075.5982371
1546117/10/20075.5982372
1546217/10/20075.5982373
1546317/10/20075.5982374
1546417/10/20075.5982375
1546517/10/20075.5982376
1546617/10/20075.5982377
1546717/10/20075.5982378
1546817/10/20075.5982379
1546917/10/20075.59823710
1547017/10/20075.59823711
1547117/10/20075.5982380
1547217/10/20075.5982381
1547317/10/20075.5982382
1547417/10/20075.5982383
1547517/10/20075.5982384
1547617/10/20075.5982385
1547717/10/20075.5982386
1547817/10/20075.5982387
1547917/10/20075.5982388
1548017/10/20075.5982389
1548117/10/20075.59823810
1548217/10/20075.59823811
1548317/10/20075.5982390
1548417/10/20075.5982391
1548517/10/20075.5982392
1548617/10/20075.5982393
1548717/10/20075.5982394
1548817/10/20075.5982395
1548917/10/20075.5982396
1549017/10/20075.5982397
1549117/10/20075.5982398
1549217/10/20075.5982399
1549317/10/20075.59823910
1549417/10/20075.59823911
1549517/10/20075.5982400
1549617/10/20075.5982401
1549717/10/20075.5982402
1549817/10/20075.5982403
1549917/10/20075.5982404
1550017/10/20075.5982405
1550117/10/20075.5982406
1550217/10/20075.5982407
1550317/10/20075.5982408
1550417/10/20075.5982409
1550517/10/20075.59824010
1550617/10/20075.59824011
1550717/10/20075.5982410
1550817/10/20075.5982411
1550917/10/20075.5982412
1551017/10/20075.5982413
1551117/10/20075.5982414
1551217/10/20075.5982415
1551317/10/20075.5982416
1551417/10/20075.5982417
1551517/10/20075.5982418
1551617/10/20075.5982419
1551717/10/20075.59824110
1551817/10/20075.59824111
1551917/10/20075.5982420
1552017/10/20075.5982421
1552117/10/20075.5982422
1552217/10/20075.5982423
1552317/10/20075.5982424
1552417/10/20075.5982425
1552517/10/20075.5982426
1552617/10/20075.5982427
1552717/10/20075.5982428
1552817/10/20075.5982429
1552917/10/20075.59824210
1553017/10/20075.59824211
1553117/10/20075.5982430
1553217/10/20075.5982431
1553317/10/20075.5982432
1553417/10/20075.5982433
1553517/10/20075.5982434
1553617/10/20075.5982435
1553717/10/20075.5982436
1553817/10/20075.5982437
1553917/10/20075.5982438
1554017/10/20075.5982439
1554117/10/20075.59824310
1554217/10/20075.59824311
1554317/10/20075.5982440
1554417/10/20075.5982441
1554517/10/20075.5982442
1554617/10/20075.5982443
1554717/10/20075.5982444
1554817/10/20075.5982445
1554917/10/20075.5982446
1555017/10/20075.5982447
1555117/10/20075.5982448
1555217/10/20075.5982449
1555317/10/20075.59824410
1555417/10/20075.59824411
1555517/10/20075.5982450
1555617/10/20075.5982451
1555717/10/20075.5982452
1555817/10/20075.5982453
1555917/10/20075.5982454
1556017/10/20075.5982455
1556117/10/20075.5982456
1556217/10/20075.5982457
1556317/10/20075.5982458
1556417/10/20075.5982459
1556517/10/20075.59824510
1556617/10/20075.59824511
1556717/10/20075.5982460
1556817/10/20075.5982461
1556917/10/20075.5982462
1557017/10/20075.5982463
1557117/10/20075.5982464
1557217/10/20075.5982465
1557317/10/20075.5982466
1557417/10/20075.5982467
1557517/10/20075.5982468
1557617/10/20075.5982469
1557717/10/20075.59824610
1557817/10/20075.59824611
1557917/10/20075.5982470
1558017/10/20075.5982471
1558117/10/20075.5982472
1558217/10/20075.5982473
1558317/10/20075.5982474
1558417/10/20075.5982475
1558517/10/20075.5982476
1558617/10/20075.5982477
1558717/10/20075.5982478
1558817/10/20075.5982479
1558917/10/20075.59824710
1559017/10/20075.59824711
1559117/10/20075.5982480
1559217/10/20075.5982481
1559317/10/20075.5982482
1559417/10/20075.5982483
1559517/10/20075.5982484
1559617/10/20075.5982485
1559717/10/20075.5982486
1559817/10/20075.5982487
1559917/10/20075.5982488
1560017/10/20075.5982489
1560117/10/20075.59824810
1560217/10/20075.59824811
1560317/10/20075.5982490
1560417/10/20075.5982491
1560517/10/20075.5982492
1560617/10/20075.5982493
1560717/10/20075.5982494
1560817/10/20075.5982495
1560917/10/20075.5982496
1561017/10/20075.5982497
1561117/10/20075.5982498
1561217/10/20075.5982499
1561317/10/20075.59824910
1561417/10/20075.59824911
1561517/10/20075.5982500
November 16, 2007 at 7:49 am
There are FK index of Id,Date and Value is included column as non-clustered index.
and if we querry any date range it taking that much of time.
October 23, 2007 at 9:18 am
Thanks for reply.
I my table structure is like :
ID int
Date smalldatetime
Value decimal(18,10)
I have got 2 serious problems they are as follows.
For every insert it will taking more time and for...
October 23, 2007 at 6:44 am
Viewing 10 posts - 16 through 25 (of 25 total)