Topics
Started by
Posts
Last post
I have a process where I have to copy rows from two tables and update a few columns, one of which i…
5 replies
I'm using one query window and trying to tune the Query, if i runs twice or thrice it's taking Old …
4 replies
Hi, I have data in a table wid 3 columns. Invoice_no, item, price.... example:- Invoice_no item …
4 replies
I have a sproc that performs a multi-table insert. Some of which is done via dynamic SQL. When my…
4 replies
Hi I was wondering if someone could help me. I have a huge table that stores product delivery route…
7 replies
I execute this statement on my PC and it works: CREATE NONCLUSTERED INDEX IX_WorkOrder_ProductID …
12 replies
Hi guys, How to identify the last inserted values in "select Query" Example Query : select * from i…
9 replies
SCENARIO, i have tbl1, tbl2,tbl3 in qa and prod. tbl1(id int identity(1,1),DomainName varchar(250),…
2 replies
I have an interesting query to put together and have a general idea but wonder if someone out there…
81 replies
Whenever I try to convert this - it says "Out of range value" has anyone had any luck converting a…
9 replies
accountno transaction amount ===================================== a1414141 Cr …
13 replies
Hello, I am Inserting data into tables in a large datawarehouse; I want to insert only changed dat…
9 replies
If i was to pass a new Parameter into a Stored Procedure, I would give it a default value. Maybe th…
2 replies
CREATE TABLE [dbo].[TableTemp]( [BASEL_CATEGORY] [varchar](50) NULL, [EC_DRAWN] [numeric](18, 6) …
10 replies
hi friends, ACCTUAL TABLE: account transction amount =============================== A-1234 …
6 replies
Viewing 15 topics - 5,506 through 5,520 (of 10,635 total)
You must be logged in to create new topics.