Viewing 15 posts - 2,521 through 2,535 (of 2,894 total)
John Peter Fernandes (7/18/2010)
...Please advise. If this is possible or not.
...
It is possible.
For more details please follow the advice from the link in my signature.
July 19, 2010 at 6:29 am
Paul, yep, I was not exectly correct in my post, I should just say that it is impossible to create indices explicitly on table variable after its declaration, only implicitly...
July 19, 2010 at 5:47 am
Sagar Sawant (7/19/2010)
Hi,Thanks for reply but some problems are
#2: Indexed temp table allocating resources in temp db as compared to table variable.
...
Who told you that? Is it your guess?
Why you...
July 19, 2010 at 4:13 am
jon pill (7/16/2010)
1.
...
I run this code from SQL server, New > query, I can run once only, if Drop Table is inserted I can run many times
...
2.
...
Else I am opening...
July 16, 2010 at 6:28 am
Brandie Tarvin (7/16/2010)
But I have tested your solution both using a normal update and using a Tally Table. In both methods, it still repeats numbers. So, I'm back where I...
July 16, 2010 at 6:19 am
You need to read about using IDENTITY column in SQLServer...
July 16, 2010 at 5:45 am
jon pill (7/15/2010)
SQL messagingWithout drop table I can only run once
Jon, it is something wrong in a way you executing it.
It looks like you have connection open between execution. It...
July 16, 2010 at 5:06 am
jon pill (7/15/2010)
But I can only run the query once
Msg 2714, Level 16, State 6, Line 1
There is already an object named '#TodayRecords' in the database.
I...
July 15, 2010 at 9:06 am
bteraberry (7/14/2010)
The problem I have with the case statements is that they're a bit ugly to work with (especially when you get more and more) and they're not dynamic...
1. We...
July 14, 2010 at 12:06 pm
bteraberry (7/14/2010)
No left join is needed for this so I wouldn't use one either....
One thing is when LEFT JOIN is not needed. Not trusting to LEFT JOIN (due to political...
July 14, 2010 at 11:43 am
SELECT upvolume,downvolume,TotalTrades
INTO #TodayRecords
FROM DBVaskVbid WITH (NOLOCK) -- are you fully awre of what this hint does?
WHERE BarStamp >= '7/14/2010'
-- do you have huge vlume of records per...
July 14, 2010 at 10:34 am
rdouglas66 (7/14/2010)
Have you tried doing comparisons using the SOUNDEX function?
I have tried, have you? I don't think it will help much in what the OP trying to do...
Soundex is just...
July 14, 2010 at 10:23 am
Chris Morris-439714 (7/14/2010)
jon pill (7/14/2010)
Upvolume and DownVolume
Every day the Totaltrades field starts at zero and...
July 14, 2010 at 10:05 am
try:
SELECT
SUM(CASE WHEN 2006 BETWEEN YEAR(STRTDATE) AND YEAR(ENDDATE) THEN 1 ELSE 0 END) AS Y2006,
SUM(CASE WHEN 2007 BETWEEN YEAR(STRTDATE) AND YEAR(ENDDATE) THEN 1 ELSE 0 END) AS Y2007,
SUM(CASE WHEN 2008...
July 14, 2010 at 9:58 am
Viewing 15 posts - 2,521 through 2,535 (of 2,894 total)