DWHTechies

nice one Pramod. After a long time, we got some good code. thanks for sharing -----------------------

Here is another website, please register and start practice. If you find any difficulties, please

SQL Architecture: https://www.youtube.com/watch?v=34VqSliEfsc

nice one On Tue, Feb 17, 2015 at 9:00 PM, Pramod Jamadagni <Pramod.J...@indecomm.net>

---------- Forwarded message ---------- From: Chandrra <balach...@gmail.com> Date: Wed, Jan

Hi Guys, Hope all of them doing good. I am looking for job change, could you please refer if there

---------- Forwarded message ---------- From: Amit RS Bansal <a...@amitbansal.net> Date: Sat, Jan

thanks paramod. recently i started working on SSRS and i came across this issue. there were lot of

I think there are only two ways: 1. Let the source and destination have the same name. Then SSIS will

My system suddenly crashed and when restart was complete the SSMS did not asked me to recover unsaved

Hi guys, This issues I think I had discussed earlier. But still I am unable to find the solution in

Hi guys, The standard edition of sql server doesnot support CDC. If your client is using standard

Attached is the solution. Thanks, Pramod Jamadagni, Indecomm global services - Technology division, #

Hi, Attached are ssis pkg, config file and create sql job script to render ssrs reports, Things this

Good one ! DBCC INPUTBUFFER(65) would give you all the statements from the same process but would not

URL: http://msbiblog.wordpress.com/2010/09/24/run-and-export-ssrs-reports-from-ssis-sql-server-2008/

http://www.simple-talk.com/sql/database-administration/handling-errors-in-sql-server-2012/ Thanks,

fyi From: Chandan Kumar Sent: 19 October 2012 12:26 To: Pramod Jamadagni Subject: RE: TSQL - Function

Jokes apart Mr. Ranjan Let me know if there is any other approach. “Jeevo bheda gaNah” mean everybody

Hi, This is the general function to list files and folders returns a table representing all the items

Courtesy : http://www.simple-talk.com/sql/learn-sql-server/introduction-to-change-data-capture-%28cdc

Hello, Job Title: ETL Administrator Location: Warren TX Position Type: Contract Duration: 12+ months

Hi, Script to rebuild all the indexes of all the tables in the database. Replace the correct name

Hi, Pfa … Pramod NOTICE TO RECIPIENT: THIS E-MAIL (INCLUDING ANY ATTACHMENTS) IS MEANT FOR ONLY THE

hi, ------------------------------------- creation of partition table -------------------------------

Hi guys, Some time we may have comma separated values in a single column as below Please refer the

From: Pramod Jamadagni Sent: Friday, August 26, 2011 6:42 PM To: dwhte...@googlegroups.com Subject:

try.. UPDATE L SET product_id = X.si_product_id FROM dbo.AL JOIN BX ON L.product_id = X.

It asks for login ID...what is the one for dwtechies ;-) ? On 8/23/11, Pramod Jamadagni <Pramod.

with UdateProd(P1,P2,C) as ( select product_id,Parent_Product_Id,isnull(Is_Client_prod,0) C from prod