Topics
Started by
Posts
Last post
Hi I need to insert a new line of my output when a condition is met My out looks like ID,Date When …
2 replies
Is there a better/more efficient way to do what the below does? It is replacing several character…
14 replies
Could you please help? My Union all sql query consist of three individual queries that runs quickly…
9 replies
I know that the DATETIME data type is no longer an ANSI/ISO Standard and I have heard the Microsoft…
2 replies
I have a situation where I ran into an old school query that I want to change into a more standardi…
5 replies
By: Jo Pattyn
Hello All, I have a requirement where I am trying to get the active group number. A groupnum can ha…
6 replies
By: ssc_san
We are trying to understand why we are seeing the following occasional deadlock in our test environ…
15 replies
I have a batch process where i have to delete around 75 MIL rows out of 1.3 Billion rows table. A…
6 replies
Hello, All Perhaps a silly question, but may significantly impact the business. We have recently fo…
6 replies
By: Jeff Moden
Hello, I have a dataset of route data (this is just a single route) like below: CREATE TABLE [dbo].…
7 replies
I want to query a table that has a datetime column ([CreateDateTime]) and get the week number for…
21 replies
i try to understand why my procedure do not respect the loop in batches of 10 until the end. i …
7 replies
Hello, I have come across this peculiar problem. This stp is called every begin of the day of the a…
8 replies
Hi, Not sure if this is possible. I'm looking to insert a new row into a temp table if a field on t…
6 replies
Hi all We've got some tables where the field order is .... odd. We designed the tables but, …
21 replies
Viewing 15 topics - 76 through 90 (of 3,056 total)
You must be logged in to create new topics.