´úÂë¸Ä±äÊÀ½ç

΢ÈíBI Ö®SSIS ϵÁÐ - ʹÓà Script Task ·ÃÎÊ·Ç Windows ÑéÖ¤Ï嵀 SMTP ·þÎñÆ÷·¢ËÍÓʼþ

2014-09-29 10:20 by BIWORK, 4201 ÔĶÁ, 8 ÍƼö, ÊÕ²Ø, ±à¼­
ÕªÒª£º¿ªÆª½éÉÜ´ó¶àÊýÇé¿öÏÂa56爆大奖在线娱乐ÃÇµÄ SSIS °ü¶¼»áÅäÖÃÔÚ SQL Agent Job ÖÐÖÜÆÚÐԵİ´¼Æ»®Ö´ÐУ¬±ÈÈçÿÌìÍíÉϵ÷Óà SSIS °üË¢ÐÂÊý¾Ý£¬´¦Àí Cube µÈ¡£Ò»µ© SSIS °üÖгöÏÖÈκa56爆大奖在线娱乐ì³££¬±¨´í£¬ÄÇôÅäÖÃÔÚ SQL Agent Job ÖеÄ֪ͨ£¬ÓʼþÌáÐѾͻá°ÑÕâЩ´íÎóÐÅÏ¢·¢Óʼþµ½Ö¸¶¨µÄÓû§»òÕß... ÔĶÁÈ«ÎÄ

΢ÈíBI Ö®SSIS ϵÁÐ - XML Task ÖÐXSLT Ñùʽ±íת»»´íÎó¼Ç¼

2014-09-27 16:43 by BIWORK, 1018 ÔĶÁ, 0 ÍƼö, ÊÕ²Ø, ±à¼­
ÕªÒª£º¿ªÆª½éÉÜ´ËÎÄÕÂרÃżÇ¼ XSLT Ñùʽ±íת»»¹ý³ÌÖеÄÓï·¨ÎÊÌâ´íÎóÒ» ÖµÓëÊôÐԵĵ¹ÖÃÐÞ¸ÄÁ˼¸´ÎÑùʽ±í£¬µ«»¹ÊÇÒ»Èç¼ÈÍùµÄ±¨´í£¬±¨´íÐÅÏ¢ÈçÏ£º[XML Task] Error: An error occurred with the following error message: "Attribute a... ÔĶÁÈ«ÎÄ

2014ÄêÐÂÒ»´úµÄ±¨±íÀûÆ÷ Qlik Sense Desktop ³õ²½ÌåÑé

2014-09-22 12:45 by BIWORK, 24981 ÔĶÁ, 10 ÍƼö, ÊÕ²Ø, ±à¼­
ÕªÒª£ºµã»÷½øÈë QlikView/QlikSense ÉçÇø ½»Á÷Ⱥ£º432998033Qlik Sense Desktop µÄ°¸ÀýչʾÏÈÉϼ¸¸ö¸Õ¸Õ±ß¿´±ßѧÍê³ÉµÄ¼¸¸ö±¨±í°¸ÀýЧ¹û (Èç¹ûͼƬÏÔʾ²»Õý³££¬¿ÉÒÔÖØÐÂË¢ÐÂÒ»ÏÂÒ³ÃæÏÔʾ)-¸öÈ˸оõ±¨±íµÄÉè¼Æ¹ý³Ì·Ç³£¼òµ¥ºÍ·½±ã£¬²¢ÇÒ±¨±íµÄ½»»¥ÐÔÒ²·Ç³£Ö®Ç¿£¬ºÜÈÝÒ×´Ó¸÷¸ö... ÔĶÁÈ«ÎÄ

΢ÈíBI Ö®SSIS ϵÁÐ - Execute SQL Task ÖÐµÄ Single Row Óë Full Result Set µÄ´¦Àí¼¼ÇÉ

