Topics
Started by
Posts
Last post
Is there a better way to write the following query in terms of performance without adding any index…
2 replies
Dear all, i need to generate the locations id depends up on the state as well as track number is …
8 replies
Below is my stored procedure that creates a temp table then based on a different table it creates n…
9 replies
I need some help creating a query in SQL Server 2005 that will give me the first (TOP 1 is fine) gr…
10 replies
Hi, I have only been using SQL for a short time and hoping for some help/guidance. I have a datase…
5 replies
The Stored Procedure has a date parameter. myProc should run in a loop while the date is between '2…
6 replies
I've table and rows as follow, declare @t1 table (idx int identity(1,1), TID varchar(20), SeatN var…
1 replies
I have an issue where I need to 'Flag' based on a test value between 1 and -1. My data is in date …
6 replies
Does anyone have suggestions on the most efficient way to get the following data from one table int…
5 replies
When I run this stored procedure: USE [EliteBuild] GO /****** Object: StoredProcedure [dbo].[sp_Gr…
5 replies
I have a client that has 5000 customers and in the database each customer has a table. dbo.Customer…
10 replies
How can I remove the last semi colon from the list of names that gets created? I want the semi colo…
4 replies
I'm trying to figure out how to display the original parent id from records that have an id linking…
2 replies
I created an INSERT TRIGGER that would perform some other process with the INSERTED data, affecting…
1 replies
Hi, Lets figure 2 tables, simplified from the real case, with inserts to create dummy data: -- Des…
8 replies
Viewing 15 topics - 3,871 through 3,885 (of 12,234 total)
You must be logged in to create new topics.