Topics
Started by
Posts
Last post
Hello I am looking to implement a recovery routine for encrypted databases and wanted to know…
1 replies
Hi guysI am struggling to convert this into SQL SELECT sum( case when table1.sale_Id Is Null Andtab…
4 replies
I have to compare source and Target data and MERGE them accordingly. But I have multiple conditions…
4 replies
Hi, We have a job(SSIS package) running in our datawarehouse environment. It usually runs in 4…
5 replies
CREATE TABLE #tblTasks( SortID int, &nbs…
9 replies
Hi Team, I have a table as follows: Start_Date Shop Product Metric_1 Metric_2 Metric_3 0…
6 replies
I ran a trace this morning to pull in some details of some query that is running at 7:30am. i was u…
1 replies
Here is the basic scenario, I have a table that can have site values 1-12, each site can have seq v…
16 replies
All, I am trying to work on a stored proc that would accept DB as a parameter name and then work it…
10 replies
Hi guys, I'm new here. Nice to meet you all.I'm preparing certifications 70-761 and 70-762.I found …
3 replies
I have a procedure inside a schema 'ABC'. inside this procedure in an if else block using left oute…
5 replies
Here is the syntax using in derived transformation : (DATEPART("dw",[Transaction Date]) == 1 ? "Sun…
2 replies
Hi, Can somebody help me with my question below:We have some packages that run every minute a…
4 replies
Hi My Server is hosted in another country so the GetDate() returns the incorrect date for my local …
2 replies
I am trying to pull several fields and get a total count which I was able to do. However, what I re…
6 replies
Viewing 15 topics - 2,131 through 2,145 (of 3,091 total)
You must be logged in to create new topics.