Topics
Started by
Posts
Last post
I have a view and the view already was pulling data from quite a few tables but it was still execut…
15 replies
Ok peeps maybe someone can help me out here!! the below QUERY basically is a straight select with 1…
3 replies
I have a select with a few joins producing this results table: 1 Name1 Date1 1 Name1 Date1 1 Name1 …
7 replies
I mean can we execute triggers by directly invoking them as we call the stored procedure or the UDF…
3 replies
Hi, I need to write a SP which is used to find the old email id which we pass and replace with the…
7 replies
I am trying to test performance for a store proc which does many inserts and updates on the tables.…
1 replies
Hi, From with in a query on a parent table, I want to get the number (COUNT) of related rows in a c…
4 replies
hi ... How to find latest executed query in sql server 2000 regards ..
7 replies
CREATE TABLE TEST1 (B1 int PRIMARY KEY,B2 varchar(20)) CREATE TABLE test (A1 int,A2 int REFERENCES …
4 replies
I have a stored proc that I only want one user (and the dbo) to be able to EXECute. This doesn't wo…
1 replies
I have this code: :IF UserInput(100,100,450,350,"Gimme your information!",{"nCLIENTPO,50,200,150,50…
3 replies
I have a table BOM containing two fields, ALLOY and MATERIAL, which contains all possible materials…
3 replies
I am having a brain freeze. I really should know how to do this, but the old thinker isn't working …
11 replies
I'm trying to filter my WHERE clause: WHERE (c.CustomerID = '3942') AND (ol.DetailTableID '6…
5 replies
Dear All, I'm looking for a way to query the table's records absolutely in random in different time…
4 replies
Viewing 15 topics - 9,661 through 9,675 (of 12,234 total)
You must be logged in to create new topics.