Topics
Started by
Posts
Last post
I migrated from SQL 2000 to SQL 2005. The query below runs in 3-4 seconds. After I migrated from 20…
8 replies
I have the trigger coded below. Now, if there is no record returned, it must still be trying to ins…
6 replies
Morning, I have a request from one of my clients to produce a report that lists all his client info…
2 replies
Currently I have a CTE that I want to use to delete data from two tables. Do I also have to use a …
4 replies
Ok, so we have two environments which store employee data. Majority of the records match, but quite…
6 replies
I've written a small procedure that loops a table full of TSQL queries and uses sp_executesql to ru…
1 replies
I have a delete trigger on a table named ptChemoOrderDetails that deletes records from the ptEncoun…
2 replies
I have a table of responses to surveys that I am averaging the responses by employee and a category…
4 replies
I cannot seem to get any variant of the following to work, as either a simple or searched CASE. Is…
5 replies
The following query: SELECT vs.[State], vs.CountyName, vs.City, vs.CityID, vs.CityTypeCode, vs.ZipC…
3 replies
When selecting a row then updating, deleting or creating new rows based on the contents of the row …
1 replies
In the trigger below, I am getting an error when deleting > 1 row at a time. I understand that …
6 replies
Is there a way to pull the top 5 for each id? ID Amount 1 4 1 3 1 …
1 replies
I have a table where I want to group the ID in sets of 0-20,21-40,41-60,60-80,81-100 depending upon…
1 replies
Hi! I created an sql function using C# and i deployed on sql server running on 64 bit os. Whenever …
3 replies
Viewing 15 topics - 8,881 through 8,895 (of 12,230 total)
You must be logged in to create new topics.