Topics
Started by
Posts
Last post
I have created a stored procedure with ALTER PROCEDURE [dbo].[myStoredProcedurel] ( @StartDate A…
2 replies
I have a data warehouse that is refreshed on a nightly basis. I want to be alerted if any records a…
2 replies
I have a user table with multiple column groups that I need to unpivot. Heres the sample source ta…
5 replies
I'm a beginner DBA trying to working with a very old application that is using SS2005. Trying to u…
7 replies
I have a query where I need to get the data joining two tables. Ex I have table a table b. I need c…
1 replies
Hi all, I have the following that product the inventory moving report, based on FIFO. Currently, I'…
7 replies
Hi All, I am stuck with a T-SQL query. I have a table with the following data. IDMedicineStartDat…
15 replies
Hi, Are there any constructs which provide same functionality of cursors Thanks
3 replies
Hi all, I have a table which has multiple rows for the same product: Prod1, Description Prod1, Desc…
17 replies
Suppose there's a 3 number lottery that pays out with 1, 2, and 3 number matches. For simplicity's…
2 replies
Hi i have the following code. i want to do this in a single statement instead of inserting ifrst i…
1 replies
Hi all, The following is meant to use a CTE to recursively output a base node + ancestors. Running …
2 replies
Hi people. I have a big problem. In my db i have 2 field one for the quantity and one for the sign …
4 replies
Guys can you help me by giving technical details on this code: Especially on the bold one. EXEC sp_…
4 replies
Hallo, I have a business need to calculate the effective drivetimes based on tachodata from witch i…
10 replies
Viewing 15 topics - 4,741 through 4,755 (of 12,234 total)
You must be logged in to create new topics.