Topics
Started by
Posts
Last post
All I need to do is have a column returned indicating if a record exists in a 2nd table. I care no…
3 replies
Hi. Thanks in advance for your help. table name: tbl_Log This table is used by the surveill…
5 replies
My SQL as follow, declare @tEmployee table ( TrnxID int primary key identity(1,1), Nme varchar(100)…
1 replies
Dear All, Below given is the emp table i want to self join. How to findout empno.'s manager name …
4 replies
I have a table created by my code below for your convenience (lame.. I know.. I didn't design it s…
14 replies
Dear All, Lets say below given the script i want to join with CHCM_TO_PSOFT_MAPPING and INBOUND_P…
9 replies
Dear All, --Transaction Table CREATE TABLE #INBOUND_PLM_CHCM (PER_NR INT, [STATUS] INT, SOC_MAPPING…
3 replies
A customer has requested a report of instances where a log entry was not made for a client. A simp…
13 replies
I know how people love T-SQL puzzles, had a more complex request come through, I thought I had it c…
4 replies
Dear All, I have a situation where i need to split an SOC_MAPPING COLUMN with "-" in SQL Server 200…
3 replies
Is it able to add a column to a view or should we drop the existing view and create new view?
18 replies
As i told i am modifying a Stored Procedure. I have added a new column to target table and now i ha…
2 replies
Hi All, We have finally been given the go-ahead to migrate up to SQL Server 2008 (YAH!) and I'm rea…
5 replies
Hi, I generate a report based on data sent by customer from Mon-Fri. Like if a customer sends data …
6 replies
Hi, I just started my career in SQL server , I have wriiten a trigger that inserts data into audit …
4 replies
Viewing 15 topics - 1,201 through 1,215 (of 17,082 total)
You must be logged in to create new topics.