Topics
Started by
Posts
Last post
Is there a way to take all the rows in a table and create an insert script for each record? Thanks …
9 replies
Insert into tblMembers (
1 replies
In quite a few stored procedures I use the same business logic to calculate prices. So each time th…
10 replies
I have a stored procedure which is hitting the 30-second timeout limit. How can I change it i…
7 replies
How do I convert the following T-SQL query to a SQL 92 statement select * from authors a, titles t,…
3 replies
I recognize that a where clause with something like "WHERE A=B and C=D" you might not be able …
7 replies
Hi! Does anyone know how to store the result of a stored procedure to a variable? I've seen some wa…
3 replies
I have a trigger and it fires properly whenever I update two fields within the table. It does…
9 replies
Just wondering, does anyone here use the RIGHT JOIN operator? Can't you do everything a RIGHT JOIN …
5 replies
Hi I am having a problem in the database (SQL Server 2000) A table is growing quite rapidly and it …
7 replies
This peice of code is Table scanning because os the variables @yesterday_from and @yesterday_to. O…
6 replies
I have a temp table contains data like this: Customer SalesAmount AvailableAmount TotalAvailable A&…
5 replies
I have date data stored as an integer ( e.g. 20040213 = 02/14/2004 ). I need to create a job which …
4 replies
I'm trying to move a login from one server to another... I have copied and modified T-SQL cod…
2 replies
CREATE TABLE [dbo].[PART_SECTION] ( [sPostID] [varchar] (10) COLLATE Latin1_General_CI_AS NOT…
1 replies
Viewing 15 topics - 13,606 through 13,620 (of 17,082 total)
You must be logged in to create new topics.