Language: SQL
Untitled SQL (31-Jan @ 11:28)
Syntax Highlighted Code
- S1DB003SA 01001œ¾“¾“úeBRYN C MAIR MAESNEWYDD ABERDOVEY GWYNEDD BRYN ØØØØØØØu¾“
Plain Code
S1DB003SA 01001œ¾“¾“úeBRYN C MAIR MAESNEWYDD ABERDOVEY GWYNEDD BRYN ØØØØØØØu¾“
Untitled SQL (17-Jan @ 08:03)
Syntax Highlighted Code
- ©a ov}„‹’™ §®µ¼ÃÊÑØßæíôû %,3:AHOV]dkry€‡Ž•œ£ª±¸¿ÆÍÔÛâéð÷þ!(/6=DKRY`gnu|ƒŠ‘˜Ÿ¦´»ÂÉÐ×Þåìóú$+29@GNU\cjqx†”›¢©°·¾ÅÌÓÚáèïöý '.5<CJQX_fmt{‚‰—ž¥¬³ºÁÈÏÖÝäëòù # * 1 8 ? F M T [ b p iha w ~ … Œ “ š ¡ ¨ ¯ ¶ ½ Ä Ë Ò Ù à ç î õ ü
- [71 more lines...]
Plain Code
©a ov}„‹’™ §®µ¼ÃÊÑØßæíôû %,3:AHOV]dkry€‡Ž•œ£ª±¸¿ÆÍÔÛâéð÷þ!(/6=DKRY`gnu|ƒŠ‘˜Ÿ¦´»ÂÉÐ×Þåìóú$+29@GNU\cjqx†”›¢©°·¾ÅÌÓÚáèïöý '.5<CJQX_fmt{‚‰—ž¥¬³ºÁÈÏÖÝäëòù # * 1 8 ? F M T [ b p iha w ~ … Œ “ š ¡ ¨ ¯ ¶ ½ Ä Ë Ò Ù à ç î õ ü
&
-
4
;
B
I
P
W
^
e
l
s
z
ˆ
–
¤
«
²
¹
À
Ç
Î
Õ
Ü
ã
ê
ñ
ø
ÿ
")07>ELSZahov}„‹’™ §®µ¼ÃÊÑØßæíôû %,3:AHOV]dkry€‡Ž•œ£ª±¸¿ÆÍÔÛâéð÷þ
!
(
/
6
=
D
K
R
Y
`
g
n
u
|
ƒ
Š
‘
˜
Ÿ
¦
´
»
Â
É
Ð
×
Þ
å
ì
ó
ú$+29@GNU\cjqx†”›¢©°·¾ÅÌÓÚáèïöý '.5<CJQX_fmt{‚‰—ž¥¬³ºÁÈÏÖÝäëòùùùùùùùùùmt{‚‰—ž¥¬³ºÁÈÏÖÝäëòù
Untitled SQL (11-Jun @ 01:32)
Syntax Highlighted Code
- SELECT dra.request_activity_id,dra.request_id,dra.node_id,dra.process_id,
- dp.process_description,dra.start_request_state_id,dra.end_request_state_id,
- dra.station_id,dra.request_activity_dttm,dra.user_comment,
- dra.request_activity_user_id,dra.start_balance_qty,dra.end_balance_qty,
- [18 more LINES...]
Plain Code
SELECT dra.request_activity_id,dra.request_id,dra.node_id,dra.process_id,
dp.process_description,dra.start_request_state_id,dra.end_request_state_id,
dra.station_id,dra.request_activity_dttm,dra.user_comment,
dra.request_activity_user_id,dra.start_balance_qty,dra.end_balance_qty,
(dra.end_balance_qty-dra.start_balance_qty) as "transaction_qty"
FROM d_request_activity dra (nolock)
JOIN d_process dp (nolock) ON dra.process_id=dp.process_id
WHERE request_id=1234
SELECT dra.request_activity_id,dra.request_id,dra.node_id,dra.process_id,
dp.process_description,dra.start_request_state_id,dra.end_request_state_id,
dra.station_id,dra.request_activity_dttm,dra.user_comment,
dra.request_activity_user_id,dra.start_balance_qty,dra.end_balance_qty,
(dra.end_balance_qty-dra.start_balance_qty) as "transaction_qty"
FROM D_TRANS_REQUEST_ENTRY DTRE
JOIN D_TRANSACTION DT
ON DTRE.Transaction_Id = DT.Transaction_Id
JOIN D_REQUEST_ACTIVITY DRA
ON dra.Request_Activity_Id = DTRE.Request_Activity_Id
JOIN D_PROCESS DP
ON dra.Process_Id = DP.Process_Id
ORDER BY DRA.Request_Id,dra.Request_Activity_Id
Untitled SQL (11-Jun @ 01:31)
Syntax Highlighted Code
- SELECT dwp.*,spt.process_type_description AS "parent process_typ_description",
- sptc.process_type_description AS "child process_type_description",
- request_state_description, dw.workflow_description
- FROM d_workflow_path dwp (nolock)
- [9 more LINES...]
Plain Code
select dwp.*,spt.process_type_description as "parent process_typ_description",
sptc.process_type_description as "child process_type_description",
request_state_description, dw.workflow_description
from d_workflow_path dwp (nolock)
join s_request_state srs (nolock) on dwp.request_state_id=srs.request_state_id
join d_workflow_node dwn (nolock) on dwn.node_id=dwp.parent_node_id
join d_workflow_node dwnc (nolock) on dwnc.node_id=dwp.child_node_id
join d_process dp (nolock) on dp.process_id=dwn.process_id
join d_process dpc (nolock) on dpc.process_id=dwnc.process_id
join s_process_type spt (nolock) on spt.process_type_id=dp.process_type_id
join s_process_type sptc (nolock) on sptc.process_type_id=dpc.process_type_id
join d_workflow dw (nolock) on dwp.workflow_id=dw.workflow_id
where dwp.workflow_id=1
order by parent_node_id
Untitled SQL (10-Jun @ 20:54)
Syntax Highlighted Code
- SELECT * FROM table1
Plain Code
select * from table1
Untitled SQL (6-Nov @ 19:21)
Syntax Highlighted Code
- -- Ramponierte Plunderkiste Loot Fix; VERY Important...
- SET @ITEM = 16882;
- DELETE FROM `item_loot_template` WHERE `entry` = @ITEM;
- INSERT INTO `item_loot_template` VALUES
- [9 more LINES...]
Plain Code
-- Ramponierte Plunderkiste Loot Fix; VERY Important...
SET @ITEM = 16882;
DELETE FROM `item_loot_template` WHERE `entry` = @ITEM;
INSERT INTO `item_loot_template` VALUES
(@ITEM, 5374, 14, 1, 0, 1, 1),
(@ITEM, 929, 13, 1, 0, 1, 1),
(@ITEM, 1705, 3, 1, 0, 1, 1),
(@ITEM, 1206, 1, 1, 0, 1, 1),
(@ITEM, 1935, 0.03, 1, 0, 1, 1),
(@ITEM, 2567, 0.02, 1, 0, 1, 1),
(@ITEM, 4454, 0.02, 1, 0, 1, 1),
(@ITEM, 2236, 0.01, 1, 0, 1, 1),
(@ITEM, 4446, 0.01, 1, 0, 1, 1),
(@ITEM, 3413, 0.01, 1, 0, 1, 1);
Untitled SQL (20-Apr @ 22:24)
Syntax Highlighted Code
- USE [Comergence]
- GO
- /****** Object: Table [dbo].[CompanyLocationEntityTags] Script Date: 04/20/2010 17:11:50 ******/
- SET ANSI_NULLS ON
- [131 more LINES...]
Plain Code
USE [Comergence]
GO
/****** Object: Table [dbo].[CompanyLocationEntityTags] Script Date: 04/20/2010 17:11:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[CompanyLocationEntityTags](
[Name] [varchar](100) NULL,
[Taxid] [varchar](20) NULL,
[NMLSEntityID] [varchar](50) NULL,
[Phone] [varchar](20) NULL,
[Fax] [varchar](20) NULL,
[Website] [varchar](100) NULL,
[CompanyFormed] [datetime] NULL,
[Entity] [varchar](50) NULL,
[StateOfIncorporaton] [varchar](100) NULL,
[BranchType] [varchar](40) NULL,
[CompanyType] [varchar](40) NULL,
[StreetAddress] [varchar](500) NULL,
[SuiteNumber] [varchar](20) NULL,
[City] [varchar](80) NULL,
[State] [varchar](100) NULL,
[Zip] [varchar](50) NULL,
[County] [varchar](50) NULL,
[OtherStreetAddress] [varchar](500) NULL,
[OtherSuiteNumber] [varchar](20) NULL,
[OtherCity] [varchar](80) NULL,
[OtherState] [varchar](100) NULL,
[OtherZip] [varchar](50) NULL,
[OtherCounty] [varchar](50) NULL,
[OtherAddressVerified] [varchar](20) NULL,
[ErrorsOmissionsCarrierName] [varchar](255) NULL,
[ErrorsOmissionsLimitofLiability] [varchar](20) NULL,
[ErrosOmissionsExpiration] [datetime] NULL,
[ErrorsOmissionsPhone] [varchar](20) NULL,
[IsMaintainingFidelityAndErroOmmisions] [bit] NULL,
[IsHavingMasterPolicy] [bit] NULL,
[VA] [bit] NULL,
[VAApproved] [datetime] NULL,
[VAIdentification] [varchar](30) NULL,
[VALoans] [int] NULL,
[VAAmount] [varchar](20) NULL,
[VAAA] [bit] NULL,
[VAAApproved] [datetime] NULL,
[VAAAIdentification] [varchar](30) NULL,
[VAAALoans] [int] NULL,
[VAAAAmount] [varchar](20) NULL,
[FHA] [bit] NULL,
[FHAApproved] [datetime] NULL,
[FHAIdentification] [varchar](30) NULL,
[FHALoans] [int] NULL,
[FHAAmount] [varchar](20) NULL,
[FHADED] [bit] NULL,
[FHADEDApproved] [datetime] NULL,
[FHADEDIdentification] [varchar](30) NULL,
[FHADEDLoans] [int] NULL,
[FHADEDAmount] [varchar](20) NULL,
[FNMA] [bit] NULL,
[FNMAApproved] [datetime] NULL,
[FNMAIdentification] [varbinary](30) NULL,
[FNMALoans] [int] NULL,
[FNMAAmount] [varchar](20) NULL,
[FHLMC] [bit] NULL,
[FHLMCApproved] [datetime] NULL,
[FHLMCIdentification] [varchar](30) NULL,
[FHLMCLoans] [int] NULL,
[FHLMCAmount] [varchar](20) NULL,
[Brokerremovedfromapprovedlist] [bit] NULL,
[RemovalReason] [text] NULL,
[IsUsingUnderwriting] [bit] NULL,
[IsUsingProcessing] [bit] NULL,
[IsDesktopUnderwriter] [bit] NULL,
[IsLoanProspector] [bit] NULL,
[IsOtherAUSSystems] [bit] NULL,
[IsMonitoringAppraisalVendors] [bit] NULL,
[IsMonitoringRelationshipWithCiti] [bit] NULL,
[IsComplyHomeValuation] [bit] NULL,
[IsComplyWithFHA] [bit] NULL,
[IsAffiliatedBusinesses] [bit] NULL,
[HasAgencyApproval] [bit] NULL,
[HasRepurchasedLoan] [bit] NULL,
[HasSuspendedCompany] [bit] NULL,
[HasUnfavorableFindings] [bit] NULL,
[HasEmployeesAffiliated] [bit] NULL,
[HasEmployeesGuilty] [bit] NULL,
[HasEmployeesIndisciplined] [bit] NULL,
[HasPendingLitigation] [bit] NULL,
[AnswerYesInDisclosure] [text] NULL,
[HasDueDiligence] [bit] NULL,
[HasDueDiligenceComments] [varchar](1000) NULL,
[IsAgreeToNotifyStakeHolders] [bit] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
USE [Comergence]
GO
/****** Object: Table [dbo].[LicenseEntityTags] Script Date: 04/20/2010 17:19:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[LicenseEntityTags](
[NMLSId] [varchar](20) NULL,
[LicenseNumber] [varchar](300) NULL,
[AssociatedLicenseNumber] [varchar](300) NULL,
[LicenseeName] [varchar](150) NULL,
[LicenseState] [varchar](30) NULL,
[Status] [varchar](255) NULL,
[Phone] [varchar](20) NULL,
[Fax] [varchar](20) NULL,
[ExpirationDate] [datetime] NULL,
[LienPositon] [varchar](255) NULL,
[LicenseType] [varchar](50) NULL,
[StreetAddress] [varchar](255) NULL,
[SuiteNumber] [varchar](20) NULL,
[City] [varchar](80) NULL,
[State] [varchar](30) NULL,
[Zip] [varchar](50) NULL,
[OtherStreetAddress] [varchar](500) NULL,
[OtherSuiteNumber] [varchar](20) NULL,
[OtherCity] [varchar](80) NULL,
[OtherState] [varchar](255) NULL,
[OtherZip] [varchar](10) NULL,
[Comments] [text] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
sql query works in phpmyadmin only (22-May @ 18:51)
Syntax Highlighted Code
- -- ---------------------------------------------------------- ---------------------------------------------------------- -------------------------------------------------------- -- Table structure for table `esctime_Pre_Publish_Reminders`
- --
- DROP TABLE IF EXISTS `esctime_Pre_Publish_Reminders`;
- [25 more LINES...]
Plain Code
-- ---------------------------------------------------------- ---------------------------------------------------------- -------------------------------------------------------- -- Table structure for table `esctime_Pre_Publish_Reminders`
--
DROP TABLE IF EXISTS `esctime_Pre_Publish_Reminders`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `esctime_Pre_Publish_Reminders` (
`id` int(9) NOT NULL auto_increment,
`reminder` text NOT NULL,
`back_color` varchar(6) NOT NULL default 'ffffff',
`text_color` varchar(6) NOT NULL default '000000',
`sort_order` int(9) NOT NULL,
`is_strong` tinyint(1) NOT NULL,
`is_emphasized` tinyint(1) NOT NULL,
`is_underlined` tinyint(1) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `esctime_Pre_Publish_Reminders`
--
LOCK TABLES `esctime_Pre_Publish_Reminders` WRITE;
/*!40000 ALTER TABLE `esctime_Pre_Publish_Reminders` DISABLE KEYS */;
/*!40000 ALTER TABLE `esctime_Pre_Publish_Reminders` ENABLE KEYS */;
UNLOCK TABLES;
--
Untitled SQL (8-Jan @ 03:53)
Syntax Highlighted Code
- CREATE TABLE moz_downloads (id INTEGER PRIMARY KEY, name TEXT, source TEXT, target TEXT, tempPath TEXT, startTime INTEGER, endTime INTEGER, state INTEGER, referrer TEXT, entityID TEXT, currBytes INTEGER NOT NULL DEFAULT 0, maxBytes INTEGER NOT NULL DEFAULT -1, mimeType TEXT, preferredApplication TEXT, preferredAction INTEGER NOT NULL DEFAULT 0, autoResume INTEGER NOT NULL DEFAULT 0)
Plain Code
CREATE TABLE moz_downloads (id INTEGER PRIMARY KEY, name TEXT, source TEXT, target TEXT, tempPath TEXT, startTime INTEGER, endTime INTEGER, state INTEGER, referrer TEXT, entityID TEXT, currBytes INTEGER NOT NULL DEFAULT 0, maxBytes INTEGER NOT NULL DEFAULT -1, mimeType TEXT, preferredApplication TEXT, preferredAction INTEGER NOT NULL DEFAULT 0, autoResume INTEGER NOT NULL DEFAULT 0)
Untitled SQL (7-Nov @ 21:58)
Syntax Highlighted Code
- CREATE TRIGGER rssitem_bi FOR rssitem
- ACTIVE BEFORE INSERT POSITION 0
- AS
- BEGIN
- [7 more LINES...]
Plain Code
CREATE TRIGGER rssitem_bi FOR rssitem
ACTIVE BEFORE INSERT POSITION 0
AS
BEGIN
IF (NEW.IDRSSITEM IS NULL OR (NEW.IDRSSITEM = 0) ) THEN
NEW.IDRSSITEM = GEN_ID(GEN_RSSITEM_ID,1);
IF (NEW.GENERATION IS NULL OR (NEW.GENERATION = 0) ) THEN
NEW.GENERATION = GEN_ID(GEN_GENERATION_ID,0);
-- FIXME: supprimer
IF (NEW.idlink IS NULL) THEN
SELECT idlink FROM channel WHERE channel.idchannel=NEW.idchannel INTO NEW.idlink;
END
Untitled SQL (3-Oct @ 20:45)
Syntax Highlighted Code
- SELECT * FROM izon
Plain Code
select * from izon
Untitled SQL (12-Sep @ 22:17)
Syntax Highlighted Code
- SELECT *
- FROM sysobjects
Plain Code
select *
from sysobjects
Untitled SQL (11-Sep @ 16:09)
Syntax Highlighted Code
- SELECT * FROM tblCustomers;
Plain Code
select * from tblCustomers;
Untitled SQL (19-Aug @ 09:49)
Syntax Highlighted Code
- dfafda
- sadfdsaf
- asdfaf
Plain Code
dfafda
sadfdsaf
asdfaf
Untitled SQL (14-Aug @ 00:31)
Syntax Highlighted Code
- SELECT * FROM users AS nubs WHERE sql_skill > 0
Plain Code
SELECT * FROM users as nubs WHERE sql_skill > 0
Untitled SQL (5-Aug @ 20:28)
Syntax Highlighted Code
- SELECT * FROM tbtexto
Plain Code
select * from tbtexto
Untitled SQL (29-May @ 18:16)
Syntax Highlighted Code
- SELECT * FROM DUAL
Plain Code
SELECT * FROM DUAL
Untitled SQL (24-May @ 00:56)
Syntax Highlighted Code
- 45456465465456423159489
Plain Code
45456465465456423159489
Untitled SQL (17-May @ 05:51)
Syntax Highlighted Code
- SELECT * FROM TABLE
Plain Code
Select * from table