|
|
|
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 |
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 How to pass a list of parameters from Select Table Posted by Stephen K. Miyasato at 9/10/2006 10:58:48 PM In most programming languages one usually loops through the customer with a
do while loop
I have a list of patients with ages and sex and usually run a while loop to
do the processing.
While not eof do
end
My intent is convert this to a stored procedure.
The stored procedure takes...more >>
VARCHAR(8000) Does Not Work Posted by hufaunder NO[at]SPAM yahoo.com at 9/10/2006 9:19:44 PM I have a table with a field of type varchar(8000). Unfortunately, I am
not able to store more then approx 3900 characters. This is the error I
get:
Disallowed implicit conversion from data type ntext to data type
varchar, table xxx column yyy Use the CONVERT function to run this
query.
I ...more >>
Database design question Posted by Frank at 9/10/2006 9:02:54 PM I'm trying to design my database to be as normalized as possible but it
would seem that (given my approach) being too normalized can also lead
to delays when querying.
I have a table that contains assignment data (an assignment in this
case is like a case file). Through it's life time the ass...more >>
Selecting minimum between 2 values - Sybase SQL Posted by jmanzano3 NO[at]SPAM gmail.com at 9/10/2006 8:09:46 PM Hi
I'm trying to do an update query but there is one section that I am
stumped with. Unfortunately I do not have an SQL book on hand. I want
to select the minimum value between 2 values. Does anyone know what
command/logic I need to use? By the way, this is for Sybase SQL.
Thanks.
...more >>
What is it that I don't understand about varbinary and datatype co Posted by Dave at 9/10/2006 5:11:02 PM --create a table
IF OBJECT_ID('tempdb..#tmp','u') IS NOT NULL
DROP TABLE #tmp
CREATE TABLE #tmp
(
iID int IDENTITY
,creditcardno varbinary(8000)
)
--add some data
DECLARE @creditcardno varchar(60)
SET @creditcardno='5712345678905555'
INSERT #tmp (creditcardno )
VALUES (encryptbypa...more >>
SQL 2005: Pivot question Posted by Andreas Klemt at 9/10/2006 5:03:55 PM Hello,
I have this
SELECT [1], [2], [3], [4], [5], [6], [7], [8], [9], [10], [11], [12]
FROM
(
SELECT MONTH(logdatetime) AS logmonth, COUNT(*) AS logcount
FROM userlogs
GROUP BY month(logdatetime)
) a
PIVOT
( SUM(logcount) FOR logmonth IN ([1], [2], [3], [4], [5], [6], [7], [8],
[9...more >>
best way to bulk update Posted by kenimojo NO[at]SPAM gmail.com at 9/10/2006 5:02:50 PM Hi I am new to sql server 2005.
I have a flat file with about 10 million rows of data which I need to
use to update the values in a table every day. The table has a single
clustered index which is the column ID. I do not need to insert new
data, just update the data on this table. The file has a...more >>
sproc variable question-newbe Posted by Enterprise at 9/10/2006 1:39:22 PM Hi,
Can I declare variables in sprocs that are to be used just in the
sproc?
The reason I need this is because I need to make 2 insert statements
and I need to store the @@Identities of those inserts so I can make an
insert into another table where the @@identities are foreign keys.
Thanks
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Problem with full text index in farsi language Posted by saeed.shahrivari NO[at]SPAM gmail.com at 9/10/2006 5:05:07 AM Hi
i am trying to use full text index with farsi language .
but simply it does'nt work do you know why fulltext index does'nt work
with farsi?
because i know that full text supports natural languages.
Bye
...more >>
Which function can convert number value to string with lead zero? Posted by ABC at 9/10/2006 12:00:00 AM Which function can convert number value to string with lead zero?
e.g.
1 --> 00001
12 --> 00012
125 --> 00125
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |