Viewing 15 posts - 61 through 75 (of 117 total)
SELECT “Total“ AS Col1, “ “ AS Col2, “ “ AS Col3, Count([TableA.Column1]) AS [Count_TableA_Column1], 2 as roworder
FROM…TableA INNER JOIN TableB INNER JOIN TableC
UNION
SELECT TableB.Col1, TableB.Col2, TableB.Col3, Count([TCPIP Table].[Term #])...
February 10, 2011 at 8:08 am
Assuming your decimal field is called fieldname, you would do something like below.
SELECT REPLICATE(' ', 12 - LEN(CONVERT(VARCHAR(12),fieldname))) + CONVERT(VARCHAR(12),fieldname)
I haven't tested it, so the Convert syntax might be a...
February 10, 2011 at 7:57 am
OK
This should get you started.
This assumes that a symbol will appear twice, once for the buy side, and once for sell. If either is missing, the row will not be...
February 10, 2011 at 6:25 am
Would you also need to simulate a similar server load? Could SQL Server choose a different plan under different load conditions?
February 2, 2011 at 2:50 am
ta.bu.shi.da.yu (1/26/2011)
Rahul The Dba (1/25/2011)
aaron-403220 (1/25/2011)
Just to ask a foolish question, but is that real data?Are those real names and birthdates?
What will you do with that ????????
Still i am answering...
January 26, 2011 at 3:45 pm
Elliott Whitlow (1/26/2011)I did enjoy his Misson: Earth (I think it was called) series..
Great series of books. Very funny and easy to read considering there were ten of them. Other...
January 26, 2011 at 9:46 am
Without seeing table definitions, I can only suggest:
a)If you are getting duplicates, then you are probably missing a condition on one of your joins.
b)If any of your tables allow...
January 26, 2011 at 7:41 am
Rahul The Dba (1/25/2011)
aaron-403220 (1/25/2011)
Just to ask a foolish question, but is that real data?Are those real names and birthdates?
What will you do with that ????????
Still i am answering your...
January 25, 2011 at 3:29 pm
jts_2003 (1/25/2011)What would be great is an easy way of backing up (and restoring) just a table... maybe in Denali?
I'm pretty sure that this feature was available in 6.5. It...
January 25, 2011 at 5:20 am
A search on this site[/url] will explain the differences encountered. However, as you are aiming for performance, go with the method that runs quickest. If these local temp tables are...
January 20, 2011 at 3:00 am
Ho ww many records are you inserting into the table variable? You might want to consider replacing it with an appropriately indexed temp table.
January 19, 2011 at 3:01 am
All the info you need is here.
HTH BIDI
January 10, 2011 at 7:21 am
shanila_minnu (10/11/2010)
NO we are not doing T log backup.
...and there lies your problem. I would suggest that you take a read of backup & restore concepts to fix your problems....
October 11, 2010 at 6:14 am
Have any changes been made to your server in the last two weeks? Perhaps you have some more software or services running on it. Something must havfe changed if this...
August 20, 2010 at 7:54 am
Inconsistent casing - do I not like that.
Jupiter isn't aligned with Mars, this isn't the dawning of the age of Aquarius...
August 11, 2010 at 7:16 am
Viewing 15 posts - 61 through 75 (of 117 total)