2014-09-04 17:18 by BIWORK, 6406 ÔĶÁ, 11 ÍƼö, ÊÕ²Ø, ±à¼­
ÕªÒª£º¿ªÆª½éÉÜExecute SQL Task Õâ¸ö¿Ø¼þÔÚ΢ÈíBI ETL ÏîÄ¿ÖÐʹÓõÄƵÂÊ»¹ÊǷdz£¸ßµÄ£¬Ò²ÊǴ󲿷ÖÈëÃÅ SSIS ³õѧÕß×îÔç½Ó´¥µ½µÄ¼¸¸ö¿ØÖÆÁ÷¿Ø¼þ¡£a56爆大奖在线娱乐ÃÇͨ³£Ê¹Óà Execute SQL Task µÄ³¡¾°°üº¬µ«²»Ö¹ÓÚÒÔϼ¸ÀࣺÔÚ´ÓÔ´¶Ë¼ÓÔØÊý¾Ýµ½ Staging ±í֮ǰʹÓà Execute ... ÔĶÁÈ«ÎÄ

΢ÈíBI Ö®SSIS ϵÁÐ - ´øÓÐ Header ºÍ Trailer µÄ²»¹æÔòµÄƽÃæÎļþÊä³ö´¦Àí¼¼ÇÉ

2014-09-02 23:44 by BIWORK, 2745 ÔĶÁ, 6 ÍƼö, ÊÕ²Ø, ±à¼­
ÕªÒª£º°¸Àý±³¾°ÓëÐèÇó½éÉÜ֮ǰ×ö¹ýÒ»¸öÃÀ¹úµÄÒ½ÁƱ£ÏÕµÄÏîÄ¿£¬±£ÏÕÌṩÉÌÓдóÁ¿µÄÎļþÐèÒª·¢Ë͸ø±ÈÈçÏñÒøÐУ¬Ò½ÁÆЭ»á£¬µÚÈý·½·þÎñÉ̵ȡ£±ÈÈçÏñÓëÒøÐн»»¥µÄ ACH Îļþ£¬´«Ë͸øЭ»áµÄ ACH Credit µÈÎļþ¡£ÕâЩÎļþ¸ñʽÔÚÃÀ¹ú¶¼ÊÇ¿ª·ÅµÄ£¬Í¨Óõģ¬¿ÉÒÔÖ±½Óµ½Ïà¹ØÍøÕ¾ÏÂÔØ¡£Ò²¾ÍÊÇ˵ÏñÒøÐУ¬Ð­»áµÈËûÃǽÓÊÜÕâÖ̶ֹ¨... ÔĶÁÈ«ÎÄ

΢ÈíBI Ö®SSRS ϵÁÐ - ʵÏÖ Excel ÖÐͼ±í½áºÏµÄ±¨±íÉè¼Æ

2014-08-22 22:13 by BIWORK, 5391 ÔĶÁ, 6 ÍƼö, ÊÕ²Ø, ±à¼­
ÕªÒª£ºÀ´×ÔȺÀïÃæÌÖÂÛµÄÒ»¸öÎÊÌ⣬EXCEL ÖÐÓÐÀàËÆÓÚÕâÑùµÄͼÐΣ¬ÉÏÃæÊÇ Chart£¬ Chart XÖáÉϵÄÖµÕýºÃ¾ÍÊÇÏ·½ Table µÄÁÐÍ·£¬Õâ¸öÔÚ SSRS ÖÐÓ¦¸ÃÈçºÎʵÏÖ£¿SSRS 2008¡¢2008RS,2012 ÖÐʵ¼ÊÉÏûÓÐÕâÖÖ¶ÔÓ¦µÄ¿Ø¼þ£¬a56爆大奖在线娱乐ÃÇͨ³£Ïëµ½µÄ·½Ê½¿ÉÄÜÊÇÉÏ·½Ò»¸öµ¥¶ÀµÄ Chart ͼ£¬... ÔĶÁÈ«ÎÄ

΢ÈíBI Ö®SSIS ϵÁÐ - ¶ÔÓÚƽÃæÎļþÖÐ NULL Öµ´¦Àí¹ý³ÌÖÐÈÝÒ×¼«Ò×»ìÏýµÄ¼¸¸öϸ½Ú

