Posts
 
Reputation
Joined
Last Seen
0 Reputation Points
Unknown Quality Score

No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.

0 Endorsements
~7K People Reached
Favorite Forums
Member Avatar for aplee

To all database genius out there, I hope you can help me with this error I encountered when importing excel file to SQL Server 2005. This is the error: [CODE]Executing (Error) Messages Error 0xc020901c: Data Flow Task 1: There was an error with output column "Description" (21) on output "Excel …

Member Avatar for Sai_421
0
1K
Member Avatar for jovillanuev

I have a query that get the balance for last month and current month balance. I'm using a function inside the view that took more than 30 minutes. May I ask your help guys any idea or approach to speed up the processing or optimize the script it can be …

Member Avatar for ryantroop
0
258
Member Avatar for jovillanuev

Hi Guys, I am using the following codes to connect to MS Access database using vb.net code. I am providing the file path name and directory. This codes work fine in my computer. How can I make this codes as dynamics connection that can run to another computer that no …

Member Avatar for jovillanueva
0
907
Member Avatar for jovillanuev

Hi Guys, I have a requirements to backtrack 2 days if the date fall as Monday. Why? We dont have any transaction from Sunday to Monday at 6:00AM that's why need to backtrack 2 days. i want to share with you my query. if you have any additional idea to …

Member Avatar for ChrisHunter
0
214
Member Avatar for jovillanuev

Hi Guys, Here is my requirements: I need to pullout records based on datetime fields ranges from 12 am in the morning of 2012/6/4 and 12 am in the morning of 2012/06/05. kindly please check my declare parameter for date if it is correct. Thank you in advance. Data: Declare …

Member Avatar for lakhe
0
176
Member Avatar for jovillanuev

Guys, current im using MS SQL 2005. today they will change it to MS SQL 2008 express edition. My question are: 1. can I still create SSRS/SSIS. 2. i have existing RDL,RDS file. still can open it to 2008 express. Thanks. Jonel

Member Avatar for cutepinkbunnies
0
131
Member Avatar for jovillanuev

Guys, Using this query, i got an error. any idea guys. what method should i used for this report. Im using text queries instead of SP. thanks. The variable name '@FromDate' has already been declared. Variable names must be unique within a query batch or stored procedure. Fromdate:'2012/06/01' FromTime:12:00AM Todate:'2012/06/29' …

Member Avatar for BitBlt
0
189
Member Avatar for jovillanuev

Hi Guys, My requirements: How do I get the overall average for the transaction given for every month. My Query: This is the last part of my CTE Query ) Select Partno ,SUM(Case When TransMOnth='January' Then Usage2 else 0 End) As Jan ,SUM(Case When TransMOnth='February' Then Usage2 else 0 End) …

Member Avatar for urtrivedi
0
118
Member Avatar for jovillanuev

Guys, I have a select statement ere one of the field has a negative value. How do i convert it into zero in select statement. ;with CTE as ( Select Itemid ,AVAILORDERED as OnHandQty - just want to convert some negative result into 0 From MyTable ) Select * from …

Member Avatar for Eagletalon
0
62
Member Avatar for jovillanuev

Guys, I tried to reply but i got an error. ERROR MESSAGE: The Message field is required.

Member Avatar for Eagletalon
0
64
Member Avatar for jovillanuev

Hi Forumer's I’m currently having 3 reports (Detail, summary per etamonth and summary per sku). Those 3 results is derived in 1 query ( see my query using CTE) into a single report. so when generate it ito SSRS and export to excel i would like to send it into …

0
60
Member Avatar for jovillanuev

[CODE]Hi Forumer's kindly please optimize my query. I need to separate the colums for statusissue = 0 and statusissue =1 my query create double entry. ]--Sample Table Create Table #Table1 (Itemid nvarchar(10), Datephysical datetime, Statusissue int, Qty numeric(28,12)) --Sanple Data Insert into #table1 (Itemid, Datephysical, Statusissue, Qty) values ('HTC1175','2012-02-14',1,50) Insert …

