A check constraint referencing another column - The first block of code is from another website. Here the CHECK constraint is supposed to be applied to the MedicamentRegulated column...
EBCDIC file is getting loaded with all special characters in my table - Hi, I have an EBCDIC file and I am trying to load it using SSIS. I created a flat file connection manager,...
How to store output of SQL Server Stored Procedure in a .txt file - I have below SP I am printing the value of the variable in S.S.M.S. Instead, I want to store this...
???Ryerson?????|Ryerson???|Q?1010636782|Ryerson?????????????RU?????Ryerson University - ??????Q/?1010636782???????:???,??????(????)??????+«?????&????»,???????,??????,?????,Offer,????,???? ,?????? ?????????Q Q\??1010636782???:???,??????(????)??????+«?????&????»,???????,??????,?????,Offer,????,???? ,?????? ????????????????????????????????????????????,??,DHL?? F????:???.??.??.???.??.??.??. F???????????????????????,????,????,??????????????,????????????!??? #??
???OTTAWA?????|OTTAWA???|Q?1010636782|OTTAWA?????????????UO?????UNIVERSITY OF OTTAWA - ??????Q/?1010636782???????:???,??????(????)??????+«?????&????»,???????,??????,?????,Offer,????,???? ,?????? ?????????Q Q\??1010636782???:???,??????(????)??????+«?????&????»,???????,??????,?????,Offer,????,???? ,?????? ????????????????????????????????????????????,??,DHL?? F????:???.??.??.???.??.??.??. F???????????????????????,????,????,??????????????,????????????!??? #??
???Brock?????|Brock???|Q?1010636782|Brock?????????????BU?????Brock University - ??????Q/?1010636782???????:???,??????(????)??????+«?????&????»,???????,??????,?????,Offer,????,???? ,?????? ?????????Q Q\??1010636782???:???,??????(????)??????+«?????&????»,???????,??????,?????,Offer,????,???? ,?????? ????????????????????????????????????????????,??,DHL?? F????:???.??.??.???.??.??.??. F???????????????????????,????,????,??????????????,????????????!??? #??
???McMaster?????|McMaster???|Q?1010636782|McMaster???????????????MU?????McMaster University - ??????Q/?1010636782???????:???,??????(????)??????+«?????&????»,???????,??????,?????,Offer,????,???? ,?????? ?????????Q Q\??1010636782???:???,??????(????)??????+«?????&????»,???????,??????,?????,Offer,????,???? ,?????? ????????????????????????????????????????????,??,DHL?? F????:???.??.??.???.??.??.??. F???????????????????????,????,????,??????????????,????????????!??? #??
???Queen’s?????|Queen’s???|Q?1010636782|Queen’s????????????QU?????Queen’s University - ??????Q/?1010636782???????:???,??????(????)??????+«?????&????»,???????,??????,?????,Offer,????,???? ,?????? ?????????Q Q\??1010636782???:???,??????(????)??????+«?????&????»,???????,??????,?????,Offer,????,???? ,?????? ????????????????????????????????????????????,??,DHL?? F????:???.??.??.???.??.??.??. F???????????????????????,????,????,??????????????,????????????!??? #??
???Windsor?????|UW???|Q?1010636782|Windsor????????????UW?????University of Windsor - ??????Q/?1010636782???????:???,??????(????)??????+«?????&????»,???????,??????,?????,Offer,????,???? ,?????? ?????????Q Q\??1010636782???:???,??????(????)??????+«?????&????»,???????,??????,?????,Offer,????,???? ,?????? ????????????????????????????????????????????,??,DHL?? F????:???.??.??.???.??.??.??. F???????????????????????,????,????,??????????????,????????????!??? #??
???Guelph?????| Guelph???|Q?1010636782| Guelph?????????????UG?????University of Guelph - ??????Q/?1010636782???????:???,??????(????)??????+«?????&????»,???????,??????,?????,Offer,????,???? ,?????? ?????????Q Q\??1010636782???:???,??????(????)??????+«?????&????»,???????,??????,?????,Offer,????,???? ,?????? ????????????????????????????????????????????,??,DHL?? F????:???.??.??.???.??.??.??. F???????????????????????,????,????,??????????????,????????????!??? #??
???York?????|York???|Q?1010636782|York????????????YU?????York University - ??????Q/?1010636782???????:???,??????(????)??????+«?????&????»,???????,??????,?????,Offer,????,???? ,?????? ?????????Q Q\??1010636782???:???,??????(????)??????+«?????&????»,???????,??????,?????,Offer,????,???? ,?????? ????????????????????????????????????????????,??,DHL?? F????:???.??.??.???.??.??.??. F???????????????????????,????,????,??????????????,????????????!??? #??
???Carleton?????|Carleton???|Q?1010636782|Carleton?????????????CU?????Carleton University - ??????Q/?1010636782???????:???,??????(????)??????+«?????&????»,???????,??????,?????,Offer,????,???? ,?????? ?????????Q Q\??1010636782???:???,??????(????)??????+«?????&????»,???????,??????,?????,Offer,????,???? ,?????? ????????????????????????????????????????????,??,DHL?? F????:???.??.??.???.??.??.??. F???????????????????????,????,????,??????????????,????????????!??? #??
???Waterloo?????|Waterloo???|Q?1010636782|Waterloo?????????????UW?????University of Waterloo - ??????Q/?1010636782???????:???,??????(????)??????+«?????&????»,???????,??????,?????,Offer,????,???? ,?????? ?????????Q Q\??1010636782???:???,??????(????)??????+«?????&????»,???????,??????,?????,Offer,????,???? ,?????? ????????????????????????????????????????????,??,DHL?? F????:???.??.??.???.??.??.??. F???????????????????????,????,????,??????????????,????????????!??? #??
???UWO?????|UWO???|Q?1010636782|UWO??????????????UWO?????University of Western Ontario - ??????Q/?1010636782???????:???,??????(????)??????+«?????&????»,???????,??????,?????,Offer,????,???? ,?????? ?????????Q Q\??1010636782???:???,??????(????)??????+«?????&????»,???????,??????,?????,Offer,????,???? ,?????? ????????????????????????????????????????????,??,DHL?? F????:???.??.??.???.??.??.??. F???????????????????????,????,????,??????????????,????????????!??? #??
???Toronto?????|Toronto???|Q?1010636782|Toronto?????????????U of T?????University of Toronto - ??????Q/?1010636782???????:???,??????(????)??????+«?????&????»,???????,??????,?????,Offer,????,???? ,?????? ?????????Q Q\??1010636782???:???,??????(????)??????+«?????&????»,???????,??????,?????,Offer,????,???? ,?????? ????????????????????????????????????????????,??,DHL?? F????:???.??.??.???.??.??.??. F???????????????????????,????,????,??????????????,????????????!??? #??
Find tables with records in multible DB's - Hi all! On my production SQL server, I have + 300 databases, whereof app. 50 has the same structure, and has a...
Yikes! SQL Master at Work. - I'm going through some scripts that my coworker wrote, for a good laugh. The HR guy calls him the "SQL...
Anyone see a problem with this? - I asked a developer to write a simple query against this table of mine. He looked at me and said...
HOW TO GET FIRST DATE - Dear all, I have data like: NAME SPONSOR_NAME DATE_OF_CALL A FI
dbms query cost merge-sort - Can anyone please explain the red marker line in above. I find it difficult to understand. This is given in my...