2014-08-21 22:22 by BIWORK, 3563 ÔĶÁ, 8 ÍƼö, ÊÕ²Ø, ±à¼­
ÕªÒª£º¿ªÆª½éÉÜ×î½üÓÐÈËÎÊa56爆大奖在线娱乐ÓйØÎļþ´¦ÀíÖпÕÖµ´¦ÀíµÄÏà¹ØÎÊÌ⣺ OLE DB Destination ÖÐµÄ Keep Nulls ÈçºÎ¿ØÖÆ NULL ÖµµÄÏÔʾ£¿ÎªÊ²Ã´Ñ¡ÖÐÁË Keep Nulls µ«ÊÇÊý¾Ý¿âÖÐûÓÐ NULL Öµ£¿ ΪʲôÔÚ Flat File Source Öй´Ñ¡ÉÏÁË Retain null... ÔĶÁÈ«ÎÄ

΢ÈíBI Ö®SSIS ϵÁÐ - Lookup ÖеÄ×Ö·û´®±È½Ï´óСд´¦Àí Case Sensitive or Insensitive

2014-08-19 12:52 by BIWORK, 2685 ÔĶÁ, 2 ÍƼö, ÊÕ²Ø, ±à¼­
ÕªÒª£º¿ªÆª½éÉÜÇ°¼¸ÌìÅöµ½ÕâÑùµÄÒ»¸öÎÊÌ⣬ÔÚ Lookup ÖÐÈçºÎÉèÖôóСд²»Ãô¸Ð±È½Ï£¬¼´ÈçºÎÔÚ Lookup ÖеÄ×Ö·û´®±È½Ïʱ²»Çø·Ö´óСд£¿Êµ¼ÊÉϾÍÕâ¸öÎÊÌâÒѾ­ÓкܶàÈËÌá¸ø΢ÈíÁË£¬µ«Êǵõ½µÄ½á¹û¾ÍÊÇ Closed and Won¡¯t fix¡£ ˵°×ÁË£¬Õâ¸ö¾ÍÊÇ By Design£¬°üÀ¨µ½ÏÖÔÚµÄ 2012 ... ÔĶÁÈ«ÎÄ

΢ÈíBI Ö®SSAS ϵÁÐ - ά¶ÈµÄÓÅ»¯,¹àľ´ÔÊôÐÔ¹Øϵ,ÒÔ¼°×ÔÈ»²ã´Î½á¹¹Óë·Ç×ÔÈ»²ã´Î½á¹¹µÄ¸ÅÄî

2014-08-13 15:03 by BIWORK, 4865 ÔĶÁ, 7 ÍƼö, ÊÕ²Ø, ±à¼­
ÕªÒª£ºÎ¬¶ÈµÄÓÅ»¯ÔÚ SSAS ¿ª·¢Éè¼Æ¹ý³ÌÖУ¬Î¬¶ÈµÄÓÅ»¯·Ç³£ÖØÒª£¬ÒòΪËüÔÚ SSAS ·ÖÎö·þÎñÐÔÄܵ÷ÓŵĹý³ÌÖÐÍùÍùÄÜÆðµ½Ò»¸ö·Ç³£ÖØÒªµÄ×÷Óᣠһ°ãÀ´Ëµ£¬¶ÔÓÚ Cube µÄÐÔÄÜÓÅ»¯µÚÒ»²½¿ÉÄÜ¿¼ÂǵľÍÊDz鿴ά¶È£¬¹Û²ìά¶ÈÖÐÊôÐÔ¹ØϵµÄÉè¼Æ¡£ ÕâÀïÓÐÁ½ÖÖ×îÖØÒªµÄµ÷ÓÅ·½·¨¿ÉÒԲο¼£ºÈ·ÈÏÊôÐÔ¹ØϵÓÐЧµÄʹÓÃÓû§×Ô¶¨ÒåµÄ... ÔĶÁÈ«ÎÄ

΢ÈíBI Ö®SSIS ϵÁÐ - ƽÃæÎļþ¸ñʽµÄÇø±ð(Delimited,Fixed width,Ragged Right, Fixed width ...)

