Given A date return the number of Sundays? Doesn't make sense.

Use isnull around each column: isnull(columnname,'')

I am curious as to what your error is. While looking at the code in your original post, I also noticed a "go" where you probably don't want one....

No, you can't define PK/FK relationships between tables in different databases.

Now for a dumb question, why are you using dynamic sql in this to strip the time.

/*

declare @sql as varchar(255)

declare @table_var table (data datetime)

set @sql='select ''' +...

Jack beat me to it, but you can also learn more about the patindex function in BOL (Books On-Line).

Sorry for taking a lot of space, but check out the following:

--We need to build a new ptEncounterEncounterDetail from the EncounterID,

--EncounterDetailID combinations where the Migration values are in the

--old ptEncounterEncounterDetail....

Also, I assume that ptEncounterEncounterDetailTemp has the same structure as ptEncounterEncounterDetail?

Just one thing missing, what should the expected results be based on the test data. Need something to check against.

new coder (10/30/2008)

---

Hi, I have a table let's call it Person. This table have many column, among which are 3 that I need to check their values.

1-Cell number

2-Home number

3-Work number

For...

Is the new filegroup on the same disk as it was before, or did you move it to its own drive? I'd probably move the nonclustered indexes to the...

Did a little "googling" and found that Unix records date as the number of seconds since 1970-01-01 00:00:00 UTC (GMT). With that, 1220140800 is Saturday, 2008-08-31 00:00:00 UTC.

Is 1220140801 October 1, 2008?

richard (10/30/2008)

---

OK, have done some further tests:

1. created new table:

CREATE TABLE TEST

REF INT NOT NULL,

DATE DATETIME NOT NULL

2. Inserted 4 rows - made sure that the REF was sequential...

eric (10/30/2008)

---

Hi Forum,

I need to create a Stored Procedure which will receive the name of a table as parameter and perform numerous operations (probably using a 'Curse her' :crazy:) on...