Topics
Started by
Posts
Last post
Consider that i have 2 tables like as bellow : The first table contains the table that i want to up…
3 replies
I'm trying to add some more robust error handling to my packages. I'm adding Try/Catch to all my Sc…
1 replies
Hey All, We have a very big table which stores transaction data and it is SCD Type 2 table. Records…
2 replies
I have an SSIS package that's looping thought a folder of Excel files and loading them into SQL Sta…
17 replies
One of the dbmail is getting delivered thousands of time. Same recipient, same subject , same body.…
2 replies
Good Morning. I made a view with select in SQL. I need the negative numbers to be in green color, a…
6 replies
Good Morning I need to subtract : a.[Vendas Ultimo Ano]-2.STKActual and b.[Vendas Ultimo Semestre] …
5 replies
I need to add xml data stored in multiple rows in a table to a XML document by using XML.modify W…
2 replies
Hello, Consider the following table that gives the validity dates of an item : create table #table…
11 replies
I work on sql server 2017 I need to get different of feature value based on partid and feature name…
9 replies
This code works on other 2005 SQL Sever but my 2017 SQL Server gives error. /* Excel Automation*/d…
3 replies
I work on sql server 2017 I have table #partsfeature already exist as below create table…
10 replies
I work on sql server 2017 i have table have dense rank over FeatureString and column store rank inc…
2 replies
It seems that SQL*Server does not have equivalent of Oracle %ROWTYPE ? Unless I am lookin…
24 replies
How we can achive from sql for balance field. I have attacted png file to expain. I will try my bes…
12 replies
Viewing 15 topics - 121 through 135 (of 1,532 total)
You must be logged in to create new topics.