2014-08-11 22:28 by BIWORK, 4641 ÔĶÁ, 3 ÍƼö, ÊÕ²Ø, ±à¼­
ÕªÒª£º¿ªÆª½éÉÜSSIS Öд¦ÀíÎļþ£¬Ò»°ãÔÚÃèÊöÊä³öƽÃæÎļþ¸ñʽµÄʱºòͨ³£»á³öÏÖÒÔϼ¸ÖÖÑ¡Ïî:Delimited - ĬÈÏÊä³öÁÐʹÓöººÅ·Ö¸ô£¬Ò²¿ÉÒÔÑ¡ÔñÆäËüµÄÖîÈç | £¬»òÕß Tab µÈ¡£Fixed Width - Áж¨³¤Êä³ö£¬¹Ì¶¨³¤¶È£¬µ«²»»»ÐС£Fixed Width with row delimiter... ÔĶÁÈ«ÎÄ

΢ÈíBI Ö®SSRS ϵÁÐ - ÈçºÎÈñ¨±íÔÚÒ»Ò³ÏÔʾ£¬Á½ÖÖ³£Óõļ¼ÇÉ

2014-07-06 19:59 by BIWORK, 5998 ÔĶÁ, 3 ÍƼö, ÊÕ²Ø, ±à¼­
ÕªÒª£ºÍ¨³£Çé¿öÏ£¬SSRS ±¨±íÔÚÒ³ÃæÄÚÈݹý¶àµÄʱºò»á×Ô¶¯·ÖÒ³¡£µ«ÓеÄʱºòµ±Ò³ÃæÄÚÈݲ»ÊǺܶ࣬´ó¸Å×î¶à2Ò³µÄÇé¿öÏ£¬»òÕß¿Í»§ÒªÇóËùÓÐÄÚÈݱØÐëÔÚÒ»Ò³ÏÔʾʱ£¬Ó¦¸ÃÈçºÎÉèÖá£Êµ¼ÊÉÏ£¬Òª¿¼ÂÇÁ½ÖÖÇé¿ö£ºµÚa56爆大奖在线娱乐Çé¿öÊÇÔÚ¿ª·¢½×¶ÎµÄÉèÖᣵڶþÖÖÇé¿öÊÇÔÚ±¨±íÒѾ­²¿ÊðµÄ·þÎñÆ÷£¬»òÕß²¿Êðµ½ SharePoint »òÕß CRM ... ÔĶÁÈ«ÎÄ

΢ÈíBI Ö®SSRS ϵÁÐ - ʹÓÃÎĵµ½á¹¹µ¼º½±¨±íÔªËØ Document Map

2014-07-06 19:46 by BIWORK, 1744 ÔĶÁ, 0 ÍƼö, ÊÕ²Ø, ±à¼­
ÕªÒª£ºÔÚ SSRS ÖÐÒ²ÓÐÀàËÆÓÚ Word ÎĵµÖеÄÄÇÖÖµ¼º½µÄЧ¹û-×ó²à²¿·Ö£¬¿ÉÒÔͨ¹ýµ¼º½µØͼ¿ìËٵĶ¨Î»µ½¹ú¼ÒϵÄÊ¡·Ý»òÕß³ÇÊУ¬²¢ÇÒÕâÖÖ²ã´Î½á¹¹ÊÇÓÉÔÚ´´½¨ÐзÖ×éʱ¶¨ÒåµÄ¡£±ÈÈç˵ÏÂÃæµÄÕâ¸öÀý×ÓÖУ¬a56爆大奖在线娱乐·ÖÁË3¸öÐÐ×é - µÚÒ»²ãÊÇ Country, µÚ¶þ²ãºÍµÚÈý²ãÊÇ State Province ºÍ City¡£Òª... ÔĶÁÈ«ÎÄ

WIN8 Metro UI ·ç¸ñϵÄ΢Èí±¨±í¿ª·¢ÓëÉè¼Æ Metro UI SSRS - BIWORK

