Topics
Started by
Posts
Last post
Experts, If i open QueryAnalyzer, It shows the master database as the default database. I want to c…
6 replies
Hello, the following query generates a lot of IO and pegs the CPU. Select pt3.TRANS_NUM From POS_TR…
14 replies
Hi, I have been involved with a system that uses Julian date instead of Gregorian. The dates are st…
3 replies
Hi, I have a table with 5 columns, 4 of these make up the primary key. The first to third will be …
11 replies
I can't find the answer to this question, although I know that I have asked it before. Appologies …
4 replies
The query below is giving me duplicate results. But I can't think of another way to get the result…
2 replies
I have a stored procedure that prints information to the message window of the QA. I want to save t…
4 replies
Hi, 1) How to find out the current month's first Date ? 2) How to find out the current month's Last…
45 replies
By: Sergiy
Hi I need to turn a column with values 1,2,3 into a recordset (with i've done with a cursor - would…
3 replies
ALTER PROCEDURE importemp @dbname varchar(30) AS begin tran truncate tblemp exec( 'use ' + @DBNa…
10 replies
Hey Guys, I have 10 tables of Individuals info (id, street address, city, state, ...) broken down b…
12 replies
Hi all, I have a question which I am sure has a simple solution; I have a table which contains dupl…
11 replies
By: kwitzell
Greetings folks. I have a simple update trigger for one column in a table. I would like to save …
5 replies
I would like to programmatically drop/truncate and recreate tables from time to time. When a table…
3 replies
I Can't create temporary tables inside functions I don't know why when I write the following…
9 replies
Viewing 15 topics - 3,451 through 3,465 (of 17,082 total)
You must be logged in to create new topics.