Topics
Started by
Posts
Last post
Hello Community, If I execute the following query on table name optionsettransposedall_copy: SELECT…
31 replies
Hi, I have a case where a bus driver can be allocated a max of 5 buses. How can I enforce this rule…
2 replies
I'm trying to pull data every 3hrs between 2 dates. I need to just get one record for each machine …
9 replies
Hello Community, I am trying to implement a SQL Script from this link, and pasted below --=========…
13 replies
As above. My employer has allocated $5,000 for my education in this budget and I have to use it or …
5 replies
Hello, I need some advise on how to convert SQL agent jobs run a SSIS package( SQL agent job has so…
3 replies
How to loop the data based on start and end dates below? Declare @StartDate Datetime Declare @EndDa…
4 replies
Hi Community, I have tried refactoring code to execute with CTE as described on this site but I ke…
7 replies
Hello everyone, Needed to help with a merge statement. So based on what I've read about merge stat…
4 replies
Given the following code: DECLARE @data TABLE ( [pk] [int],[identifier] [varchar](32),[date] [d…
1 replies
Hi all! I have to do this 177 times more, and it must be possible to make it a bit more automatic. …
5 replies
Hello Community, Can someone show me how to refactor the following code with CTE's? My platform doe…
1 replies
(1) Sort rows with year column (smallint) and month column (char(3)) == Jan, Feb, Mar, etc. == corr…
39 replies
Hello Community, I'm getting the following SQL error in Azure Synapse Error converting data type va…
2 replies
Hello Community, I'm getting the following SQL error in Azure Synapse Error converting data type va…
16 replies
Viewing 15 topics - 346 through 360 (of 3,090 total)
You must be logged in to create new topics.