2014-05-20 10:52 by BIWORK, 6000 ÔĶÁ, 17 ÍƼö, ÊÕ²Ø, ±à¼­
ÕªÒª£º¿ªÆª½éÉÜ×÷Ϊ BI ϵͳǰ¶ËÕ¹Ïֵı¨±í£¬ÆäÖØÒªÐÔ²»ÑÔ¶øÓ÷£¬a56爆大奖在线娱乐ÃǶÔÓÚÒ»¸öºÃµÄ±¨±íµÄÒªÇóÒ²ÎÞ·ÇÖ÷Òª°üº¬ÒÔϼ¸µã£º1. Êý¾ÝÍêÕûºÍÕýÈ·£¬Êý¾ÝÖÊÁ¿Ã»ÓÐÎÊÌâ2. ÓѺõÄÇåÎúµÄ½çÃ棬Õû½àÃÀ¹Û£¬ÓеÃÌåµÄ¸ñʽ3. ÓкܺõĽ»»¥ÐÔºÍÓû§ÌåÑé¸Ð£¬Óû§Äܹ»ºÜÈÝÒ×ÕÒµ½ÐèÒªµÄÖØÒªµÄÊý¾Ýµ«ÊÇÔÚ΢ÈíÌåϵÏ嵀 BI ¿ª·¢ÈËÔ±£¬Ìرð... ÔĶÁÈ«ÎÄ

΢ÈíBI Ö®SSRS ϵÁÐ - ²»ÏÔʾ Pie Chart ±ýͼÉÏ 0% µÄÊý¾Ý

2014-04-24 18:00 by BIWORK, 3063 ÔĶÁ, 0 ÍƼö, ÊÕ²Ø, ±à¼­
ÕªÒª£ºSSRS С¼¼ÇÉϵÁÐרÃÅÓÃÀ´¼Ç¼ SSRS ±¨±í¿ª·¢¹ý³ÌÖг£ÓõÄС¼¼ÇÉ -Ч¹ûͼ - 0% µÄ±êÇ©Êý¾Ý²»ÐèÒªÏÔʾ³öÀ´¡£Ð§¹ûͼ - Õý³£µÄЧ¹û¡£½â¾ö·½·¨ - ʹÓà IIF Ìõ¼þÅжϣ¬Èç¹û¼ÆËãֵΪ 0 µÄ»°£¬ÄÇôʹÓà NOTHING¡£ NOTHING µÄ×÷Ó÷dz£¶à£¬Èç¹û SSRS ±¨±í×öµÄ¶àµÄ»°£¬Ó¦¸ÃÓÃ... ÔĶÁÈ«ÎÄ

΢ÈíBI Ö®SSIS ϵÁÐ - µ¼³öÊý¾Ýµ½ Excel 2013 µÄʵÏÖ

2014-04-18 23:26 by BIWORK, 8554 ÔĶÁ, 2 ÍƼö, ÊÕ²Ø, ±à¼­
ÕªÒª£º¿ªÆª½éÉÜÅöµ½Óм¸¸öÅóÓÑÎʵ½Õâ¸öÎÊÌ⣬±È½Ï¹²ÐÔ£¬¾ÍÌØÒâдÁËÕâƪСÎÄÕÂ˵Ã÷Ò»ÏÂÈçºÎʵÏÖÔÚ SSIS Öе¼³öÊý¾Ýµ½ Office Excel 2013 ÖС£Í¨³£Çé¿öÏ 2013 ÒÔÇ°µÄ°æ±¾´ó¶àûÓÐÎÊÌ⣬µ«Êǵ½ 2013 ¾Í¿ÉÄÜÔÚ½¨Á¢Á¬½Ó¹ÜÀíÆ÷µÄʱºò³öÏÖÁ´½Óʧ°Ü¡£½¨ÒéÔÚ¿´ÕâһƪÎÄÕÂ֮ǰ£¬Èç¹ûÓе¼³öÊý¾Ýµ½ E... ÔĶÁÈ«ÎÄ

ÈçºÎ¹ÜÀíºÍ¼Ç¼ SSIS ¸÷¸ö Task µÄ¿ªÊ¼Ö´ÐÐʱ¼äºÍ½áÊøʱ¼äÒÔ¼° Task ÖÐÌí¼Ó|ɾ³ý|Ð޸ĵļǼÊý

