Topics
Started by
Posts
Last post
I have a table where there is a column called nationality having possible values "US" and "Non -US'…
7 replies
I've read umpteen articles and debates about how to calculate age in TSQL. Seems there should…
6 replies
HiI have created a trigger when a value is inserted to the main table dbo.MVF_Transport_Register, i…
3 replies
Tracking changes in/on Views. Are there any good scripts/documents/advises/tips on Tracking changes…
12 replies
I have a value that I need to change the first characters with the year and the last 2 characters w…
11 replies
I would like to lock a certain row in a table that stores the next available numbers for vari…
14 replies
Hello. I'm trying to generate an XML file from SQL according to a some guidelines, which works fine…
2 replies
I have a table with sample data as shown below. For each ProcessId, I need one row to be selected b…
10 replies
Hi all, My question relates to SQL Server audits, in particular the database audit, what I'd like t…
5 replies
Hi, I am looking for any guidance you maybe able to offer to help grouping of nested data. Currentl…
2 replies
The Update statement in last part of my query (updates columns [Net Losses Prev 12 Months] and [Ris…
4 replies
Hi,This is a little hard to explain, but I'll have a go 🙂We have several tables in 2 databases t…
11 replies
I'm stumped and need the assistance of the wider community to understand what is going on.The datab…
17 replies
I have a little problem on my join condition, my script is:SELECT DISTINCT(Case when bo.u_tpfact = …
3 replies
Good day,I need to insert 7000 records into Table B and also add the same message to all 7000 recor…
1 replies
Viewing 15 topics - 2,116 through 2,130 (of 3,017 total)
You must be logged in to create new topics.