|
|
|
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 Enterprise manager table design Posted by nywebmaster at 11/6/2005 11:38:26 PM I have table with more then 100 coluns . I must change default value
from 0 to 1 in 90 columns. Is there a way to do this in "table design"
in "all in once" metod.
...more >>
To dynamically get the scripts of tables Posted by SQL novice at 11/6/2005 10:22:40 PM I there any system stored procedure to script existing tables?
Something that "All Tasks-->Generate SQLScript..." do
...more >>
Triggering external app Posted by g_hickley NO[at]SPAM hotmail.com at 11/6/2005 9:38:51 PM I have a table with a date time column. I need an external program to
be triggered exactly when the date time is reached. Any suggestions on
the best approach for this?
...more >>
Accounting procedure Posted by Patrice at 11/6/2005 4:44:36 PM Hi,
I have the following procedure that I am trying to run on a data warehouse -
it is supposed to increase or decrease the running premium balance and the
fire fee balance based on the type of transaction, but it seems to just be
increasing the running balance - do you see where I am going...more >>
nvarchar vs varchar Posted by rjax at 11/6/2005 4:40:49 PM I understand nvarchar supports the UNICODE UCS-2 character set whereas the
old varchar datatype does not. For regular applications what is the advantage
of using one over the other?
Thank you for your information.
rjax...more >>
cursor or while loop? Posted by neilmcguigan NO[at]SPAM gmail.com at 11/6/2005 4:00:08 PM hello,
i have 160,000 rows in a table. need to send out an email to somebody
for each row.
currently using a cursor to loop through the rows and calling COM email
component to send the emails
ran low on resources after about 100,000 records
would it be better to do something like this?...more >>
How do I these joins Posted by Mark Moss at 11/6/2005 3:57:03 PM Ladies and Gentlemen
I have the need to show some customer information from the customer table
and Items on order for that customer that are still on sale in a data grid.
This is the easy part.
However I also need to show in Those Items that have not been ordered by
this customer in anoth...more >>
tree select problem Posted by ven at 11/6/2005 2:04:51 PM
hello i have a table with four fields : name_id, name, tree_id, level with
these data:
1 name1 001 1
2 name2 002 1
3 name3 003 1
4 name4 001001 2
5 name5 001002 2
6 name6 001003 2
7 name7 001001001 3
tr...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
update a column populated with a duplicate value Posted by Yaniv at 11/6/2005 12:40:15 PM Hi,
I am facing the following situation:
I need to find the rows containig a varchar column populated with duplicate
values and then update the varchar column with the same value + _1.
Thanks,
Yaniv
...more >>
count rows with a dynamic statment Posted by Sam at 11/6/2005 10:43:51 AM the use of the ahead dynamic statment faill
DECLARE @rows int, @sql char(1000)
set @sql='SELECT ' + @rows + ' = count(*)
FROM tbl'
EXEC sp_executesql @sql
select @rows
what is the right way to do it?
...more >>
Stored procedure > Cursor or other in output Posted by Christian Ista at 11/6/2005 9:53:25 AM Hello,
In a stored procedure, I'd like return the select result as output. Can I
return a cursor ? Is there an another way to do that ? A piece of code is
welcome.
Sorry but I'm new in SQL server, we use Oracle at work.
Thanks,
Christian,
...more >>
TableName as Parameter? Posted by perspolis at 11/6/2005 9:28:04 AM Hi all
I create a sp to get reports..
I want this sp get TableName as parameter and based on this parameter return
the right value..
is it possible to get table name as parameter??
like this :
CREATE PROCEDURE repTest
@TableName as nvarchar(30)
as
select * from @TableName
?thank in ...more >>
Concatenating column values for each uniqueid Posted by madhu2845 NO[at]SPAM yahoo.com at 11/6/2005 9:25:42 AM I have a table like this.
OrderId QueueId Template Subject RecdDtim SentDtim
1 1 TEM1 Sub1 11/3/2005 8:10:10 11/3/2005 9:00:15
1 2 TEM3 Sub2 11/3/2005 10:25:45 11/3/2005 10:40:35
2 3 TEM1 Sub2 11/3/2005 11:45:35 11/3/2005 12:00:00
1 4 TEM2 Sub3 11/4/2005 10:25:00 11/4/2005 10/30:00
2 5 TEM3...more >>
Update some entries of a table with values of a another table Posted by Xavier at 11/6/2005 9:06:10 AM i have 2 tables TableA and TableB with the same structure:
id, artickeName and a table with the id of entries of TableB which must be
updated with the values of TableA
example:
*TableA (table1)
0001 Monitor
0002 PC
0005 memory
.......
1234 Printer
2222 Keyboard
*Table B (table2)
...more >>
size of datafiles in sql Posted by uday at 11/6/2005 8:55:23 AM I have created a database named PMP_v3_0. I didnot specify the maximum size
of the and the size of the database. After the database is created when i saw
the properties of the database through query analyzer, it is 2 MB size and
the option "grow automatically" was clicked. What is the concept ...more >>
Get First Row per Group Posted by Kathy at 11/6/2005 8:36:10 AM I have a data set like this
1 23
1 21
1 25
2 4
2 1
2 3
I wish I had an aggretation function caleld 'first' so that I could do
something like:
select col_1, first(col_2) from table group by col_1
Any idea to implment this logic with a single query? thanks....more >>
Storing Multiple Values in Single Value Posted by Anthony Robinson at 11/6/2005 7:38:02 AM I was hoping someone couild provide some insight into a problem I'm =
trying to solve.
I have a table called SEARCHCRITERIA. It consists of a USERID column and =
a CRITERIA column. Users will be able to search for other users based on =
a set of criteria. There are 5 total criteria a user can ...more >>
Nested Loops vs. Hash Match Posted by Jerad Rose at 11/6/2005 12:45:14 AM I have two tables, Users and UserFile. Users.UserID is a PK, and
UserFile.UserID is a FK to Users. The relationship between Users and
UserFile is one-to-many.
I have the following two queries:
--Query 1
select count(*)
from Users
join UserFile
on UserFile.UserID = Users.UserID
where...more >>
backup on SQL2005EE Posted by Piotr Maciejewski at 11/6/2005 12:00:00 AM I install SQL 2005 Express Edition (upgrade from SQL 7.0 MSDE)
When I execute:
BACKUP DATABASE [Market2000] TO DISK = N'C:\PROGRA~1\MARKET~1\file.bak'
WITH INIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT
I received:
10 percent processed.
20 percent processed.
30 percent processed.
4...more >>
Join 2 tables in one column Posted by perspolis at 11/6/2005 12:00:00 AM Hi all
I have 2 tables Master and details.
I want to return rows from master and catenate of corresponds rows from
details..How can I do that??
I mean I want to return row from master and catenate of rows from details..
thanks in advance
...more >>
Using Functions Posted by Roy Goldhammer at 11/6/2005 12:00:00 AM Hello there
I have some query that runs on many places and it provide parameters.
For this i've created function that return table according to parameters.
If i use the function by select and with join with table, set one of the
fields of the table as paramter for the function it brings me...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |