Viewing 13 posts - 31 through 43 (of 43 total)
Hi Daniela..
Check out the new ROW_NUMBER operator. It should give you just the functionality you're looking for.
Hope this helps..
- Ward Pond
blogs.technet.com/wardpond
July 4, 2006 at 11:35 pm
Note that DATEDIFF and DATEADD return INT, not BIGINT; that may well be the limitation you're running into.
Couldn't you just take your "seconds" result, multiply by 1000, and assign it...
- Ward Pond
blogs.technet.com/wardpond
June 28, 2006 at 12:12 pm
Hi..
This is an ideal candidate for a CTE. The sample CTEs in Books OnLine are very good; if you need any help getting your head around this please contact me...
- Ward Pond
blogs.technet.com/wardpond
June 28, 2006 at 12:07 pm
The first alternative would probably be more efficient as an ORDER BY CustID DESC but it's a good call..
- Ward Pond
blogs.technet.com/wardpond
June 27, 2006 at 1:57 pm
Off the top of my head, this sounds like a dynamic SQL sort of thing..
- Ward Pond
blogs.technet.com/wardpond
June 23, 2006 at 2:52 pm
Hi Sathish..
Are you running the Windows Firewall on your SQL Server box? If so, you might want to make sure that sqlservr.exe is not blocked at the firewall.
Hope this helps..
- Ward Pond
blogs.technet.com/wardpond
June 23, 2006 at 1:14 am
Hi Tushar..
You could write a loop and scan all of your records to find the MAX() value, but that will certainly be more expensive than using the MAX() function.
Is this an...
- Ward Pond
blogs.technet.com/wardpond
June 23, 2006 at 1:12 am
Hi Chase..
A technique called "parent axis access" can help you here. You drill down to the deepest layer of the XML and then use ".." parent references to jump back...
- Ward Pond
blogs.technet.com/wardpond
June 21, 2006 at 3:06 pm
Hi Rowell..
You can probably edit the world-time-zone solution posted on my blog, linked below, to address your issue.
Hope this helps..
- Ward Pond
blogs.technet.com/wardpond
June 18, 2006 at 12:18 am
Hello Rowell..
Take a look at the DATEPART function in BOL. That should get you started.
- Ward Pond
blogs.technet.com/wardpond
June 18, 2006 at 12:16 am
Hello..
If you build a temporary structure (table variable or temp table) that contains your hierarchy in the properly sorted order, you should then be able to use that to drive...
- Ward Pond
blogs.technet.com/wardpond
June 17, 2006 at 11:55 pm
Hello Nidheesh..
You should pass your array in an XML document. You can read a journal article here which describes the technique.
Hope this helps! Please write back on my...
- Ward Pond
blogs.technet.com/wardpond
June 17, 2006 at 11:49 pm
Hello Alex..
The syntax for this exists in SQL Server 2005 and can be found at this BOL link: (ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/54ca1d10-5106-4340-bde4-480b83e7e813.htm). Here's an excerpt:
By using cascading referential integrity constraints, you can define...
- Ward Pond
blogs.technet.com/wardpond
June 17, 2006 at 11:42 pm
Viewing 13 posts - 31 through 43 (of 43 total)