Topics
Started by
Posts
Last post
We have a table setup to track changes that are made to another table, for auditing purposes. How d…
8 replies
Hello folks. I have a question. I have a query that is taking the top XX rows of a table and putti…
2 replies
Hello, I have a rather strange requirement where I need to convert my stored procedure into a norm…
9 replies
DECLARE @DocHandle int DECLARE @XmlDocument nvarchar(1000) SET @XmlDocument = N'<Attributes>&…
5 replies
Hi, Attached is the data workbook. I have listed two tables table 1 has some data. I have to update…
1 replies
Hi: I would be very grateful for your help with the following query. All source and target date fie…
9 replies
Attached the worksheet. I have two views view 1 and view 2 coming from the sql server. My lookup co…
2 replies
Hi All, Please help me on below scenario: I need to write SP which will call from front End to popu…
6 replies
Hello, I'm trying to divide two values from separate rows. Each row is a separate UNION statement.…
1 replies
Hi, I want to set up an automation process where the SQL account gets locked if the user does not c…
6 replies
Hi guys I'm trying to get my head around using the GROUP BY CUBE aggregation. Currently I have this…
1 replies
I have a table that I have created a table and desire to do some basic math by adding a few new col…
1 replies
I have a table with Million plus records. Thanks to the help of the Running Totals article and some…
5 replies
Hi, I am having SP where I am inserting records into table. Now I want to return if result is inser…
5 replies
I have a table which uses multiple joins to create another table but it turns out that the effectiv…
3 replies
Viewing 15 topics - 1,876 through 1,890 (of 10,647 total)
You must be logged in to create new topics.