Viewing 15 topics - 8,911 through 8,925 (of 283,916 total)
Topics
Started by
Posts
Last post
I'm having trouble getting this to fit into a usable CTE (the below is returning the expected data …
15 replies
We have a SSIS package that runs a web service that is a vendor's API. Basically the process it pas…
20 replies
there are LineNo, itemNo and qty fields in one table, I want to the accumulative qty (totalQty) for…
11 replies
Hi Everyone Is there a script that can output a FULL audit of my SQL instance. As in script out: Lo…
6 replies
I'm trying to get rid of all backup messages in my SQL logs and I was able to successfully suppress…
8 replies
I have a user defined function that just needs a little tweaking. The first block of code used in a…
1 replies
Hello: I got a question from upper manager and he wanted to know why DBA should install SQL Server?…
23 replies
As mentioned in the link below, https://www.codemag.com/article/0605061/SQL-Server-2005-Query-Notif…
1 replies
I have inherited a data warehouse with Type II SCD tables. Each row has an entity_identifier (not n…
3 replies
Hi if Month(@frDate) < 4 begin SET @ytdfrDate = (SELECT CONVERT(DATE, dateadd(y,-1,@frdate + '-0…
2 replies
Hi I have @frdate parameter. In below condition i want to Set date as '01/04' and subtract 1 year f…
28 replies
Hi I have below Stored Procedure . I want YTd column value also. If user enters @frDate = 01/01/202…
2 replies
Ahoi, i have been looking at the different relationship options the Multidimensional Model offers, …
3 replies
Hello All, I need your help in building this query. create table #memb (ID int, eff_dt date, term_d…
8 replies
Hi All, I am trying to figure out if it is possible to send SSRS subscriptions via email directly t…
2 replies
Viewing 15 topics - 8,911 through 8,925 (of 283,916 total)