Topics
Started by
Posts
Last post
Hi, I am trying to establish which prescriptions have been prescribed more than once within 2 days …
8 replies
Say I have two tables, Employee and PayRate. Employee has a primary key EmpID which is a foreign ke…
3 replies
I have a view that tracks opportunities and their conversion for each month. I would like a query …
2 replies
Hi Expertz While creating a stored procedure im getting error Msg 141, Level 15, State 1, Procedure…
2 replies
In our database I have a table table1 which has unique id's with about 11Million records. I have an…
1 replies
Hi What is the difference, and which is best between a join filter and a post-join filter. Very s…
3 replies
Hi, I have a stored procedure that is bringing code over form a legacy system. That system had a co…
4 replies
With this, @SomeID is dynamic. you can either pass an ID, or null to return all records. But the bo…
1 replies
Hello, I will explain what I mean here to do: I have a certain trigger who fires when an article i…
5 replies
I have a stored proc which is going to update multiple columns (18 possible columns in total) in a …
3 replies
Hi there, I have some xml stored in a table col of type TEXT, can anyone assist me getting this cor…
2 replies
Hello, I have gone through the script section on this website. I saw code to get the database size…
6 replies
Hello, Again, trying to create a report of certain databases. How would you get the results from s…
1 replies
Hello, Can anyone help me out here? Description: I made a trigger for the following: I have A table…
14 replies
I have the below script that gets does return the desired data but not in the format I would like t…
2 replies
Viewing 15 topics - 1,576 through 1,590 (of 17,082 total)
You must be logged in to create new topics.