Forum Topic

The SQL Thread

arthurjr07 on 30 Jan 15 @ 10:20 AM #

di ba dapat separate table yung payment details?

pag nagbayad, update mo yung balance sa main table tapos at the same time meron ka another table para matrack mo yung payment. dun sa table na yun nandun yung previous balance tapos magkano binayad nya saka yung remaining.
raido_08 on 30 Jan 15 @ 10:18 PM #

@arthurj07

salamat sir. :)
jayromega on 10 Mar 15 @ 05:38 PM #

tanong mga idol paano magedit ng SSIS package na nadeploy na?meron kasi akong alam na add existing package eh parang di naman umuubra pahelp naman TIA
sevenstring on 24 Mar 15 @ 08:39 PM #

hi guys,

need some help... :) paano mag duplicate/copy ng record kung may auto-increment na field sa same table?

right now, meron akong isang table (w/c has 80 columns) na may isang data sa row nya. kelangan kong iduplicate 2000 times (for performance measurement sa windows CE device) yung data na yun.

I tried this query just to try to duplicate even kahit isang beses lang and
INSERT INTO TestResult SELECT * from TestResult where Overall_Result_E = 1;

ang binabato sa aking error is di pwede ma-modify yung auto-increment field.

I tried normal insertion and it works:
INSERT INTO TestResult (Test_Type_E) VALUES (2); (pero yung Test_Type_E column lang ang may laman - as expected)

2nd, pag napopulate ko na yung 2000 results, I need to change one of the label column to a specific incremental order. e.g.

MyLabel-1
MyLabel-2
MyLabel-3
....
MyLabel-2000

I am using SQL Server CE by the way :) thanks in advanced :)
dragonslash on 25 Mar 15 @ 02:40 PM #

if i remember correctly, there is a command so that values can be assigned to identity/autonumber field. for your second question, you may just use the autonumber field to generate the sequence and it needs only a simple string concatenation. or you can use the window functions, such as ranking, partition, row number, something like that, just google.
arthurjr07 on 27 Mar 15 @ 09:53 AM #

rename mo yung table gawa ka ng bagong table, tapos lagay mo lahat ng data na gusto mo dun.

pwede ka rin gumamit ng View

Selet id, column1 from table
UNION
SELECT id+1, column1 from table
UNION
SELECT id+2, column2 from table
.
.
.
arclight24 on 08 Apr 15 @ 08:59 AM #

hi everyone,

i need an IT/ programmer who knows sql, html5 and excel. i need a web based application/ software for my personal use. i\'m offering 10-15k. contact me at [email protected] cheers
jayromega on 20 Apr 15 @ 10:48 AM #

mga sirs question, saan maganda magaral ng SQL administration?tapos kukuha din ako ng certification TIA.
qtjecs on 12 Jun 15 @ 12:08 AM #

question..

meron ako file A.. fld1 is 50a.. tapos file B.. fld1 is 5a, fld2 is 50a..

pwede po ba eto.?

insert into B select \'XXXXX\', A.fld1 from A

..?

salamat po...
arthurjr07 on 19 Jun 15 @ 01:12 PM #

anong file? text file ba yun na csv format?

gawa ka ng table sa sql server/ms access. tapos import mo yung data ng fileA dun sa table na yun

gawa ka ulet ng table tapos import mo yung data ng fileB dun

tapos insert mo yung data ng tableA sa tableB

tapos export mo sa csv yung tableB
pc_repair88 on 22 Jun 15 @ 10:31 AM #

pahelp naman bakit may error?

select bnf_fname as fname,bnf_lname as lname, output_amount as amt from TRANSACTIONS
where amt between 1500 and amt 31166
vanguardwars on 22 Jun 15 @ 10:43 AM #

^ Refer to the example below:

SELECT column_name(s)
FROM table_name
WHERE column_name BETWEEN value1 AND value2;
hakujosh on 22 Jun 15 @ 10:45 AM #

select bnf_fname as fname,bnf_lname as lname, output_amount as amt from TRANSACTIONS
where amt between 1500 and amt 31166

select bnf_fname as fname,bnf_lname as lname, output_amount as amt from TRANSACTIONS
where amt between 1500 and 31166
pc_repair88 on 22 Jun 15 @ 11:00 AM #

select bnf_fname as fname,bnf_lname as lname, output_amount as amt from TRANSACTIONS
where amt between 1500 and amt 31166

select bnf_fname as fname,bnf_lname as lname, output_amount as amt from TRANSACTIONS
where amt between 1500 and 31166

may error boss

Msg 207, Level 16, State 1, Line 1
Invalid column name \'amt\'.
wilmark on 22 Jun 15 @ 11:17 AM #

