Saturday, August 9, 2008

Microsoft Dynamics AX 2009 demos

Hi, Microsoft Dynamics AX 2009 can help you meet the needs of your people as well as the evolving demands of your business. Watch the videos and learn more from resources that relate to four key business challenges



other videos at :

using SilverLight:

http://www.microsoft.com/dynamics/ax/product/demos.mspx

Using Windows Media Player:

http://www.microsoft.com/dynamics/ax/product/demos_wmv.mspx

Friday, August 8, 2008

Split string as Array in SQL

Hi,



i was in need to split string in T-sql but i can't find built-in function to do that, thereby i wrote a function to do the following:



By the use of T-SQL:



if you have string like "Ahmed,Eid,Salim" or Ids like "120,234,123,546"

and you need deal with that string as array on SQL DB Engine and find items of it.





The SQL Function like:

ANTIQR26
By: Favoshots
Views: 0
ANTIQR27
By: Favoshots
Views: 0
ANTIQR29
By: Favoshots
Views: 0
ANTIQR31
By: Favoshots
Views: 0
ANTIQR32
By: Favoshots
Views: 0
ANTIQR33
By: Favoshots
Views: 0
ANTIQR34
By: Favoshots
Views: 0
ANTIQR37
By: Favoshots
Views: 1
ANTIQR38
By: Favoshots
Views: 1
ANTIQR40
By: Favoshots
Views: 1
ANTIQR41
By: Favoshots
Views: 1
ANTIQRA
By: Favoshots
Views: 1
ANTIQRA2
By: Favoshots
Views: 1
ANTIQRA3
By: Favoshots
Views: 1
ANTIQRA4
By: Favoshots
Views: 1
ANTIQRA5
By: Favoshots
Views: 1