Member Avatar for Tess James
0
138
Member Avatar for jovillanuev

Hi Forumer's, I have 3 tables, my objective is to compare the returndate from receiptdate and trandate and get the most recent receiptdate or trandate based on returndate. [CODE] Create Table #USPRODUCT (ESN Nvarchar(35), returndate datetime) Insert Into #USPRODUCT (ESN, returndate) Values ('268435458805382753','2011-04-21') Insert Into #USPRODUCT (ESN, returndate) Values ('268435458805382753','2011-08-08') …

Member Avatar for jovillanuev
0
162
Member Avatar for jovillanuev

[CODE]IF OBJECT_ID('tempdb..#Table', 'U') IS NOT NULL DROP TABLE #Table GO Create Table #Table ( CorrectionDate datetime, Origdesc nvarchar(50), Newdesc nvarchar(50), Total int ) Insert Into #Table (CorrectionDate, Origdesc,Newdesc,Total) Values ('2011-08-01 00:00:00.000','RMAWAR','NTF',193) Insert Into #Table (CorrectionDate, Origdesc,Newdesc,Total) Values ('2011-08-01 00:00:00.000','NTF','RMAWAR',108) Insert Into #Table (CorrectionDate, Origdesc,Newdesc,Total) Values ('2011-08-01 00:00:00.000','RMAWAR','Sub Abuse',86) Insert Into …

Member Avatar for adam_k
0
91
Member Avatar for jovillanuev

Hi Forumer's Kindly give me some Benefits to the company for taking SSAS training. I need 3 more...Thanks... JOV

0
82
Member Avatar for jovillanuev

Hi guys, Need your advice. I ask my boss if i could have a training for SSAS and he replied positively, im not connected in IT we are different department but were using MS SQL and we do some analysis and reports using excel and SSRS. im helping other department …

0
88
Member Avatar for jovillanuev

Guys, Need your help. i need to obtain the nearest date from 3 tables. attached my scripst. th problem with this scripts it creates double entry in receipt date with the same transaction specially for this ESN "268435459407885398". [CODE] SELECT p.ESN, p.ReturnDate, s.Receiptdate, e.Shipdate FROM #Product p with (nolock) CROSS …

Member Avatar for jovillanuev
0
153
Member Avatar for jovillanuev

