Topics
Started by
Posts
Last post
getting unexpected results when using a view with data from a linked oracle DB. Here's the case. …
3 replies
Hi, I wonder if I could get your advice. I've been working on reporting data and I have been asked …
9 replies
Hi, I have a query 'select * from t_srf_rqst where no_id = (select MAX(no_id) from t_srf_rqst)', wh…
6 replies
I have a table that lists the employee and their supervisor For example employee_id &nbs…
1 replies
I keep seeing reference to not using functions because of poor performance. I make extensive use of…
13 replies
I have an assessment table in which answers to various question have been entered into a sql 7.0 ta…
3 replies
i have 3 tables, table names are emp,dept there schema is as under emp=empcode,empname,salary,dept…
4 replies
I was recently tasked with verifying the results of a DTS copy objects package that cloned our prod…
5 replies
Hi, I am wondering if there is any way where a string variable can be passed to a cursor ins…
1 replies
I want to change the datatype from 'text' to 'nText' and the sql is followed: ALTER TABLE SOHEAD AL…
5 replies
We found this while testing, and accidently hitting production instead of development. I have…
6 replies
I am a newbie to SQL and ASP programming. I want to create an ASP program that will allow users to …
15 replies
I noticed that if I do a "select where not in" and the table in the subquery contains a row that ha…
2 replies
I have a query that will use a linked server to the Active Directory to get a list of email address…
3 replies
Hi All. Can some one help me improve the following stored proc (SQL Server 2000). Currently it acce…
2 replies
Viewing 15 topics - 13,546 through 13,560 (of 17,082 total)
You must be logged in to create new topics.