|
|
|
January 2003 March 2003 April 2003 May 2003 June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 April 2008 August 2008 |
Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 Katmai Language enhancements? Posted by Kevin at 6/16/2007 9:29:13 PM I'm sure a few Google searches would probably get me this....but does
anyone have a few good links that talk about any new T-SQL language
features in Katmai?
Thanks,
Kevin...more >>
sp Posted by js NO[at]SPAM someone.com at 6/16/2007 2:49:02 PM hi, how to output serval variables and recorsets to client, and how the
client process them? Thanks in advance.
...more >>
manually setting statistics (2000) Posted by codefragment NO[at]SPAM googlemail.com at 6/16/2007 2:09:53 PM Hi
I have a database where I know what the perfect execution plan
should be (ok, probably
not but work with me here) but the optimiser is choosing a different
path.
I want the optimiser to choose a different path. I've read the sql
tuning book but haven't managed to make
it work. I've read ...more >>
Creating a View on a Partitioned Table Posted by Socrates at 6/16/2007 12:34:03 PM I have a partition table with scheme defined on "Month" that I'm trying to
create a view on. My "where clause" for the view is based on a partition;
i.e. 200705, and I get an error msg saying, "invalid statement by 200705".
The "create view" syntax is correct. Is there something else I should ...more >>
Help with inventory query Posted by Kat at 6/16/2007 11:49:17 AM I need to create a query that will tell me how many items I have in
inventory for a store.
I have 2 tables: tblWholesaleOrder (the list of items I've ordered from a
wholesale place), tblRetailOrders (the list of items sold to customers)
tblWholesaleOrder
Id
Product
How Many...more >>
pass parameter to sp Posted by js NO[at]SPAM someone.com at 6/16/2007 11:48:28 AM hi, I want to pass an in clause into a sp,
like this:
CREATE PROC MyProc
@IDs VARCHAR(1000)
AS
BEGIN
SELECT * FROM TB1 WHERE @IDs ???
END
EXEC MyProc ' ID IN (1, 2, 3, 4)'
it said 'Incorrect syntax near 5. How to do that? Thx.
...more >>
installation of both sql server version 2k and 2k5 on same m/c Posted by Hash at 6/16/2007 10:39:23 AM Hi,
I install the sql server 2000 on my machine and then i install the sql
server 2005 on the same machine with new instance name and it installs
successfully. I can see all options of SQL server 2005 BIDS (Business
Intelligence Development Studio) but there is no sql server management
studio...more >>
Get encrypt value from varbinary field HELP PLEASE Posted by yodakt at 6/16/2007 9:36:01 AM I just converted from SQL 7 to SQL 2000 but have one issue.
My login table contains a password field that is a varbinary type. I
encrypted the value by using the encrypt('password') when inserting users
into this table.
How can I see the actual value of the password field. Is there a way...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Quick Question Posted by Peter at 6/16/2007 7:43:00 AM Hello,
It's a quick one. I would like to know how I can tell if the Analysis
services was installed with SQL 2005? I am able to launch the Analysis
Services Deployment Wizard from the Startup menu - does this mean its
installed?
If its not installed, can I add it or do I have to reins...more >>
Performance problem with SELECT f_delimiteredList FROM myTable Posted by Andreas Klemt at 6/16/2007 12:00:00 AM Hello,
I have a table with 3000 rows and when I use the following select,
it takes so long to get a result because of the dbo.delimiteredList
Function.
Is there a solution to do this faster?
SELECT id, dbo.f_delimiteredList(id)
FROM mytable
This is the function which returns a delimite...more >>
MySQL to MS-SQL Posted by mmurczak NO[at]SPAM googlemail.com at 6/16/2007 12:00:00 AM Dear All,
i got a query which i tried already converting with CASE WHEN, but is
not working very good - mean isn't working at all :-)
Can someone please point me in the right direction of converting this
query?
SELECT
w.lngIndex as tippid, s.lngIndex, s.intStatus, v1.strName as Team1,
v2....more >>
SQL LIKE condition using variable and wildcard Posted by Rob at 6/16/2007 12:00:00 AM Hi,
I'm currently creating a web application which uses SQL Server as a data
source.
I want to use the LIKE condition in a SELECT statement using wildcards on a
user supplied variable, but I'm not sure of the correct syntax. For example:
SELECT * FROM Table1
WHERE Column1 LIKE % & User...more >>
Select lowest value from 2 tables Posted by Nic at 6/16/2007 12:00:00 AM Hi,
I have 'results' values in two different columns in DateTime format and I
would like to construct a query that finds the single lowest value (time) in
the two columns. I assume one approach could be to assigning the lowest
value for each column to a variable and compare them.
Is ther...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |