Search results for query: *

I figured it myself! here is the code that will end this problem... myReport.Load(m_crystalfilename); DataSet ds = new DataSet(); ds = GetCrystalData(); for (int tableIndex =0;tableIndex<ds.Tables.Count;tableIndex++) {...

Yes! It runs fine in crystal designer. Its looking for a DSN defaults to that even though i'm giving it a report document with data in it. the crystal viewer is not binding well with the report document looks like! i dont understand where this dsn is coming from that its defaulting to on the web...

I get "The report you requested requires further information" no matter what i do to run a report, it displays few text boxes for entering login info on the IE 7.0 .NET 2005 (c#) front end CR 10 advanced developer ours is a table driven report display system.the user clicks on a report and...

Yes! it runs fine when i run the value in @cmd from the command window. its confusing why it wont work from a xp_cmdshell when the string is correct!!

sorry, placing double quotes does not do anything. the text file has spaces and i'm trucating it with a cscript and vbs file..which i placed in a batch file.no i need to run the batch file with a parameter from xp_cmdshell . the command i'm running to get this output text file is...

declare @client varchar(25), @outputfilename varchar(30) SET @client = 'MYCLIENT' SET @outputfilename = @client + '.txt' declare @cmd varchar(255) set @cmd = 'C:\Database\Disease_Registry\Common\ReleaseP4PandDR\TrimSpaces.bat ' + @outputfilename exec master..xp_cmdshell @cmd This code is...

The data is string data eg., 160:80 and i need the : to appear in the middle of 2 numbers in the cell and also want to save it! its like we are formatting the cell for user and while saving it i'll take the content of the whole cell and post it to the database (including the ':')

I need help formatting a column while displaying in a cell of a datagrid. The data will looklike 120:80. I need the user to see the cell as " : ". I'm using the DataGrid1_ItemDataBound event to format all my cells. to be precise If e.Item.Cells[17].Text is my cell and want to display in the...

I had a similar problem with the DateTime column while updating the datagrid! i have fixed it by placing a default value for dates instead of NULLS! so if you can update a value (for eg 0) in the database for all the nulls that might fix your problem

just my thoughts: if you are looking for user history, creating the table with UID column i think is good. you can avoid the primary key problem by choosing to create a unique index on columns(userID, userUID, enabled) If its just to do with accessing data one level up you can choose to...

overall it took only 2:min 37sec for first table (1.2mil rows) and just 22 sec for a next small file (153000 rows)....GREAT performance improvement from the suggestion of 'JohnDTampaBay' !! Hearty Thanks to John again!!

THANKS A TON BUDDY!! Seems like this is the correct solution, Running it right now will let you know... THANKS SO MUCH AGAIN!!!

I have a source table tim_clmHdr (claim_code varchar(20), diag varchar(6)) with 1356080 rows. claimcode repeats but not diag. I have a target table tbl_claimmaster(claim_code varchar(20), diag1 varchar(6), diag2 varchar(6), diag3 varchar(6), diag4 varchar(6)) with 1203607 I need to find...

in the last solution u found for yourself i have a comment..make sure that you sort the data in each table before you proceed with indentity insert..

Here u go... set quoted_identifier off drop table test create table test(a varchar(15)) insert into test values (1) insert into test values (2) insert into test values ('3abc') declare @sql varchar(50), @tmpFieldName varchar(10), @tmpFieldValue varchar(10), @OrderID varchar(10) set...

I'm using 'CDONTS' com object in a stored procedure to send the email. The same script works on the servers with 'sql and windows authentication' BUT does not work on servers with just 'windows only' authentication mode! no errors while executing the procedure and @hr returns a 0 BUT no email is...

i agree with nigelrivett but just a little change in quotes and u can paste this code as a job and schedule it using SQL Server Agent\Jobs in Enterprise Manager!! declare @sql set @sql = 'BACKUP DATABASE mydb TO DISK = ''\\Myserver\sqlbackup\mydb_' + convert(char(9), getdate(), 112) +...