Search results for query: *

Sample case, the real one contaiins thousands of records with multiple companies and I just want the top 5 or N number of recors. COMPANY USER COMP_A gbuske COMP_A gcaldog COMP_A kdubell COMP_A lboldiz COMP_A rgronb COMP_A...

Sample case, the real one contaiins thousands of records with multiple companies and I just want the top 5 or N number of recors. COMPANY USER COMP_A gbuske COMP_A gcaldog COMP_A kdubell COMP_A lboldiz COMP_A rgronb COMP_A rbal...

all of them work for me thanks

Need help to count records each time it repeats if and only if the three colums are the same. Cliente Socio Prd other colums (do not care) client1 M_US Em client1 M_US Em client1 M_US Em client2 M_US Em client2 M_US Em client3 A_US HG...

I obnained the following code by using a tool. Could some one help me to create a visual basic code for the corresponding dll translation. STRINGTABLE LANGUAGE LANG_ENGLISH, SUBLANG_ENGLISH_US { 100, "mp" 101, "224 West Esp" 102, "New York" 103, "NY" 104, "000000" 105, "USA" 106...

SQL Denis I think I did not explain clearly test CSFB, ABN, C, BSC, BNPP, LEH, MER, BARX, BAS, FTN requests That is jus a sample your query get rid off test and request as expected but what happens if my query returns blah blah test CSFB, ABN, C, BSC, BNPP, LEH, MER, BARX, BAS, FTN requests...

Some comments declare a parameter like @v ='test CSFB, ABN, C, BSC, BNPP, LEH, MER, BARX, BAS, FTN requests' it won't work in my case because the list between test and requests could be different. I need to identify when I found test and get rid off all I have on the left including test. I also...

The following is an output of a single field select message from table a test CSFB, ABN, C, BSC, BNPP, LEH, MER, BARX, BAS, FTN requests I need a command just to get the list between test and request. Any help will be appreciated. Raul

Could some one provide a function to convert HEX TO BINARY?

How can I populated a GridView located in a aspx page from this class located in another utility project. public dsCompany selectCompany(string region, string type, string status, string shortname) { try { SqlDataAdapter da = new...

Need to populate a GridView (grdCompany) from a Dataset (dsClient). dsClient.Designer.cs has a class named CompanyTableAdapter Any help will be appreciated protected void Page_Load(object sender, EventArgs e) { CompanyTableAdapter companyAdapter = new CompanyTableAdapter()...

Thanks for the help, but something wrong happens when I run the store procedure with one of the parameters empty.It should execute the store procedure just with the parameters I passed with out required all of them to be submitted. EX SearchCompany 'us','Dealer','Active','' Returns 0 records...

I need help to create an store procedure that search a Company table passing 4 parameters.One of the requirements is to allow the user to combine those parameters. Parameters: Region_Name, Type (Client, Dealer), Status (Active, Inactive, Prospect), Name The company table has a foreing key from...

Can some one help me to change this vb code to c#. What it does is to read an xml file an store data into sql server database. Imports System Imports System.Data Imports System.Data.SqlClient Imports System.Data.SqlTypes Module Module1 Sub Main() Dim objSQLConn As New...

how to store XML in an SQL Server Database using C#

How can I store data from an xml file to a sql server data base? Thanks

Thanks

The following code generates myfile3.xml on the c drive. I have an xslt file to convert myfile3.xml the way I want. Can some one help me how to call my xslt file and apply this two my xml file.? SqlConnection connString = new SqlConnection("Server=mi...

XML FILE: <NewDataSet> <Table> <First_Name>Roberto</First_Name> <Last_Name>Cortez</Last_Name> <Email>r_cortex@test.com</Email> <Company_Name>My company</Company_Name> <Address_1>11 First st</Address_1> <Address_2>3rd Floor</Address_2> <City>Indianapolis</City>...