Topics
Started by
Posts
Last post
I use ltrim and rtrim in select statement but the output is not trimmed. The variable are all of da…
2 replies
I have a table which has a product code column, a time period column and a count column (and severa…
5 replies
I have two tables. Table A has a.id (int unique), and a.somelongVarChar (varchar(50)). Table B ha…
2 replies
hi every one, I am new in database programming with sqlserver 2000. I am confused to handle data ty…
5 replies
Hi, As far as i can see, there is no way to ALTER the "name" of a table column thru TSQL, though it…
6 replies
I have a view and a table that I want to summarize the values in the view based on an ID field and …
1 replies
I want generate serial no as first column from a SELECT statement. For example: SELECT LastName…
2 replies
SELECT S.WFS_SERVER_ID, S.SERVERNAME, S.IPADDRESS, COUNT(*) AS Expr1 FROM WFS_PROCESS P…
1 replies
Is there a way I can put a table name into a variable and pass it to a command? As it is the comman…
1 replies
I have also seen EXEC sp_bindefault 'dbo'.[Zero], 'Customers.Balance' with no user defined datatyp…
1 replies
I have a View with a clustered index with 4 million rows. It takes about 10 minutes to create this …
4 replies
for some oddball reason I can't "Step" through a stored proc when trying to debug... it just runs..…
9 replies
Hey - Another financial question. ENTITY DAY NAV PERFORMANCE S&P 500 4/1/2003 …
19 replies
I need to keep our 4 processor machine running smoothly. Several statisticians run queries with lot…
2 replies
I have an interesting case about moving value. I really hope that you guys can help me to solve it.…
9 replies
Viewing 15 topics - 14,041 through 14,055 (of 17,082 total)
You must be logged in to create new topics.