Reply to thread

Message: <blockquote data-quote="ad.hasareli" data-source="post: 14454451" data-attributes="member: 275082">mama gdk try bt wede hari giye nethi nisai help akak illanna hhithuwe plz mata me query(SQL sever 2008) aka liyala dennako loku udwak Machanlamekai wenna onitable 2k thiyenawa loading and billitem  <img src="/styles/default/xenforo/smilies/default/cool.gif"  class="smilie" loading="lazy" alt=":cool:" title="Cool    :cool:" data-shortname=":cool:" />loading table ake lorrystock Column aken billitem table ake quntity Column aken adu karala dennakoo......like this(loading)     (billitem)lorrystock - quntity = result                                                     15          -   10      = 513          -    9       = 4menna create query akaprograming language vb.net <img src="/styles/default/xenforo/smilies/default/yes.gif"  class="smilie" loading="lazy" alt=":yes:" title="Yes    :yes:" data-shortname=":yes:" />[CODE]USE [sp]GO/****** Object:  Table [dbo].[loading]    Script Date: 02/12/2013 08:38:55 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[loading](    [itemcode] [real] NULL,    [itemname] [varchar](50) NULL,    [Loading] [real] NULL,    [unloading] [real] NULL,    [lorrystock] [real] NULL,      [lorry] [nchar](10) NULL,    [date] [date] NULL) ON [PRIMARY]GOSET ANSI_PADDING OFFGOINSERT [dbo].[loading] ([itemcode], [itemname], [Loading], [unloading], [lorrystock], [lorry], [date]) VALUES (5, N'Lemon Puff 100g', 5, 4, 15, N'Lorry 1   ', CAST(0xBB360B00 AS Date))INSERT [dbo].[loading] ([itemcode], [itemname], [Loading], [unloading], [lorrystock], [lorry], [date]) VALUES (8, N'Milk Shorties 80g', 5, 1, 13, N'Lorry 1   ', CAST(0xBB360B00 AS Date))/****** Object:  Table [dbo].[billitem]    Script Date: 02/12/2013 08:38:55 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[billitem](    [itemcode] [real] NULL,    [itemname] [varchar](50) NULL,    [quntity] [varchar](50) NULL,    [lorry] [varchar](50) NULL,    [date] [date] NULL) ON [PRIMARY]GOSET ANSI_PADDING OFFGOINSERT [dbo].[billitem] ([itemcode], [itemname], [quntity], [lorry], [date]) VALUES (5, N'Lemon Puff 100g', N'10', N'Lorry 1   ', CAST(0xBB360B00 AS Date))INSERT [dbo].[billitem] ([itemcode], [itemname], [quntity], [lorry], [date]) VALUES (8, N'Milk Shorties 80g', N'10', N'Lorry 1   ', CAST(0xBB360B00 AS Date))[/CODE]</blockquote>

Verification: Hath warak paha keeyada? (hatha wadikireema paha)

Top Bottom