Topics
Started by
Posts
Last post
I have a "Master" product table that looks like this: table name tWholesaleProduct Then we …
1 replies
I have table with code type , code & Value. I want out in json like this way. In this example C…
2 replies
I'm going to blush when I hear the answer to this. Think I'm over tired. I made this simple examp…
4 replies
I have a simple proc that I suspect is causing intermittent blocking. It takes a customer ID (int)…
7 replies
I have inherited a data warehouse with Type II SCD tables. Each row has an entity_identifier (not n…
3 replies
Hi, I have the following code which will give me a list of every fortnight between two dates howeve…
5 replies
Greetings, I have a need to call a rest api against a resource. It a POST and would like to send th…
3 replies
I have the following statement in my stored procedure SELECT mpe.MeasuringPointEntryID FROM [locati…
3 replies
A good day to all the pros! I am trying to create a sproc to update the value of a table with the i…
3 replies
I'm pretty new a creating JSON output form SQL server. I'm having trouble with carriage returns bei…
3 replies
Hi All, have a long string like below in my column and I need to extract only the date (2021-07-05)…
3 replies
Hi all! I'm a t-sql beginner and have to generate a report as it follows: First_of_Month | Customer…
3 replies
Hi all, I am new to writing SQL code and am wondering the best way to create a new table fro…
5 replies
Trying to use rowversion (Timestamp) in SSIS as a for a high watermark to extract changed data Fail…
9 replies
Hi Community, I have a table which needs to be unpivoted so, that I can have weekly sales & Vol…
5 replies
Viewing 15 topics - 1,246 through 1,260 (of 1,791 total)
You must be logged in to create new topics.