Guys, When i run this sscript i got an error in Where clause? Where should be place this where clause? [CODE] SELECT p.ESN, p.ReturnDate,s.Receiptdate,e.Shipdate FROM USProductRecovery p with (nolock) OUTER APPLY((SELECT TOP 1 Receiptdate FROM ESNSalvReceipts s with (nolock) WHERE ESN = p.ESN AND Receiptdate > p.Returndate ORDER BY Receiptdate …

Member Avatar for BitBlt
0
102
Member Avatar for jovillanuev

Guys, I have an SSRS report with a month to date parameter. the date parameter is set up like startdate 10/01/2011 - enddate 10/31/2011. I would like to run this every first day of the current month through ssrs subscription. I need your idea guys to tis in subscription. thanks. …

Member Avatar for crishlay
0
93
Member Avatar for jovillanuev

Guys, I have those records. how to i removed the first 10 records and the last 2 records(-U)in string. P300-1110-C731-U P300-1110-INCREDIBLE-U P300-1710-DEVOUR-U P300-1710-DROID2-U P300-4410-THUNDRBLT4G-U P333-4110-8530-U Here is the correct Result: C731 INCREDIBLE DEVOUR DROID2 THUNDRBLT4G 8530 Thanks in Advance. Jonel

Member Avatar for adam_k
0
67
Member Avatar for Dumb Fish

HI, I don't know how to get the lastest data form the database. do anyone can give me some exmaples to see how to retrieve the latest 50 data.

Member Avatar for jovillanuev
0
96
Member Avatar for jovillanuev

Guys, what particular drive/folder to stored the text/csv/excel file that the bulk insert will be reading? what if in my local drive is this applicable? or it should be in the shared folder in the server. Thanks, JOV

0
95
Member Avatar for jovillanuev

Hi expert, When i try this script i got 2 esn number with different shipdate and supplierid. were us it should be the latest shipdate should be obtain. Any Idea guys. thanks. [CODE] TABLE1 ESN 123 TABLE2 ESN--SupplierID--Shipdate 123--40----------2011-04-27 123--14----------2011-07-02 Select vp.esn, us.supplierid, us.shipdate --(Select Max(shipdate) from TABLE2 where vp.esn …

Member Avatar for jovillanuev
0
154
Member Avatar for jovillanuev

Guys, I have 2 tables. My objective is to get the information from Table1 and place it to table2. the 2 tables have the same Itemnumber and DefectCode. How could make this in correct scripts cause when i make the script it triple the records. [CODE] TABLE1 ItemNumber---------Price---PO-------Code-Qty P300-1710-DROID-U--302.05--9100962--506--1 P300-1710-DROID-U--302.05--9100962--553--4 …

Member Avatar for moone009
0
107
Member Avatar for jovillanuev

Guys, How to make an scripts if itemnumber have no '-U' then i will place this on the right side while if there's an exising '-U' then no replacement to be done. [CODE] ItemNumber ------------------ P300-4410-DROIDERIS P300-4110-TOUR P333-4410-EVO-U P333-4129-8530PUR-U P333-4170-9330GRY-U P333-4110-8350-U RESULTS: ItemNumber ------------------ P300-4410-DROIDERIS-U P300-4110-TOUR-U P333-4410-EVO-U P333-4129-8530PUR-U P333-4170-9330GRY-U P333-4110-8350-U …

Member Avatar for jbisono
0
107
Member Avatar for jovillanuev

Hi Guys, There are unwanted character in my columns. this character is came from the bulk insert. How tdo i removed this character using scripts. Please see sample below. [CODE] ItemCode--Item Number ---------------------------------------------------------- 123--Phone power on but vibrate is too weak P300-3110-VX8575 124--place a test call. P300-1710-DROID 125--power issues.touchscreen not …

Member Avatar for jovillanuev
0
110
Member Avatar for jovillanuev

Guys, I have records from table 1. the objective is to get the date from Table 2. when i try to use select statement to obtain the records it pull all itemnumber with the same item number in TABLE 2. is there any idea to to this using the result …

Member Avatar for jovillanuev
0
148
Member Avatar for jovillanuev

Guys, I have a Date string. My objective is how to get the Datename. I got this Receivedate as string when I used the Bulk insert. i make the receiptdate as nvarchar because i got an error when i used the bulk insert. [CODE] Select ItemNumber, PurchasePrice, ReceivingPO, Cast(ReceivedDate as …

Member Avatar for jovillanuev
0
163
Member Avatar for jovillanuev

Hi Guys, How do i obtain the nearest shipdate prior to Returndate. here is my sample script. thanks. kindly check my script. the result should be 2011-02-23 [CODE] Table1 ESN--DateReturn 123--2011-03-08 TABLE2 ESN---ShipDate 123---2010-09-28 123---2011-02-23 Select a.DateReturn max(b.shipdate) from Table1 as a left outer join table2 as b on a.esn=b.esn …

Member Avatar for jovillanuev
0
93
Member Avatar for jovillanuev

Guys, Please take a look my script. my object here is to get the most recent date from table 2. what if the recent date from table 2 is less than the date from table 1? [CODE] Table1 Type-Date1 -------- 1-2011-07-16 2-2011-07-16 3-2011-07-10 4-2011-07-10 Table2 Type-Date2 -------- 1-2011-07-06 2-2011-07-07 3-2011-07-01 …

Member Avatar for Pgmer
0
99