No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
40 Posted Topics
 | Just try this. you increase the size of your database field. I encounter this before when i use the SSIS.  |
| | 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 …  |
| | 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 … |
| | 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 …  |
| | 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 … |
| | 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  |
| | 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' …  |
| | 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) … |
| | 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 …  |
| | |
| | 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 … |
| | [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 … |
| | 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') … |
| | [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 …  |
| | |
| | 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 … |
| | 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 … |
| | 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 … |
| | 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. … |
| | 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 |
| | |
| | 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 |
| | 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 … |
| | 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 … |
| | 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 …  |
| | 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 … |
| | 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 … |
| | 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 … |
| | 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 … |
| | 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 … |
| | Hi guys, Need you inputs on my query. I have an excel file which we have to upload weekly. They want me to make an application using SSRS (MS SQL) . To read the excel file from a certain folder And then make some data entry to inputs like date … |
| | Hi Expert, Guys, i need your help on how to do a script calculating the totalDays using the formula (see below). i have to calculate the totaldays based on different Supplier and Rtype and also if the totalday is less than the warranty period i have to indicate it as … |
| | Hi Guys, I have created a manual SSRS Report. when i click the layout tab it display report layout then i drag the fields from report datasets. i want to set my fields into Table details and i want to insert group but this function is missing or hide. i … |
| | Hi All, I have my table with duplicate records. the duplicate records have the same ESN and Shipdate the difference is the time. there is no transaction in same date. That's why i would like to remove the other records. I need your help guys. How to this. 1. I …  |
| | Guys, Can you help please to compare or check the records from Mytable1 to MyTable2 if exist or found. and i have to count the records with not null. Any idea. you can modify my script. [CODE] elect a.ESN b.ESN FROM MyTable1 as a Left outer join Mytable2 as b … |
| | Hi Guys, Kindly please help me on how to this in scripts. How to calculate and get the average aging based on the Aging period. I could not figure out on how to do this in script. btw, even the format is not like my sample it's okay, unless i …  |
| | Hi All, When I run this script using bulk insert i got an error message but when I try the first 6 records there is no problem. can anyone give the reason and what is the problem? [CODE]Use chrisMartin Bulk Insert SampleTable_Jonel FROM 'c:\planning\ProductRecoveryDataFeedytd_3.csv' --Sheet 1 With ( DATAFILETYPE = … |
| | Hello Guys, I need your help to obtain this records. I could not figure how how to do this in script. I would like to get the RMA # 3. but the records will pull out based on the type equal to 2 and date range.. Here is sample data: … |
| | Hi Guys, I encounter error when i converting the string into datetime. My datetime field is shipdate and returndate. also there is a Null value both of this field. btw, here is my code. can you please modify my code any idea that you can share with me to fixed … |
| | Hi All, Couldnt figure out to obtain the nearest date in query properly. find below the sample. Insert Fsample (ESN varchar(10), optn_type int, auditdate datetime) values('123',2,'2011-1-03') values('123',11,'2011-2-20') values('123',2,'2011-03-02') values('123',2,'2011-4-10') values('123',11,'2011-5-18') 2=shipdate 11=returndate result ESN|Shipdate|returndate 123|2011-01-03|2011-02-02 123|2011-02-20 123|2011-04-10|2011-05-18 Thank you in advance. Jonel |
The End.