Topics
Started by
Posts
Last post
Please help in optimizing the following query. Please also guide me how to optimize the queries. SE…
1 replies
SELECT A.User_Id,A.Pay_Req_Id, substring(E.Cust_ID,11,len(E.Cust_ID)) as CUST_ACID, A.BILL_AMT AS …
8 replies
Hello friends We are using lots of views in our application..its a report kind of thing...so…
2 replies
[using: SQL Server 2005] I can't find any documentation that compares "TOP 1" with the table h…
2 replies
Hey all, is it not possible to group on a case statement? Take the following Im working on, a simpl…
3 replies
I have a view whose resultset is captured and sent via bcp to a mainframe as a flat file. The file …
9 replies
Knights, I just wonder whether I should use IN or other better ways to filter rows based on a const…
8 replies
I have table Employee. It contains the columns : name, phone, addr1 I would like to change the addr…
2 replies
Can anybody make me understand why the following is happening? I had created a customized DTS packa…
1 replies
I've got a table with the date stored in a six digit format such as 732503. I can not figure out h…
2 replies
Hi Everyone, I am tryingto update a column by inserting into data from a query. I am trying to use …
6 replies
Hello, I have the following: create table Test( A int, &n…
5 replies
Hi guys I can insert using OPENROWSET with:: insert into OPENROWSET ('SQLOL…
2 replies
Hi, I'm writing a stored procedure that needs to evaluate account numbers and update another table …
13 replies
Please help me in tuning the following queries used in SP, BEGIN SELECT PAYEEID, PAYEE_NAME ,opt_co…
2 replies
Viewing 15 topics - 6,421 through 6,435 (of 17,082 total)
You must be logged in to create new topics.