Topics
Started by
Posts
Last post
I need to pull the data from two tables called Table1 & Table2. Table1 has following columns:…
7 replies
I've tryed several tsql scripts and none of them have proven to be accurate. If you got a neat scri…
21 replies
hi, this is my derived column expression , SUBSTRING([Column 0],FINDSTRING([Column 0],"PAT",1),FIND…
2 replies
I need to write a script that I carry a variable for the order number. However, that field may be n…
9 replies
How can track database server startups/shutdowns via t-sql and save this information in a table.
6 replies
Coalesce() returns the first non-null value passed to it. Does T-SQL have anything like this but t…
23 replies
Hi All, I am trying to build a procedure for a reporting project that would give the end user maxim…
9 replies
Hi, I have two tables (table A and table B), with a relation 1 to n (n being 0 to max 3). I make a …
5 replies
Hello comunity I need to replace a Cursor with an example using a WHILE and IF condition, for testi…
22 replies
HI, We a have 2 tables.I need to insert values form DAT_STAGE table to DAT_DES with out duplicate r…
9 replies
I am attempting to pull only open tickets from my table. Thing is we have duplicate records with d…
11 replies
Hi, Please suggest me to get the distinct values from below query declare @T as table(id int identi…
11 replies
Hi, Can Anyone help me with this, please I have a Table like this Es Year January Feb…
5 replies
-- I am hoping not to use cursor -- Query is select * from Orders where EmailSent = 0 --I want to …
9 replies
my table need to store timestamp in 1 column, for the record, hwo to create timestamp in sql create…
4 replies
Viewing 15 topics - 4,876 through 4,890 (of 10,636 total)
You must be logged in to create new topics.