2014-04-18 16:19 by BIWORK, 5912 ÔĶÁ, 7 ÍƼö, ÊÕ²Ø, ±à¼­
ÕªÒª£º¿ªÆªÓïÔÚÕâƪÈÕÖ¾ÖÐÈçºÎÔÚ ETL ÏîÄ¿ÖÐͳһ¹ÜÀíÉÏ°Ù¸ö SSIS °üµÄÈÕÖ¾ºÍ°üÅäÖÿò¼Üa56爆大奖在线娱乐½éÉܵ½ÁË°ü¼¶±ðµÄÈÕÖ¾¹ÜÀí¿ò¼Ü£¬ÄÇôÕâ¸öÖ÷ÒªÊÇÕë¶Ô°üÕâÒ»¸ö²ã¼¶µÄ Log ÐÅÏ¢£¬°üÀ¨°ü¿ªÊ¼Ö´ÐкͽáÊøʱ¼ä£¬ÒÔ¼°¸÷¸ö°üµÄÖ´Ðгɹ¦»òÕßʧ°Ü״̬¡£µ«ÊÇa56爆大奖在线娱乐ÃÇ¿ÉÒÔ¸ü¼ÓÉîÒ»²ã´ÎµÄ½«ÈÕÖ¾¼Ç¼ Logging ÒÔ¼°Êý¾ÝÐÅÏ¢ Aud... ÔĶÁÈ«ÎÄ

΢ÈíBI Ö®SSRS ϵÁÐ - ʹÓà LookupSet ºÍ Adjacent Group µÈ¸ß¼¶¼¼ÇÉÔÚ±¨±íÖпç Dataset ·Ö×é²éѯ

2014-03-24 21:28 by BIWORK, 4200 ÔĶÁ, 2 ÍƼö, ÊÕ²Ø, ±à¼­
ÕªÒª£ºSSRS ±¨±íÖÐÓÐһЩ¸ß¼¶µÄ¼¼ÇÉ£¬Æ½³£ºÜÉÙÓõ½£¬ÏÂÃæa56爆大奖在线娱乐ͨ¹ýÕâ¸ö°¸ÀýÀ´Õ¹ÏÖÒ»ÏÂÈçºÎÔÚʵ¼Ê¿ª·¢ÖÐʹÓÃËüÃÇ£¬²¢ÇÒÈçºÎ½â¾öһЩʵ¼ÊµÄÐèÇó¡£ÕâÕű¨±í·Ö±ðͳ¼ÆÁ˲»Í¬µÄ Product ²úÆ·ÔÚ²»Í¬µÄÔÂ·ÝµÄ Order ¶©µ¥ÊýÁ¿, Due ¸¶¿îÊýÁ¿ºÍ Ship ×°´¬ÊýÁ¿¡£Start Date ºÍ End Date ... ÔĶÁÈ«ÎÄ

΢ÈíBI Ö®SSRS ϵÁÐ - ÈçºÎʵÏÖ±¨±í±êÇ©µÄ±¾µØ»¯ - ÖÐÎĺÍÓ¢ÎĵĻ¥»»

2014-03-03 23:12 by BIWORK, 1927 ÔĶÁ, 2 ÍƼö, ÊÕ²Ø, ±à¼­
ÕªÒª£ºSSRS Öв¢Ã»ÓÐÖ±½ÓÌṩ±¾µØ»¯µÄÅäÖ÷½Ê½£¬Òò´ËÔÚ SSRS ÖÐʵÏÖ±¾µØ»¯£¬±ÈÈçÓÐÓ¢ÎıêÌ⻹ÓпÉÑ¡µÄÖÐÎıêÌ⣬¾ÍÐèҪͨ¹ýÆäËüµÄ·½Ê½À´½â¾ö¡£±ÈÈçĬÈÏÊÇÕâÑùµÄÓ¢ÎıêÌâ -µ«ÊDZ¾µØÖз½Óû§¿ÉÄܱȽÏϲ»¶¿´µ½ÕâÑùµÄ±êÌâ -a56爆大奖在线娱乐ÃÇ¿ÉÒÔͨ¹ýÒÔÏ·½Ê½À´ÊµÏÖ -´´½¨Ò»ÕÅ·­Òë±í£¬ÕâÕÅ·­Òë±í½«ÅäÖÃËùÓÐÐèÒª±¾µØ»¯µÄÖÐÎĺÍÓ¢ÎÄ... ÔĶÁÈ«ÎÄ

ÈçºÎÔÚ ETL ÏîÄ¿ÖÐͳһ¹ÜÀíÉÏ°Ù¸ö SSIS °üµÄÈÕÖ¾ºÍ°üÅäÖÿò¼Ü

