Viewing 15 posts - 2,101 through 2,115 (of 8,416 total)
daveriya (2/27/2011)
hiHow can we check that the consolidated tables were generated correctly?
Is there any tool in SQL?
thanks
What do you mean by a consolidated table?! :unsure:
February 27, 2011 at 5:13 am
mazzz (2/27/2011)
Sorry, yes (am still on 1st coffee of the day...) - 2008 SP2 x64 Standard
No worries. If it's not that bug, another likely candidate is poor cardinality estimation...
February 27, 2011 at 4:59 am
mazzz (2/27/2011)
February 27, 2011 at 3:55 am
Vote for SQLCLR user-defined analytic functions here:
On a separate note, and while I agree that LAG would be problematic for large LAG values (memory requirement), the interested person could do...
February 27, 2011 at 3:40 am
riaan-777462 (2/27/2011)
I think my main problem is figuring out how to generate the weekly interval dates to begin with...
Perhaps this gives you an idea:
DECLARE @Classes
TABLE (
...
February 27, 2011 at 3:01 am
stewart.gadget (2/27/2011)
I have done some googling but I don't see how to clear the result set - is it possible?
I'm afraid not. If something else in the procedure (or...
February 27, 2011 at 2:47 am
xavier.villafuerte (9/18/2008)
Hi, I am looking for a SQL function which converts (not remove) a string containing accented characters into the same string without the accented characters.
I just want to check...
February 27, 2011 at 2:37 am
Extended stored procedures are just links to an external DLL. You can find information about a given procedure using:
EXECUTE sys.sp_helpextendedproc @funcname = N'xp_epoch';
That will show you which DLL the...
February 27, 2011 at 2:30 am
praveensc2003 (2/26/2011)
i am trying to retrieve output data last name using the stored proc...
CREATE PROCEDURE
dbo.DataRetrieval
...
February 27, 2011 at 2:20 am
If the dates are fixed, you can use one of the normal pivot techniques here:
http://www.sqlservercentral.com/articles/T-SQL/63681/
If the dates are not fixed, and the columns need to be generated dynamically, see:
http://www.sqlservercentral.com/articles/65048/
Alternatively, try...
February 27, 2011 at 2:13 am
Duplicate post from 2008 forum.
Answer given at http://www.sqlservercentral.com/Forums/Topic1070081-392-1.aspx:
The SELECT 1/0 returns an empty result set. Execute Scalar only opens the first result, so your code never encounters the error in...
February 27, 2011 at 2:08 am
mazzz (2/25/2011)
I ran sp_lock and it returned 1,500,000 rows (all key locks)
There was a nasty bug with this:
What version and build of SQL Server (e.g. 10.0.4272) are you running there?
Paul
February 27, 2011 at 2:00 am
mwwheeler (2/26/2011)
if you read my post again, youll see that it was prefixed with dbo.
-- Scalar function
CREATE FUNCTION dbo.F() RETURNS INT AS BEGIN DECLARE @i INT = 1; RETURN @i...
February 27, 2011 at 1:48 am
I voted in favour :laugh:
February 27, 2011 at 12:53 am
Simon Davidson (2/25/2011)
If so, does this have any performance benefits over the sub-query I wrote?
Yes. The MAX() OVER(...) construction has to spool results because the group maximum is applied...
February 27, 2011 at 12:50 am
Viewing 15 posts - 2,101 through 2,115 (of 8,416 total)