Viewing 15 posts - 20,101 through 20,115 (of 26,490 total)
Okay, my post above looks strange to me.
June 30, 2009 at 11:13 pm
Sample code for you to play with. You will need to put the data into a text file, and be sure to modify the line where I have the...
June 30, 2009 at 11:11 pm
Here is more code for you to take a look at and play with.
CREATE TABLE [dbo].[MainTable](
[DrugName] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CalendarYear] [int] NULL,
[CalendarMonth] [int] NULL,
[CalendarQuarter] [nchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PatientID] [nvarchar](255) COLLATE...
June 30, 2009 at 10:47 pm
The UDF is a Dynamic Tally table. Take the time to read the second to last article I reference below in my signature block regarding Tally tables. You...
June 30, 2009 at 10:29 pm
Nardig (6/30/2009)
June 30, 2009 at 4:51 pm
Not a replication specialist, but it looks like there are replication transactions that have not yet replicated to all subscribers. How space is bein used in the T-Log?
June 30, 2009 at 4:36 pm
You already have a thread open regarding this here.
Do not post responses here.
June 30, 2009 at 4:35 pm
I have no idea. You haven't provided us with anything to work with here.
June 30, 2009 at 4:13 pm
Gianluca Sartori (6/30/2009)
June 30, 2009 at 3:45 pm
Give the attached code a try. You need the code in both files.
June 30, 2009 at 3:34 pm
Are you entering any values into the Notes column during this process?
June 30, 2009 at 3:03 pm
Differences in the query engine. Perhaps in SQL Server 2000 the WHERE creteria ISNUMERIC(...) = 1 may have filtered records out before the creteria with the CONVERT on it...
June 30, 2009 at 2:46 pm
What is the recovery model of the distribution database?
June 30, 2009 at 2:33 pm
Just curious, but, since you are using litespeed are you compressing your backups?
June 30, 2009 at 2:04 pm
Gail, you'll like this one. The OP wants us to use our crystal ball to help solve his problem.
Don't know about you, but mine seems to be permanently cloudy.
June 30, 2009 at 1:56 pm
Viewing 15 posts - 20,101 through 20,115 (of 26,490 total)