guys sino ba pwede dito pasetup ko lang yung sql server namin for high availability. pm me lang. log shipping yung gagawin.

-- edited by wilmark on Jun 22 2015, 11:18 AM
hakujosh on 22 Jun 15 @ 11:31 AM #

may error boss

Msg 207, Level 16, State 1, Line 1
Invalid column name \'amt\'.

select bnf_fname as fname,bnf_lname as lname, output_amount as amt from TRANSACTIONS
where output_amount between 1500 and 31166
jayromega on 23 Jun 15 @ 08:21 AM #

^tama ung kay sir hakujosh di ka pwedeng mag condition gamit alias pag ung alias eh kakacreate mo lang within sa query na un error talaga sa \'amt\' un dapat kung ano ung original name nung field un muna ang gagamitin mo.
jayromega on 23 Jun 15 @ 08:21 AM #

^tama ung kay sir hakujosh di ka pwedeng mag condition gamit alias pag ung alias eh kakacreate mo lang within sa query na un error talaga sa \'amt\' un dapat kung ano ung original name nung field un muna ang gagamitin mo.
pc_repair88 on 23 Jun 15 @ 09:43 AM #

may error boss

Msg 207, Level 16, State 1, Line 1
Invalid column name \'amt\'.

select bnf_fname as fname,bnf_lname as lname, output_amount as amt from TRANSACTIONS
where output_amount between 1500 and 31166

clap clap clap..

^tama ung kay sir hakujosh di ka pwedeng mag condition gamit alias pag ung alias eh kakacreate mo lang within sa query na un error talaga sa \'amt\' un dapat kung ano ung original name nung field un muna ang gagamitin mo.

noted sir
jayromega on 25 Jun 15 @ 11:23 AM #

mga sir question, baka meron sa inyong training kit for exam regarding SQL Administration naghahanda kasi ako for exam self study sana ako eh hehe.
jayromega on 26 Jun 15 @ 11:00 AM #

sino na nakatake sa exam nito for MCSA SQL administrator 70-461 : Querying Microsoft SQL Server 2012?kamusta mga tanong diyan mahirap ba?
pc_repair88 on 02 Jul 15 @ 01:13 PM #

patulong paano tamang query d2 pag may kuwit?

ex Eugene O\'Neill
jayromega on 02 Jul 15 @ 06:22 PM #

^try this query:

insert into Person (First, Last)
values (\'Eugene\', \'O\'\'Neill\')

or pwede din ata ganito eh

into Person (First, Last)
values (\'Eugene\', \'O(\\\')Neill\')

-- edited by jayromega on Jul 02 2015, 06:23 PM
brendajadams on 04 Jul 15 @ 12:54 PM #

Days and this was with is your diet change they said eat drink and be merry at the ninety days everybody lost on average seven pounds at Christmas time they always do this study used eggs delay <click here for link> because in the months to December which is coming up quickly know Steve is keen widened to one and half .

http://www.garciniacambogiaprofacts.com/black-label-no/
pc_repair88 on 05 Jul 15 @ 09:00 AM #

^try this query:

insert into Person (First, Last)
values (\'Eugene\', \'O\'\'Neill\')

or pwede din ata ganito eh

into Person (First, Last)
values (\'Eugene\', \'O(\\\')Neill\')

-- edited by jayromega on Jul 02 2015, 06:23 PM

pag select lng boss
jspydrej on 29 Sep 15 @ 09:20 PM #

hi, tanong ko lang kung sino po nakapag exam dito nito

70-462 Administering Microsoft SQL Server 2012 Databases
70-464 Developing Microsoft SQL Server Databases

tanong ko lang baka pede nyo ako bigyan ng tips at mga training materials nyo.
jspydrej on 30 Sep 15 @ 05:10 PM #

up ko lang po
ulysses on 13 Jan 16 @ 04:43 AM #

^ Balak mo mag MCSE-BI?
jayromega on 15 Jan 16 @ 11:17 PM #

@jspydrej

kakatake ko lang ng exam last tuesday for 70-462 haha actually re-take na kasi bagsak ako nung una 1 tanong na lang na pinagpalit ko pa ng sagot tama na namali pa kaya bagsak but this time pasado haha. May alam akong malupit na reviewer ang payo ko lang review pre lang ng review hanggang makabisado mo. Tsaka magtake ka around July - Jan kasi may second shot na kasama para pang fallback plan mo lang will take the 70-461 Querying Microsoft SQL Server 2012 Databases this July or August. PM mo ako
cpjose13 on 20 Jan 16 @ 01:04 PM #

@jayromega

paps pa pm din ng reviewer makapag aral habang wala pa pang exam

kung ok lang sana

Updated Forum Topics

Forum Topic

The SQL Thread