Topics
Started by
Posts
Last post
Hi, I've created a server level DDL trigger which is supposed to log any security changes on the se…
1 replies
I was just looking through one of my queries quickly, and it seems that the application of a window…
1 replies
Hello there I have this query: select [PCode], Count([PCode]) as PNum from [dbo].P_Staging group by…
2 replies
I have a very strange problem. I have 2 views on some data, both have equal number of output field…
3 replies
Hi in the new fangled way of writing SQL (I dont know what the technical term is) you would write S…
3 replies
Hi, I need your help, I'm using this Query select convert(datetime,uploadtime,103) from tbl_00001 h…
24 replies
Does anybody have any challenging sql problems/puzzles... Or if you know any sites would be helpful
5 replies
We have the same databse in three different envionment. The statement below works just fine in two …
4 replies
Hi, I have been using the following code which has been working fine. declare @dt datetime select …
10 replies
Below is a query that runs about 20 mins and returns about 20k rows. Obviously I'd like for it to …
10 replies
Hello there, I've got the following problem and I'm struggling to come up with a solution that work…
6 replies
i have the below script, but it tells me Types don't match between the anchor and the recursive pa…
1 replies
The Query bellow works however it should only return 1 row however it return 126 rows, the first ro…
4 replies
Hi experts, I have issue trying to group data into exhaustive bundles i.e. 1 group/bundle per "link…
14 replies
Arrrrghhhhh Im having a nightmare. I have created some test data CREATE TABLE [dbo].[#Test]( [Att…
2 replies
Viewing 15 topics - 2,791 through 2,805 (of 12,234 total)
You must be logged in to create new topics.