Topics
Started by
Posts
Last post
Hello, I am trying to run a query but it does not like the date format in two of the strings. This …
13 replies
I work on sql server 2019 i need to get message value for parts based on feature id and feature val…
6 replies
I need help populate de Fact Table in my DW. i need to sum the quantity and other columns (this is …
1 replies
I am having a problem with a T-SQL stored procedure whose purpose is to insert recurring notes into…
2 replies
Hi, I have problems with generating a sort column which I can use in Power BI: As you can see in th…
11 replies
I have 2 tables: users, traffic. The first table consists of the users information (id, name, user_…
1 replies
Hi friends, I'm trying to create a trigger for audit, I would like to get some help here with after…
4 replies
I'm sorry if this isn't the place to ask about SSIS, but here it is. I have created a project ran …
2 replies
Multiple single quotes in my column's data value is causing my SSIS pkg load to fail. I extract fro…
2 replies
WITH MAXPRedID as ( SELECT MAX(ID) + 1 AS MaxID, SystemID FROM dbo.TableA GROUP BY SystemID) SE…
4 replies
I need a T-SQL script to find, for a given view across all databases (they all have this one partic…
13 replies
Hi In below code it is giving error - column,status is invalid in the Select Statement because it i…
1 replies
I struggle with XQuery and Xpath, I am sure the following is possible but I can't work out how to d…
2 replies
Hi, I have a below query. Instead of average I need to calculate median for the below query. Could …
1 replies
(If {@route}='' then if ({@USRoute}='') then '' else ('('+{@USRoute} + '), ') else if ({@USRoute}='…
3 replies
Viewing 15 topics - 661 through 675 (of 1,784 total)
You must be logged in to create new topics.