Topics
Started by
Posts
Last post
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
Hi, I have two queries the first shows all students that have attended a course: SELECT DISTINCT t…
2 replies
I am selecting data from a table using Select id = NULLIF(SPACE(0)) etc. I did this because I did n…
11 replies
I've table and rows as follow, declare @t1 table (idx int identity(1,1), TID varchar(20), SeatN var…
4 replies
Viewing 15 topics - 3,871 through 3,885 (of 12,230 total)
You must be logged in to create new topics.