Topics
Started by
Posts
Last post
I am working with a system that has audit trail triggers on most of it's key tables. On an INSERT…
2 replies
Hello experts, I'm trying to import some CSV data into a SQL database using PowerShell. But when I …
3 replies
I'm trying to determine why I'm getting several (about 20%) duplicate values in my 'pt.pat_fullname…
6 replies
1) create below mentioned table: Material (materialid, supplierid, tenantid,mcode, is active, creat…
4 replies
HI. Destination DB version SQL 2016, So application does not able to connect database. connection s…
4 replies
Good Morning, I have the two tables customers (joined) and their orders (dateoforder- record perday…
7 replies
I have the following working example: DROP TABLE IF EXISTS consignment_levels; GO CREATE TABLE cons…
5 replies
Hi , I am trying to build a query that will identify 'abnormal' differences in the values column be…
3 replies
Helo friends, hope everyone is doing good. I am working on a project where I have a big fact table …
15 replies
Just want to explore the best way to pick the "first" record from a table that meets certain condit…
5 replies
I have seen several posts on this many of which suggest Pivot. I am trying to mimic a MS Access rep…
14 replies
If I have a TVF (Table Valued Function) that accepts a date as a parameter I can join it to a Regul…
5 replies
I need a random sampling of 1% of a population of last names and spoken languages in a county. The …
1 replies
Can someone help me figure out how to turn this string: ' a=abc;&;b=1;&;c=ddd' into a set o…
5 replies
I have a table that is empty and it should have data in it. I need to find a stored procedure or ta…
36 replies
Viewing 15 topics - 271 through 285 (of 3,062 total)
You must be logged in to create new topics.