2014-02-19 02:00 by BIWORK, 13736 ÔĶÁ, 17 ÍƼö, ÊÕ²Ø, ±à¼­
ÕªÒª£ºÒ»Ö±×¼±¸Ð´ÕâôһƪÓÐ¹Ø SSIS ÈÕ־ϵͳµÄÎÄÕ£¬µ«ÊÇ·¢ÏÖºÜÄÑÒ»´ÎдµÄºÜÍêÕû¡£ÒòΪÕâƪÎÄÕµÄÄÚÈÝ¿ÉÀ©Õ¹µÄÐÔÌ«Ç¿£¬Ã¿¶àÀ©Õ¹Ò»²¿·Ö¾ÍÒâζ×ÅÐèÒª¸ü¶à´úÂ룬ʾÀýºÍÀíÂÛÖ§³Å¡£Òò´Ë£¬a56爆大奖在线娱乐Ñ¡Ôña56爆大奖在线娱乐¾õµÃ±È½ÏͨÓÃµÄ LOG ²¿·Ö£¬ÔÚÕâÀï·ÖÏíһϸø´ó¼Ò£¬Ï£Íû¶Ô´ó¼ÒÔÚÉè¼Æ ETL µÄÈÕ־ϵͳʱÓÐËùÆô·¢ºÍ°ïÖú¡£µ±È»ÔÚÕâÀïÒªÇø·Ö... ÔĶÁÈ«ÎÄ

SQL Server - °ÑÐÇÆÚÒ»(ÖÜÒ»)µ±×÷a56爆大奖在线娱乐ÐÇÆڵĿªÊ¼ÔÚÒ»ÄêÖÐÇóÈ¡ÖÜÊý

2014-02-12 22:46 by BIWORK, 27279 ÔĶÁ, 2 ÍƼö, ÊÕ²Ø, ±à¼­
ÕªÒª£ºÏȸÐ̾һ¾ä£¡ºÃ³¤Ê±¼äûÓиüв©¿ÍÁË£¡Å¼¶û¿´µ½Ò»¾ä»°£¬¾õµÃ±»µç»÷ÁË - Ó¹ÈË°ÜÓÚÀÁ£¬ÄÜÈË°ÜÓÚ°Á£¡Òò´Ë£¬²»ÄÜÔÙÀÁ¶èÁË£¡½ñÌìÏëдһ¸öÓйؼÆËã Week Number µÄº¯Êý£¬¸Õ¿ªÊ¼¾õµÃÓ¦¸ÃºÜ¼òµ¥£¬Æ¾×ŸоõÆßд°Ëдµ½×îºó·¢ÏÖԽдԽÂÒ£¬µ½×îºó¸ãÁË¿ìÁ½¸öСʱÒÔΪ½â¾öÁË£¬½á¹ûÒ»²â»¹ÓкöàÊý¾Ý²»ÕýÈ·¡£·Ç³£Óдì°Ü¸Ð£¡¸Ð¾õºÜ²»·þÆø£¬¾õµÃºÜ¶ªÈË£¬ÅܳöÈ¥Õ¾Á˻ᣬÀä¾²ÏÂÀ´£¬ÖØÐÂÄÃÆðÖ½±ÊÈÏÕæµÄ·ÖÎöÁËһϣ¬Á¬Ð´µ½²âÊÔ¿ì°ë¸öСʱ»¹Êǽâ¾öÁË¡£ÔÚ SQL Server ÖÐĬÈÏÇé¿öÏ£¬Ã¿ÖܵĿªÊ¼¶¼ÊÇ´ÓÖÜÈÕ¿ªÊ¼ËãÆðµÄ¡£µ«ÊÇÔÚ¹úÄÚÒ²Óв»Ò»ÑùµÄÒªÇ󣬱ÈÈç°´ÕÕÏ°¹ßÍùÍùÒªÇóÿÖÜ´ÓÖÜÒ»ËãÆð¡£ÕâÑùÒ»À´Ö®Ç°ÔÚÊý¾Ý²Ö¿âÖÐµÄ Week Number ÔĶÁÈ«ÎÄ
ÉÏÒ»Ò³ 1 2 3 4 5 6 ¡¤¡¤¡¤ 8 ÏÂÒ»Ò³