Topics
Started by
Posts
Last post
Dear all, I have the following table and data. CREATE TABLE TMP ( POST_DATDATETIME, RETL_KY_FIID …
3 replies
I'm trying to implement a table in my database that supports the creation of unlimited categories v…
2 replies
Hi All please help if you can I want to evaluate the two most recent rankings for each ID. My selec…
2 replies
Hi New to this so bear with me! I have a SQL server 2005 install. That contains a 3 databases used …
8 replies
1. begin tran tran1 go 2. update Person.Contact set LastName = 'tran1' where FirstName = 'Gustavo' …
4 replies
I have a table called X there are three columns, code int group varchar number int I want a report …
8 replies
Hi All, We have a table which has columns empid,plan,physid. We updated table with new plan here is…
4 replies
In SQL Server 2005 how to get sysdate - 1 year
2 replies
CREATE OR REPLACE TRIGGER TR_UPDATE_EMRMedicationsInfo AFTER INSERT OR UPDATE OR DELETE ON EMRUNCO…
4 replies
I would like to print to a specified text file, e.g. "c:\Temp\tmp.txt", using T-SQL. However, I ca…
2 replies
I have a polling/processing job that runs every 5 minutes. Currently the job can take 5 seconds to …
2 replies
We have a column with a "Text" datatype in a SQL Server 2000 table. How can I read the whole data f…
4 replies
Hi, SELECT a,b FROM #temp GROUP BY a,b ORDER BY a,b Suppose I have 100 columns in my table and I ne…
6 replies
I'm developing my first Service Broker app and was wonder what people are using message types for. …
1 replies
Hi All, How to use a column alias in an expression? Example:- ------------------------------------…
3 replies
Viewing 15 topics - 1,636 through 1,650 (of 4,155 total)
You must be logged in to create new topics.