I think there must be something with the database because a new table in the same database produces the exact problems. When I created the new...
Here are the results from the queries. The table count has changed due to daily processing that we cannot defer to another table. select count(*)...
I performed the following code and still the same problem in the new database and new table. Select * Into CDRArchiveNew.dbo.tbCDRArchiveNew...
I executed “Select Count(*) FromCDRArchive.dbo.tbCDRArchive WhereCDRRecordID Is Nullâ€, and had 0 records.
The table is not replicated, and CDRRecordID is an identity column. The seed is (1, 1) and should not have any nulls.
I have a table, tbCDR, with 40 columns, one is an identity column called CDRID,another column is AdminRate, which is a decimal(16, 9) and is...
It is an update statement to whatever table I'm updating. I have this template for most of my update statements, and I thought it was working just...
I'm having a problem with my error handling, it's not working. Here's my code... AS Declare@StartDate Datetime, -- Insert Start Date/ Time...
Yes, it works in QA, but not in EM. Thank you very much.
Gives me the selection I want, but when I apply that to the formula property I get an error. Also, if I put in just Substring(CallRecord, 15, 10) in...
SELECT count(*) FROM your_table_name where ISNUMERIC(Substring(@CallRecord, 15, 10)) = 0 zero records.
SELECT count(*) FROM your_table_name WHERE LEN(CallRecord) < 15 returns zero records.
I'm not trying to execute a SQL statement, I'm adding a new field in a table, and instead of setting the data type, I'm using a formula. When I exit...
I'm trying to use multiple functions within a formula property for a field and I'm receiving a message saying that there is an error validating the...
Can you create relationships between 2 tables in different databases on the same server? If so, how?
Satya SKJ, thank you for the information. Sad to say, it hasn't worked. The option to drop the subscriptions returns an error stating that it...
I have a problem with a subscription. Last week, we lost a database due to some hardware issues. We restored the database from tape, and now I need...
Separate names with a comma.
