select table_id, item_guid, oplsn_fseqno, oplsn_bOffset, oplsn_slotid

from [IBOS].[sys].[filetable_updates_2105058535] with (readpast) order by table_id

----------------------------------------------------------------------------

exec sp_reset_connection

----------------------------------------------------------------------------
SELECT ScheduledReportID,
Name,
CurrentState,
Triggers,
NextRunTime,
LastRunTime,
ActionType,
ScheduledReport,
LastRunResult,
WeekInterval,
GETDATE() AS [ServerTime]
FROM tblScheduledReport
WHERE NextRunTime BETWEEN DATEADD(MONTH,-6,
GETDATE()) AND DATEADD(MINUTE, 15, GETDATE())

----------------------------------------------------------------------------

exec sp_reset_connection
----------------------------------------------------------------------------

SELECT [CurrencyString], [ShortDateFormat], [LongTimeFormat], [ThousandSeparator],

----------------------------------------------------------------------------

exec sp_reset_connection

----------------------------------------------------------------------------

SELECT X.[TransactionDateTime]
,[Link] [Device]
,X.[Description] [Job]
,[Link] [Fullname]
,[Link] [Department]
,[Link] [Item]
,[Link] [Itemgroup]
,[Link] [Costcenter]
,[Link] [Purse]
,X.[Quantity]
,X.[Amount]
FROM [tblTransaction] X
INNER JOIN tblStation S ON [Link] = [Link]
INNER JOIN tblDepartment D ON [Link] = [Link]
INNER JOIN tblItem I ON [Link] = [Link]
INNER JOIN tblLedger L ON [Link] = [Link]
INNER JOIN tblTender T ON [Link] = [Link]
INNER JOIN tblTenderGroup AS tg ON [Link] = [Link]
INNER JOIN tblItemGroup G ON [Link] = [Link]
 INNER JOIN tblCustomer C ON [Link] = [Link]
