Topics
Started by
Posts
Last post
Hello! I have column of datatype 'text' with data like below: <ID=“123” total=“20.00” number=“01…
1 replies
Hi I need help with the SQL query.. requirement is that wherever flag is null and room_cd is single…
4 replies
I'm trying to build some business logic for my ETL which gives a unique ID (Integer in this case) g…
10 replies
Hi all, I am currently having performance issues by populating one of my factless fact tables (fact…
15 replies
I have a DB: CREATE TABLE cabinet ( id_cabinet INT PRIMARY KEY, area INT NOT NULL ); CREA…
2 replies
I have trouble in writing a SQL query. I have a data table with below columns. DataTable 1 id …
1 replies
I have data in a field called user_name that consistently follows this format: (t) Joseph Kelly -14…
6 replies
I have a table [UPSBatchInvNo] with column [BatchDate] formatted as 112621. SELECT CONVERT(varchar,…
5 replies
Hello experts, As has been requested of countless DBAs, I have been asked to do a weekly refresh of…
2 replies
looking for examples on doing a large table cleanup where my attribute value selected has an attrib…
7 replies
Hi, In the report I am working on there are 2 parameters - the first is a drop down list showing co…
2 replies
I have 4 scenarios to cover so I am using the below Merge query in SQL Server 2016. Using Merge que…
2 replies
In SQL Server 2016, While Creating a table I want to populate a computed column that will get a val…
4 replies
I have a result set below from this query: SELECT [CALL_ID], [DATE], [TIME], [CAMPAIGN], [CALL_TYPE…
2 replies
I'm trying to turn this query into something that is more dynamic. I would like it to be able to gr…
4 replies
Viewing 15 topics - 481 through 495 (of 3,091 total)
You must be logged in to create new topics.