Viewing 15 topics - 9,211 through 9,225 (of 284,087 total)
Topics
Started by
Posts
Last post
Hello, I've been searching and can't find any answers to how (or even whether) this can be done so …
16 replies
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
Viewing 15 topics - 9,211 through 9,225 (of 284,087 total)