INNER JOIN ( SELECT SessionID, TerminalID, TenderID, PurseSubTypeID FROM (
SELECT TenderID, SessionID, TerminalId, PurseSubTypeID
FROM tblTransaction
WHERE (TransactionDateTime BETWEEN CONVERT(DATETIME, '2017-01-01 00:00:00',
120) AND CONVERT(DATETIME, '2017-01-31 23:59:59', 120))
AND StationID IN (-2136292847, -2098786404, -2060532501,
-2038647527, -1994989492, -1984465832, -1972884326, -1962416432, -1908132744,
-1854491705, -1803560340, -1800940529, -1795729584, -1781315333, -1776369529,
-1766435717, -1753615980, -1747058144, -1722332446, -1643071254, -1613215997,
-1598233260, -1579806796, -1525319943, -1510667689, -1502987441, -1494802811,
-1472437314, -1457899745, -1449711889, -1436663039, -1425578226, -1420646983,
-1406674735, -1396684466, -1380726178, -1320008169, -1300948653, -1287671256,
-1277712707, -1254866883, -1213970701, -1208008092, -1164480510, -1094378677,
-1092953510, -1072415878, -1056416618, -1030240230, -1021524936, -1018638938,
-1016296058, -984877260, -936483987, -896813346, -855882605, -849405065,
-790551840, -753420878, -737942821, -728190532, -649435902, -622849693, -612789891,
-603428415, -573051930, -533387919, -473325622, -438790898, -421582354, -418379524,
-394682835, -391087440, -378706775, -339927121, -338124642, -277943471, -276889940,
-270200269, -202445040, -160192768, -140141505, -122126980, -122055482, -75170980,
0, 41129498, 43124708, 102194851, 108983324, 236032045, 241947397, 258981388,
313595561, 333732423, 348424507, 356961347, 442674879, 497285780, 524400785,
530506611, 544000131, 552882306, 669945429, 693836488, 756433617, 780130951,
876798824, 900508610, 907303116, 919274647, 973747070, 979443343, 1039908298,
1072712351, 1080125748, 1096887904, 1116086598, 1118875312, 1123851030, 1133865537,
1176471782, 1191330116, 1215564089, 1254504458, 1350592684, 1377452458, 1399490982,
1418709668, 1445127768, 1469326625, 1483482135, 1490425378, 1495262347, 1540058070,
1568216184, 1587047805, 1603445764, 1609843002, 1652948958, 1683102541, 1695460725,
1751187050, 1767365620, 1780311298, 1816939377, 1838218248, 1842242057, 1842679124,
1895240295, 1919902447, 1977827169, 2020064526, 2055989942, 2066478368, 2072255949,
2074636364, 2078277429, 2116790620)
AND StoreID IN (0, 1)
AND TransactionTypeID IN (36,37)
AND (TenderID <> 0)) Temp
) X1 ON [Link]=[Link] and [Link]=[Link] and
[Link]=[Link]
INNER JOIN tblPurseSubType P ON [Link] = [Link]
WHERE (TransactionDateTime BETWEEN CONVERT(DATETIME, '2017-01-01 00:00:00', 120)
AND CONVERT(DATETIME, '2017-01-31 23:59:59', 120))
AND [Link] IN (-2136292847, -2098786404, -2060532501, -2038647527,
-1994989492, -1984465832, -1972884326, -1962416432, -1908132744, -1854491705,
-1803560340, -1800940529, -1795729584, -1781315333, -1776369529, -1766435717,
-1753615980, -1747058144, -1722332446, -1643071254, -1613215997, -1598233260,
-1579806796, -1525319943, -1510667689, -1502987441, -1494802811, -1472437314,
-1457899745, -1449711889, -1436663039, -1425578226, -1420646983, -1406674735,
-1396684466, -1380726178, -1320008169, -1300948653, -1287671256, -1277712707,
-1254866883, -1213970701, -1208008092, -1164480510, -1094378677, -1092953510,
-1072415878, -1056416618, -1030240230, -1021524936, -1018638938, -1016296058,
-984877260, -936483987, -896813346, -855882605, -849405065, -790551840, -753420878,
-737942821, -728190532, -649435902, -622849693, -612789891, -603428415, -573051930,
-533387919, -473325622, -438790898, -421582354, -418379524, -394682835, -391087440,
-378706775, -339927121, -338124642, -277943471, -276889940, -270200269, -202445040,
-160192768, -140141505, -122126980, -122055482, -75170980, 0, 41129498, 43124708,
102194851, 108983324, 236032045, 241947397, 258981388, 313595561, 333732423,
348424507, 356961347, 442674879, 497285780, 524400785, 530506611, 544000131,
552882306, 669945429, 693836488, 756433617, 780130951, 876798824, 900508610,
907303116, 919274647, 973747070, 979443343, 1039908298, 1072712351, 1080125748,
1096887904, 1116086598, 1118875312, 1123851030, 1133865537, 1176471782, 1191330116,
1215564089, 1254504458, 1350592684, 1377452458, 1399490982, 1418709668, 1445127768,
1469326625, 1483482135, 1490425378, 1495262347, 1540058070, 1568216184, 1587047805,
1603445764, 1609843002, 1652948958, 1683102541, 1695460725, 1751187050, 1767365620,
1780311298, 1816939377, 1838218248, 1842242057, 1842679124, 1895240295, 1919902447,
1977827169, 2020064526, 2055989942, 2066478368, 2072255949, 2074636364, 2078277429,
2116790620)
AND [Link] IN (-2147034307, -2146613782, -2145478138, -2143463716,
-2142643987, -2141088489, -2140934752, -2140611096, -2139625878, -2139234593,
-2135680703, -2134893927, -2133383153, -2132942359, -2132934543, -2129436082,
-2129322438, -2127428944, -2126636286, -2125075965, -2125049365, -2122687952,
-2120673276, -2120598498, -2116586344, -2112833906, -2111664270, -2108655843,
-2106166673, -2105831770, -2104528004, -2100167426, -2100158383, -2094506267,
-2087563850, -2086904717, -2085657366, -2081360839, -2081113123, -2080411292,
-2079486031, -2078469704, -2078369561, -2077254752, -2076456715, -2073593319,
-2072675760, -2062742761, -2060703647, -2056016089, -2055520941, -2055377053,
-2053104213, -2052470456, -2048260513, -2047864449, -2047669684, -2045711520,
-2043490028, -2043249054, -2041918150, -2040471789, -2039921656, -2039573989,
-2037929824, -2031391405, -2030984126, -2028231804, -2028220886, -2026751426,
-2024230186, -2022351720, -2018495304, -2017535279, -2014446367, -2011979271,
-2011783238, -2011761645, -2011037655, -2010535402, -2009491625, -2007562462,
-2006600088, -2003965223, -2003646378, -2002896440, -1999129683, -1998015954,
-1994070992, -1993633056, -1991851631, -1990846401, -1990062253, -1985870396,
-1982392014, -1980411400, -1980380658, -1976565568, -1973864819, -1972434753,
-1971226089, -1970995401, -1969606725, -1968382557, -1967333590, -1966007586,
-1962116793, -1960535548, -1958752352, -1956304036, -1955257638, -1955200035,
-1954854119, -1954696596, -1952025660, -1949996413, -1949826041, -1947564851,
-1947275530, -1945820155, -1945237429, -1940905438, -1932887691, -1932147821,
-1930792208, -1930780506, -1930121088, -1928673069, -1924236421, -1922746056,
-1921121288, -1919676249, -1919610455, -1916508420, -1916037104, -1915855927,
-1914851133, -1910527574, -1909265035, -1908764308, -1906494176, -1905715187,
-1903077747, -1899128653, -1898448888, -1898039903, -1896972221, -1895336807,
-1894224581, -1892625642, -1892106353, -1888215128, -1887513366, -1887086393,
-1887051910, -1886595865, -1884365592, -1881661067, -1881286353, -1879609096,
-1875370847, -1873506398, -1873382531, -1870253596, -1866808493, -1865789012,
-1865541023, -1864877121, -1864256217, -1864157876, -1863914749, -1861804854,
-1861735427, -1861594279, -1858820093, -1858173113, -1849452118, -1849051920,
-1845209371, -1843727427, -1842316357, -1842010973, -1841043308, -1839157189,
-1837887532, -1837320000, -1837079412, -1832385364, -1831379338, -1828557294,
-1826681247, -1825421959, -1817952990, -1815401802, -1809423223, -1809418184,
-1808852507, -1806113923, -1806047615, -1805057538, -1802316025, -1801074908,
-1800407412, -1795977061, -1794738711, -1792393975, -1790168815, -1789035621,
-1788296752, -1787454881, -1786968370, -1786338374, -1782582219, -1782412948,
-1782311811, -1781155252, -1780049211, -1776758716, -1775767286, -1775651657,
-1775027493, -1771894792, -1770511297, -1768814243, -1766696499, -1765551575,
-1765492575, -1763028418, -1763005143, -1762811182, -1758113464, -1754550652,
-1750734693, -1750315055, -1749416076, -1748592940, -1746665064, -1745341687,
-1742046072, -1740908302, -1739305733, -1738768254, -1737456309, -1736768524,
-1735937427, -1735100454, -1734326352, -1734285968, -1733672924, -1732501409,
-1732082403, -1731795987, -1730265888, -1727327054, -1726320528, -1726202075,
-1725501340, -1724784232, -1721216514, -1719218935, -1718661822, -1714837285,
-1713914145, -1711508931, -1709049079, -1705585464, -1702436720, -1699747143,
-1699659984, -1697743870, -1697097829, -1696675213, -1695618721, -1695408779,
-1693645510, -1692609409, -1692426720, -1689179792, -1684507271, -1682889533,
-1682527680, -1679958318, -1679947038, -1679502641, -1679337875, -1679323124,
-1677562877, -1676927265, -1675137043, -1674609221, -1672713401, -1669270434,
-1669024798, -1668551353, -1667531661, -1662335318, -1660832497, -1659226018,
-1656507187, -1655247505, -1654576586, -1654271579, -1652540535, -1650365197,
-1646579248, -1644571601, -1643169287, -1642408468, -1641824299, -1640223233,
-1639860965, -1637948545, -1635193100, -1632920414, -1632058977, -1631365277,
-1631113641, -1629998531, -1629483727, -1626326496, -1625769349, -1625212229,
-1625208584, -1624875769, -1624532799, -1623709789, -1615546150, -1612464693,
-1612204735, -1611072213, -1610568022, -1608851006, -1607831185, -1603459769,
-1601305845, -1599675718, -1597619020, -1597079564, -1595416400, -1594055678,
-1591961429, -1591231848, -1590586633, -1589510435, -1586085633, -1585616123,
-1584304925, -1582959951, -1581250305, -1580892656, -1579626296, -1579342533,
-1577432664, -1575086771, -1574382456, -1570076418, -1568781605, -1568592886,
-1567593860, -1563233694, -1560482189, -1560472764, -1556437411, -1556149340,
-1555936008, -1555933040, -1555895743, -1555306360, -1553683011, -1552335088,
-1547865145, -1545508244, -1544645897, -1541856414, -1541068176, -1540203208,
-1539423353, -1537943024, -1533694141, -1531176569, -1530812987, -1525158791,
-1523422237, -1522355889, -1522297350, -1522284993, -1521144579, -1520596098,
-1516910649, -1516905514, -1515217204, -1513412622, -1509544990, -1508337012,
-1507985782, -1505514276, -1502640866, -1499669025, -1499554329, -1499399129,
-1497536430, -1497391993, -1496850926, -1496768735, -1495681477, -1495563132,
-1494450286, -1491300169, -1490059984, -1488016787, -1486199522, -1485345810,
-1485241231, -1482997462, -1482566097, -1481437985, -1480049458, -1478133456,
-1476992355, -1475871641, -1470746303, -1469877389, -1469434201, -1466521658,
-1464748139, -1462886562, -1459230711, -1458529051, -1458323799, -1457760514,
-1455567882, -1453957079, -1451332251, -1450122515, -1444173214, -1442846636,
-1442506121, -1441959040, -1441280559, -1440795850, -1440544839, -1439570930,
-1439014450, -1437223532, -1436393567, -1436305944, -1435965037, -1435743808,
-1435520538, -1432549990, -1430682000, -1430181216, -1430125054, -1429312277,
-1428163588, -1426492653, -1426413480, -1426078717, -1421185660, -1418933161,
-1417916363, -1417528488, -1417389925, -1416549064, -1415186935, -1414697773,
-1408605017, -1408427112, -1408216544, -1408019426, -1406220283, -1404316732,
-1402358171, -1397502441, -1396855826, -1393250383, -1392924231, -1384800453,
-1384530648, -1384295835, -1383817629, -1381555027, -1380958307, -1380410954,
-1379993762, -1376976497, -1376578882, -1375422453, -1374262916, -1373378974,
-1372762968, -1372389764, -1370758805, -1364730204, -1362715296, -1362227634,
-1359174685, -1358211230, -1357138692, -1355370389, -1354053257, -1350868457,
-1350777050, -1350674689, -1348908961, -1347588072, -1344602852, -1344514778,
-1343545440, -1343519384, -1342012543, -1339298411, -1336963075, -1335098539,
-1332581881, -1326111917, -1325917406, -1324520637, -1323795952, -1323784276,
-1323313190, -1322136349, -1321873979, -1321684144, -1317704990, -1313370393,
-1308950916, -1305917926, -1302072397, -1300319156, -1294937526, -1292453024,
-1291036187, -1287595109, -1287335820, -1285816310, -1285064365, -1281240537,
-1274436664, -1273126118, -1273031057, -1269402178, -1267415966, -1262588299,
-1262489090, -1261433619, -1258524345, -1257985975, -1257339739, -1255248326,
-1251283584, -1250529203, -1248906044, -1248365036, -1246431342, -1245827487,
-1244984514, -1244917674, -1244130939, -1243284688, -1239494353, -1235714795,
-1234106243, -1232706177, -1231307567, -1229648392, -1226776415, -1226654202,
-1223683425, -1222491223, -1221273803, -1220618616, -1220166506, -1218063950,
-1214792113, -1214529894, -1208662559, -1205582707, -1204990807, -1202802916,
-1202613845, -1201726499, -1200401662, -1200218840, -1199940695, -1198768361,
-1198467036, -1197687309, -1196767921, -1195419393, -1195414301, -1194819208,
-1194223918, -1190666025, -1187314345, -1186021365, -1181738960, -1181009990,
-1179815114, -1179804540, -1178782102, -1177936415, -1177608236, -1175698469,
-1168162894, -1166997253, -1166097034, -1166088241, -1164312231, -1159536140,
-1158192557, -1157905931, -1157862669, -1156435629, -1154347777, -1154238015,
-1152362130, -1152115558, -1151435002, -1150546393, -1150053786, -1144787401,
-1142540230, -1140991151, -1139300204, -1136906726, -1133680252, -1132541838,
-1132210142, -1130720767, -1126196598, -1125789324, -1124034267, -1122103623,
-1119608326, -1114502591, -1114426469, -1114239242, -1111986905, -1111106168,
-1110297043, -1110025313, -1106914920, -1106308108, -1105499921, -1104514967,
-1104235633, -1102577454, -1102120265, -1099053382, -1098788829, -1098489579,
-1098166676, -1098113968, -1096057965, -1095632567, -1094363401, -1093744474,
-1092897653, -1091003600, -1090542812, -1089044704, -1088771902, -1086111510,
-1082781016, -1081223003, -1078803099, -1078307842, -1076850634, -1074398146,
-1071960847, -1066836708, -1066167358, -1063745273, -1062315027, -1062239280,
-1056396139, -1055275650, -1054235844, -1052881709, -1051658332, -1050945578,
-1049438060, -1046720837, -1046278048, -1042441928, -1041517155, -1040056268,
-1036608658, -1035287405, -1034948766, -1031985544, -1030915855, -1028451695,
-1026818717, -1023780620, -1017369609, -1016856272, -1016646949, -1015184727,
-1013113382, -1011989072, -1011625572, -1011413856, -1010125177, -1003923652,
-1002939495, -1002674988, -998438061, -996798893, -996452522, -993822717,
-992424133, -990211307, -989978835, -988471264, -984487924, -983912737, -983434252,
-982729126, -980078637, -976699589, -975743396, -974573359, -968700172, -967948704,
-967922878, -967353758, -967053476, -965694138, -958495475, -954557139, -953390404,
-952161496, -951634025, -949948777, -946007518, -941156711, -938279713, -934617972,
-934563186, -932764786, -932101337, -930014502, -928567576, -927654372, -921345637,
-918318577, -918235775, -917768942, -917422625, -917158282, -915689920, -913689539,
-908239433, -907697815, -902519110, -900191767, -898792478, -898308366, -897289200,
-894434189, -894236172, -894150379,
-892694719, -891414401, -888105812, -886593623, -885651301, -885178081,
-884459637, -883870001, -882947476, -880765813, -879331184, -879245436, -875773081,
-875284940, -874371356, -872356657, -872075579, -870469719, -863388621, -859660019,
-859032579, -858608286, -855628253, -855563020, -852313906, -850350883, -848304913,
-846657835, -846358114, -845548022, -844964886, -843490307, -843146502, -838545839,
-833653145, -832907515, -832474364, -832265727, -831068875, -829599111, -826473302,
-824830117, -824769764, -822390184, -820579098, -820318584, -816467515, -812816586,
-812722385, -812195006, -810761413, -809602997, -809301437, -808979794, -808063514,
-805761133, -799935202, -798246899, -798113595, -797958364, -792364134, -789566500,
-787902593, -787736729, -787236728, -786663114, -786379989, -785959736, -785938347,
-785904974, -785270972, -784871034, -784780918, -783429758, -781607567, -781000582,
-780427359, -778256214, -776714142, -774950526, -772689206, -771267219, -770467555,
-769856130, -768960542, -767937568, -766245784, -765938674, -765735460, -764677705,
-763527624, -762879049, -762566552, -760889159, -760231289, -752108427, -751164878,
-750370069, -745461950, -744199633, -742377618, -741667851, -739594642, -739508208,
-738273406, -735257843, -734534134, -732527084, -731514882, -729227292, -729162152,
-726513414, -725880728, -720609302, -720087115, -718847716, -718138209, -717482443,
-717431106, -715318745, -714895912, -711748839, -710911380, -709613355, -708914153,
-708786539, -704615534, -704248796, -702851155, -700735659, -700617908, -699948545,
-699904448, -699178993, -698819037, -697838071, -693930377, -693794160, -690745427,
-689680463, -687310465, -682691008, -681285682, -680050680, -680041222, -679941680,
-679455879, -678525188, -678137130, -677969577, -676471948, -675293843, -673853001,
-672196350, -671150235, -670758499, -667773862, -667172255, -666316483, -666089611,
-665966243, -662597031, -662205189, -661735410, -660255751, -659580120, -655597220,
-655153848, -654750793, -649065330, -647944662, -645351547, -645141588, -644337697,
-642248532, -641036885, -640743728, -640279983, -639947578, -639433302, -636480494,
-635737212, -634714398, -632659086, -631284525, -625642277, -623899994, -621690622,
-617752379, -617008043, -608276866, -605505002, -603966883, -602497927, -602467588,
-601944372, -597840314, -597701046, -596987404, -596600264, -596549902, -591735250,
-591072421, -590588295, -584433972, -582518715, -582097075, -579609601, -579176244,
-568279059, -567153349, -565061923, -564937046, -563488228, -562072404, -559855804,
-558578610, -558320170, -558312754, -556353935, -555252602, -554157247, -551619670,
-551557339, -550779282, -549798385, -548762209, -548251610, -547861392, -547662628,
-546362421, -539601326, -538149099, -536206048, -533610504, -531529236, -530331228,
-525380380, -524799225, -517876141, -517321300, -514443595, -501522865, -500163163,
-498077681, -491902562, -486839785, -486387447, -484413465, -484011363, -482231973,
-482048932, -480824831, -478874406, -478695254, -478322867, -475416712, -467587001,
-463890009, -463698473, -463192117, -460028160, -456952074, -456526627, -455165937,
-454496697, -451925139, -451350731, -448549938, -446798154, -442480981, -441615270,
-440727441, -439745333, -439695815, -438477696, -435747062, -435698783, -435362320,
-435023675, -429489456, -428825730, -426512897, -426014402, -425255192, -421341472,
-419860368, -409952211, -407251329, -402064194, -401187225, -400803286, -400066472,
-398622177, -396925473, -395403717, -392639773, -391310022, -388006874, -387479207,
-382758759, -382319059, -382161398, -376673307, -376531726, -374222758, -373264764,
-372040937, -369640142, -368977757, -368081320, -367113887, -361513514, -360493169,
-356829827, -356007862, -355946369, -355639124, -346050673, -343467315, -341554629,
-341404622, -334473894, -334454559, -333309536, -332418840, -330345090, -329077752,
-327651577, -326558409, -323738970, -322505728, -320477878, -319218029, -316033428,
-315677750, -314075452, -311233572, -308973086, -308039274, -306509664, -306273188,
-304481341, -304061457, -302483549, -300113694, -298347929, -298310900, -298277539,
-297291175, -294399766, -292854027, -292718210, -292229199, -291388045, -290214063,
-287518863, -284416072, -284101193, -282225455, -281000632, -278886228, -277348815,
-277091429, -276236948, -275046407, -274806188, -267242666, -267234210, -266796599,
-265495070, -264848777, -264387578, -264099981, -263902737, -263128597, -261953635,
-259661161, -258755232, -254583296, -254355365, -253497220, -253072224, -252477095,
-251005787, -248385764, -247995104, -246536994, -244027218, -238938682, -235501793,
-234272313, -233330774, -231955568, -230642436, -229401867, -228491312, -227778944,
-227344761, -226620198, -226319926, -225653482, -225492859, -217397126, -216039253,
-213592385, -212416918, -211790805, -208844739, -207223251, -206992062, -204733061,
-203400641, -202960798, -202943027, -201682711, -199512733, -196203000, -195255123,
-194749300, -194072008, -192597576, -191582043, -190949458, -190520740, -188163985,
-187196839, -183934349, -183734039, -179579336, -178994300, -177347808, -176710043,
-174148427, -172568457, -171796703, -171340771, -171265223, -169045312, -168976833,
-163144302, -162516791, -162477339, -161520563, -156327745, -153058054, -153008667,
-149937736, -146614924, -146244523, -145822438, -145441607, -142716291, -142094677,
-141679192, -138271477, -137759683, -136844770, -136761653, -135601654, -131931110,
-131145790, -130749714, -128673930, -125222323, -121166220, -118883718, -117819893,
-116951229, -115640260, -115576617, -114978385, -114854353, -109881494, -108761950,
-108217429, -107379370, -107028747, -106974183, -106955610, -106942778, -104742830,
-102809835, -99897759, -99894160, -98660380, -97434274, -96273724, -95929532,
-93347206, -93020082, -91607380, -88629860, -88236356, -87337916, -84659868,
-80322488, -80318979, -80076921, -77499448, -76222078, -72621913, -72561807,
-72403461, -70621597, -69901216, -69378856, -67832585, -67179532, -65588795,
-65262962, -57525598, -55573221, -51216591, -50328379, -48634733, -36024217,
-34697601, -33980624, -33910125, -32735664, -30982178, -27395648, -26176223,
-25711250, -24048337, -21821647, -21643366, -18933402, -18159354, -15725381,
-14760746, -9813825, -7401811, -7270997, -6927000, -6678366, -4011015, -3685060,
-284739, 0, 1, 672807, 1148797, 2097018, 2158529, 2190104, 5619237, 10374034,
10427443, 11442927, 15617757, 17668215, 17834062, 17932899, 19737068, 20172858,
21838809, 24596309, 25444413, 27609557, 27838818, 28333582, 30000359, 30532763,
32942009, 33399855, 33910359, 33989777, 34391385, 38113760, 42993644, 45812121,
46787573, 50515795, 50519296, 54102066, 55472038, 57473573, 58149103, 59067080,
59229706, 60057618, 62202044, 62809902, 63288272, 65719878, 67107437, 69453124,
70832152, 71187703, 71338646, 71910113, 72077795, 74505851, 75253556, 76727422,
77875549, 78836780, 79477693, 84561776, 86664183, 87238307, 88110268, 88845135,
91252431, 93355534, 94081228, 94378833, 99534788, 101505616, 101910858, 103689603,
106745928, 106959602, 108872583, 110023793, 112709096, 115026577, 115445015,
116077001, 116090638, 116500648, 117178516, 118114053, 118607758, 118837833,
121328563, 123945377, 125754228, 128676805, 128796872, 128926537, 129506055,
130875086, 131348984, 133399822, 134474637, 135837457, 139399646, 139460570,
143193575, 143666975, 145141322, 145916134, 148192892, 149335327, 150170925,
151081474, 152427587, 153379478, 154371454, 154676959, 155282294, 156644916,
162733639, 163183927, 165827339, 166046232, 169935797, 171032399, 174071836,
176380808, 178607767, 179213628, 182880987, 182895835, 183201465, 183693656,
184212730, 185166707, 186952738, 188205405, 189750650, 190999930, 193080070,
194569182, 195588687, 199961608, 200960233, 201845171, 203349152, 206768739,
212516615, 213754173, 213964418, 215263044, 217634940, 219892846, 220060867,
220108844, 220476485, 223192318, 229291317, 231200362, 231743057, 233933068,
234873793, 235895140, 237002815, 238449614, 239153919, 241735676, 242824081,
243974628, 244373523, 246794640, 248502533, 249082855, 251375636, 253665619,
254310241, 254709590, 261543924, 262009957, 264873898, 266495055, 266780161,
267632723, 268007623, 269466769, 271328615, 271940188, 272883776, 273195555,
275267703, 275839885, 276247563, 277642695, 278053644, 281233581, 281426451,
283120404, 283146129, 284297539, 285098436, 287432611, 289868514, 295617937,
295760129, 296602808, 298109802, 298127606, 298196287, 298516548, 308872899,
308885476, 314474502, 314904567, 320501318, 321062285, 325004320, 326953065,
327280726, 331284169, 333266660, 333386267, 333455882, 334455049, 334607974,
334764642, 335319731, 341256064, 342628233, 343930857, 344965979, 345434102,
348426401, 348795536, 352907741, 353164835, 353292352, 353656437, 355481242,
366613038, 368580697, 368783024, 369997253, 376796105, 379406994, 384305149,
388682470, 391260517, 392553977, 393124511, 393322705, 397035521, 397282137,
397517966, 397590419, 402007678, 402555575, 402951965, 405990057, 407124268,
409262972, 413017517, 416680241, 419880672, 420186056, 420506685, 421954561,
422640802, 423300144, 425029569, 428087425, 428340509, 429003719, 429119006,
430533366, 433576759, 433735702, 435084559, 438060236, 438604810, 441180230,
450013135, 454340010, 454991269, 457446433, 458072117, 460954599, 460992570,
461150273, 461968503, 462455917, 464485725, 464904373, 465063279, 468045004,
469655699, 470576806, 470792493, 471349332, 472802553, 473057043, 473735326,
476193321, 478298301, 478357756, 480328787, 482800396, 487368992, 487935510,
488380954, 495278731, 500353621, 502406724, 503445739, 503812115, 504060517,
505151724, 506999953, 510528001, 511905289, 513795406, 515021371, 515467752,
516212994, 516720960, 516839608, 517778584, 518844146, 519390536, 521791027,
521824976,
522168224, 523219081, 523919247, 527231573, 529601663, 530981746, 534495127,
536410139, 538145833, 543637114, 544087424, 545366286, 545421102, 545605460,
552049901, 552449329, 555887054, 560415812, 561883514, 562051724, 562666241,
565156082, 567091701, 567110530, 571609058, 572453997, 577105168, 577573946,
578985420, 579314693, 582739672, 583409005, 586147332, 586296150, 587773789,
588024600, 588135665, 590086672, 591004031, 591206594, 592357896, 593223015,
595271712, 598840771, 599304828, 601368394, 602267515, 602892803, 603338346,
603430142, 607214750, 609173657, 611179865, 612391806, 614265375, 615476982,
616812693, 617002605, 625074357, 626861527, 626881464, 629980829, 631574941,
632590504, 634761850, 634969325, 636351035, 639445520, 640177790, 642095096,
642425020, 645396793, 646086615, 652604324, 653377886, 655868555, 655960311,
656301350, 659694990, 662612664, 663790932, 665068645, 665556258, 669159106,
669228301, 672950664, 673885822, 677021310, 679362065, 680600961, 681580553,
681856585, 682822334, 685705694, 686405839, 688033516, 688817813, 689125345,
689513224, 689973852, 690926365, 691398953, 692290835, 693866539, 694740190,
694986969, 695502807, 699562177, 700615726, 700942893, 704571736, 704931952,
705494309, 708972072, 710488234, 712658564, 713657705, 717718249, 718969434,
719297899, 721355785, 721562967, 724308865, 725050812, 725481318, 726018811,
727234896, 727590293, 731817733, 732051417, 733483044, 734008528, 734247912,
734694369, 735800801, 738026921, 739115411, 739511829, 739838735, 740810851,
741263945, 741582517, 741984297, 742495446, 743800314, 744171449, 744338925,
745087126, 745564405, 747320687, 747666085, 748115932, 748913998, 749285344,
749566648, 749854562, 750706340, 752501803, 753646054, 756065842, 757174910,
764453942, 765019562, 766239433, 768967867, 769862576, 771668221, 778558115,
779999282, 780778635, 782016877, 783916882, 784594334, 786333002, 789946665,
790454345, 792170005, 792548278, 792599117, 792747051, 792912308, 792989607,
793868908, 796165198, 796800414, 799034460, 801466830, 802130941, 802864492,
803896604, 804377574, 806348866, 809539067, 809903547, 810946100, 812626786,
813628920, 816409532, 817324285, 818560044, 818744096, 819676534, 822015307,
824163741, 824352365, 825954567, 826857302, 827470628, 828414746, 829151390,
830521892, 831553381, 832967673, 834221425, 842002956, 843224166, 846217304,
852365408, 856007327, 860818374, 862115433, 864106078, 867615759, 868557773,
869112495, 869791813, 876459450, 878003146, 882371655, 882606695, 882870128,
884240804, 884574467, 887774904, 888353443, 888551859, 889781453, 891125098,
891378408, 893982294, 897138169, 897655993, 897998961, 901699329, 905647135,
906684976, 908431067, 910037150, 913596061, 913973855, 917932554, 918078810,
920431391, 921441320, 923861656, 925345511, 925494551, 925941936, 927847531,
928208671, 928300874, 932335463, 937196046, 938278039, 946019956, 948689607,
953545545, 954487431, 955223029, 955466662, 960611888, 961000363, 962489878,
963675051, 965043160, 971365832, 973564960, 976708891, 979153704, 981184720,
981805014, 982097152, 986506353, 991684846, 993047426, 994046024, 994467443,
996410753, 997227194, 998445777, 1005386575, 1006658316, 1007900136, 1008491624,
1009003492, 1009159402, 1009423337, 1009471998, 1010627820, 1015420850, 1017513183,
1018421970, 1019250342, 1020886131, 1023035721, 1024249428, 1027369739, 1027841284,
1031934696, 1036462614, 1036492330, 1037106069, 1039194337, 1040347619, 1042950915,
1043186896, 1045441822, 1045671926, 1055290933, 1055564335, 1057094105, 1057650718,
1058507002, 1059367722, 1061184027, 1061688745, 1065276509, 1067916147, 1068257967,
1072206593, 1072235375, 1075163661, 1075776933, 1075969252, 1076577862, 1080129941,
1080244155, 1081956070, 1083633856, 1085310325, 1086976357, 1089991438, 1090433742,
1094771386, 1100167307, 1102771879, 1103177043, 1103575534, 1104717762, 1106677807,
1106978165, 1107048597, 1109906496, 1110065844, 1110087504, 1110717569, 1113598567,
1113694833, 1116905095, 1117088782, 1117526574, 1120147761, 1120413598, 1122974661,
1124628371, 1126374941, 1126891033, 1127765313, 1129493819, 1131517210, 1132607231,
1134927964, 1134930077, 1135764223, 1135849577, 1137196175, 1139506873, 1139998608,
1140484338, 1141715923, 1142588083, 1147750981, 1151910779, 1153974412, 1154874321,
1155818612, 1158147835, 1159490840, 1161444194, 1164045558, 1165063025, 1167510548,
1170372905, 1170593564, 1173341445, 1173385329, 1173590351, 1175572626, 1176344607,
1176379672, 1176727801, 1177344758, 1178010409, 1178825708, 1179173476, 1182131144,
1183797222, 1185463963, 1186174055, 1186541004, 1187401304, 1188195367, 1191029865,
1192087071, 1192697488, 1196585179, 1198303077, 1198594755, 1203803982, 1203877945,
1205637305, 1205767531, 1206598214, 1207145313, 1207820644, 1209534856, 1211991166,
1214714226, 1217426090, 1217747750, 1220392850, 1228092368, 1229598853, 1230504848,
1232160346, 1234654748, 1238086763, 1241981485, 1242765821, 1242820836, 1242999063,
1247775216, 1255253841, 1257042540, 1257784676, 1259370716, 1262801737, 1265716675,
1265866399, 1268367997, 1269949592, 1270695135, 1270926136, 1274223414, 1276247411,
1276669036, 1276913016, 1277530415, 1281461444, 1285321631, 1289502613, 1290399593,
1291052282, 1291780998, 1294458128, 1294660160, 1295141439, 1296875182, 1299893163,
1302130385, 1303291429, 1303895059, 1308909205, 1309591728, 1310188964, 1314606673,
1314973421, 1315326443, 1319646636, 1319711999, 1320870890, 1321002318, 1322599687,
1322850236, 1323236069, 1324987584, 1325191242, 1325392174, 1325890165, 1334211887,
1334287539, 1339515150, 1340546480, 1341607640, 1346088777, 1346555089, 1346772994,
1351971054, 1352059849, 1352673398, 1354282733, 1354599210, 1354642312, 1355417498,
1362051854, 1364294998, 1364970772, 1370495037, 1371130841, 1372283916, 1372944856,
1373066528, 1373178601, 1373265502, 1373981680, 1375421859, 1375426950, 1376068861,
1377377775, 1377798300, 1377851161, 1378364078, 1386655660, 1387247592, 1387701031,
1388696232, 1389876015, 1393695351, 1395377870, 1396208178, 1397614792, 1398999652,
1399721807, 1400646602, 1400779242, 1401628327, 1401634786, 1401691892, 1401794693,
1402321902, 1402427993, 1402636787, 1403653624, 1403862760, 1404512209, 1405780235,
1406691148, 1406831854, 1408260863, 1410215290, 1410378921, 1410610558, 1411135360,
1411251344, 1412957314, 1415806656, 1415990572, 1418650301, 1419629373, 1421691075,
1421812642, 1422145576, 1423372404, 1425692615, 1426229641, 1431314508, 1432176839,
1435918999, 1436676537, 1437162697, 1440027172, 1442407590, 1443534730, 1443554608,
1443672477, 1444059587, 1445216615, 1446785127, 1448649730, 1449457421, 1451524879,
1453112111, 1454428999, 1454558764, 1457023859, 1458648404, 1461598408, 1463040948,
1464206477, 1465169705, 1466394478, 1467365823, 1468356538, 1469226472, 1469490440,
1469519682, 1470582356, 1471754228, 1474593500, 1475066742, 1475420822, 1478625124,
1482184358, 1482368198, 1483122922, 1484287822, 1484471535, 1487640179, 1489510797,
1493834009, 1494977731, 1498058573, 1499015646, 1500460626, 1500549703, 1500900183,
1500940271, 1500955964, 1506606509, 1509681340, 1511019686, 1511372406, 1512567117,
1513210051, 1520524577, 1522297301, 1523460650, 1529716730, 1534477099, 1536046376,
1536675436, 1538096462, 1539116449, 1539503401, 1540639720, 1547575253, 1550517442,
1552450532, 1554546915, 1554713824, 1555068275, 1555511071, 1555911931, 1556343980,
1556929656, 1557043010, 1560238830, 1561600189, 1561820016, 1562449901, 1563802370,
1568183199, 1569413074, 1570317287, 1570659854, 1571598379, 1571748447, 1573748055,
1574481091, 1576131134, 1576686933, 1579428331, 1580441973, 1581542087, 1583622855,
1583858117, 1584029602, 1587516082, 1590039168, 1590259301, 1592092381, 1593532513,
1595879203, 1596992403, 1597568309, 1600649482, 1601012585, 1601122810, 1608599995,
1610478882, 1612035113, 1614387706, 1614608934, 1615909054, 1616276734, 1616640013,
1617185821, 1617666332, 1617692872, 1620052171, 1621690223, 1622091907, 1624091626,
1626516190, 1627089481, 1629588291, 1630204787, 1632835044, 1634673006, 1636524996,
1638589311, 1639807854, 1639837116, 1640634842, 1644121557, 1645154144, 1645869634,
1648130116, 1648996519, 1651398668, 1654062564, 1657853142, 1659114417, 1659902201,
1660274127, 1660583732, 1660892591, 1662371313, 1666829486, 1667518897, 1669787048,
1670528121, 1674536097, 1675001439, 1676143257, 1677759715, 1679087583, 1679902125,
1682180045, 1683807511, 1686320859, 1686988972, 1687546936, 1687882444, 1687909584,
1692339619, 1696306997, 1696680648, 1698502800, 1699318617, 1700328858, 1702862264,
1702873392, 1703307807, 1703766122, 1703795393, 1705847567, 1708316203, 1709202425,
1710480024, 1712078079, 1717266268, 1720764967, 1720991962, 1721266053, 1721535337,
1722781496, 1723707753, 1724383952, 1725555324, 1725599904, 1726847556, 1728653614,
1728834578, 1730299138, 1732381975, 1733278169, 1733393518, 1733549910, 1734865293,
1736751633, 1738480245, 1740866160, 1741851655, 1742169522, 1742302538, 1742382552,
1744621379, 1745095666, 1750910893, 1754673782, 1756632991, 1759283610, 1759565825,
1762277310, 1768011414, 1768925196, 1768962993, 1769197249, 1770128234, 1770712962,
1773382025, 1773488414, 1774284356, 1775497236, 1780369333, 1780626049, 1782609091,
1783949394, 1784834940, 1785055444, 1785812911, 1788261348, 1789518096, 1789789375,
1791414302, 1793133309, 1793912296, 1796544824, 1797167076, 1798566907, 1802731496,
1803337794, 1803613648, 1805241817, 1805561236, 1805575922, 1807086694, 1808175671,
1812228477, 1812998633, 1813252217, 1815263983, 1817366252, 1818952284, 1821015908,
1821674421, 1822805786, 1829746685, 1829985335, 1830105822, 1830391337, 1832580377,
1835479730, 1836730895, 1838125671, 1842518481, 1843254666, 1845336031, 1849582458,
1850101394, 1852234999, 1853143390, 1855967259, 1856728981, 1859462765, 1859900926,
1860254177, 1864669308, 1867853076,
1869405582, 1870204436, 1870348105, 1870527708, 1874378111, 1875049749,
1876129426, 1876245442, 1876390691, 1877545092, 1877634046, 1879165350, 1879383439,
1880134294, 1882252188, 1883267976, 1883806413, 1885912814, 1890491969, 1890916092,
1891168241, 1892051715, 1892775552, 1893328405, 1896240735, 1896710550, 1896899746,
1908212143, 1908473462, 1908523873, 1909479168, 1911627717, 1912148117, 1912899480,
1914426031, 1915252838, 1915394916, 1918029298, 1918443687, 1919619131, 1926893249,
1927983229, 1931283324, 1933900914, 1934599735, 1934705625, 1937045644, 1937629385,
1937655936, 1941354734, 1941468160, 1941524540, 1941742544, 1942916625, 1945997290,
1948462209, 1950081713, 1950644919, 1958167109, 1962934478, 1963125641, 1966654844,
1968776163, 1969746579, 1970630854, 1973127142, 1975013759, 1978326329, 1978559474,
1982261159, 1985369802, 1986437353, 1986917170, 1988053258, 1993334295, 1995084596,
1996791269, 1998520289, 1999094753, 2003884746, 2005595632, 2005691562, 2006771344,
2010397477, 2011596139, 2012534726, 2012680221, 2013479311, 2013548501, 2014179127,
2014179128, 2015710128, 2018292968, 2019015784, 2023453981, 2025223323, 2040591074,
2047969744, 2048112552, 2048123190, 2048458890, 2048985221, 2053155705, 2055757114,
2056311324, 2057627635, 2058244409, 2061302939, 2062251705, 2062617070, 2062797135,
2066767018, 2067218184, 2067521549, 2068085125, 2069376781, 2071323488, 2071591230,
2071759261, 2074403891, 2080663693, 2081559161, 2082395949, 2083395848, 2083433126,
2083862701, 2084631160, 2086016529, 2086433020, 2087035411, 2088513705, 2088770685,
2089458926, 2091464691, 2092321074, 2097348435, 2097747478, 2098186582, 2098616441,
2099351140, 2101237269, 2102277268, 2102822528, 2103515844, 2104584435, 2104925005,
2105385294, 2107918074, 2108268457, 2112688325, 2114145769, 2115340901, 2116155728,
2116641453, 2118283909, 2120911659, 2122124875, 2122610948, 2123726580, 2125588692,
2125818432, 2129111030, 2130929897, 2131940382, 2132144110, 2133780311, 2133822467,
2134631915, 2135467038, 2140283986, 2140820833, 2141883689, 2143827310, 2144432542,
2144687931, 2146587987, 2146587988, 2146587989, 2147156801, 2147156802, 2147156803,
2147156804, 2147156805)
AND (ISNULL([Link],0)) IN (-1795602282, -1214817689, -605595605,
-424037770, 0, 1, 353385616, 482507436, 708940007, 765021876, 1259746143,
1905575627, 2051977647, 2104090237)
AND [Link] in (0, 1, 2)
AND [Link] IN (0, 1)
AND [Link] in (34,35) and (ISNULL([Link],0) <> 0)
ORDER BY TransactionDateTime

----------------------------------------------------------------------------
exec sp_reset_connection

----------------------------------------------------------------------------

select [Address], ZIP, City, Name from [Link] Where StoreId = @StoreId

----------------------------------------------------------------------------

exec sp_executesql N'select [Address], ZIP, City, Name from [Link] Where
StoreId = @StoreId',N'@StoreId int',@StoreId=1

----------------------------------------------------------------------------

select table_id, item_guid, oplsn_fseqno, oplsn_bOffset, oplsn_slotid