Topics
Started by
Posts
Last post
Hi All, My requirement is like, I have one table in that table I want to change col1's values and …
19 replies
I am running the following SQL Query: SELECT p.* FROM OPENROWSET ('SQLOLEDB', 'Truste…
4 replies
Hi friends, I have a table with two columns FromLocation and ToLocation ,these columns may contain …
6 replies
Hi everyone. Just wondering where is the best place to go to get started writing views in SQL 05. I…
3 replies
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
Viewing 15 topics - 8,881 through 8,895 (of 12,234 total)
You must be logged in to create new topics.