Search results for query: *

claire, I have also been thinking on ,going according to No.3 Thank you for the suggestion Rick

Hi, I had posted this yesterday, but since I didnt get any response Iam posting it again. Iam having a SQL database replicated to a webserver.It is using snap shot repl and the prob now is that as the data grows it takes time when the snapshot is applied, so the webcontent goes blank for abt...

Iam sorry abt that case described.Actually some tables used in replication does not have P. keys.So transactional cannot be an option.Iam looking for a work around for this Thanks Rick

Hi, Iam having a SQL database replicated to a webserver.It is using snap shot repl and the prob now is that as the data grows it takes time when the snapshot is applied, so the webcontents goes blank for abt 2-3 mins.I had first tried transactional , but as the keys(PK) were not getting...

I need to write a procedure for : I have a table- tab1 which has cols- ikey,status and place. I have another table tab2 which is to be updated/inserted which also has the same cols and more A row present in tabl1 where the ikey is same as that in tab2 and has tab1.status = a and tab1.place =...

Hi, Iam replicationg db7 database in one server to db6 in another server. In db6 when I select the rows from a table in using EM ,it gives " [Microsoft] [ODBC SQL Server Driver]Timeout expired" error.What could be the cause of this error and how can I overcome it ? Thanks Rick

Thanks.This is want was required.But Can we have a query without using the count function? Thanks again Rick

Hi, I have a table T1 which contains style(PK) and Product and another table T2 which contains style (PK) and some other cols.I want the result as 1 if all the styles of a product in T1 exists in t2 otherwise 0.How Can I write a query ,can somebody help. Rick

Hi, I want to find out the carriage return in a string. I tried \n and \r but that doesn't seem to work Can somebody help Thanks Rick

Thanks Terry , that worked.But I have to use this file on a scheduled basis to update a SQL table.Every time padding rows will not be practical.Is there any work around? Rick

Hi, The file is fixed length.All the rows are not of the same length.The truncation occurs on some rows only. Later I also found that some 4-5 rows were missing too. I tried the option of inserting blanks (space)at the end of first record. It takes the full length of the data ie truncation...

Hi, Iam trying to bring data from a text file to sql server table using DTS. The last 4 characters of the last field are getting truncated after dts is executed .I cannot extend the column break for the last field (Beyond the red line)in dts for the text file.Is there a limitation for the...

Here it is SELECT distinct recep.id AS rID, recep.NUM, recep.remark, recep.name, recep.year FROM recep INNER JOIN recepType ON recep.TypeID = receptype.id LEFT OUTER JOIN Calrecep ON recep.year = Calrecep.year AND recep.NUM = Calrecep.NUM...

Hi, Is there any method to achieve DISTINCT with text datatype columns. Sql doesnt allow DISTINCT with text columns.Even though I dont need to use distinct directly to a TEXT column, text columns which is part of a join is creating problems Thanks Rick