you will probably need to unpivot the second table to join, but without any DDL and sample data it's hard to give you the code to do it

do you have any sample data with expected results? It's hard to determine what you need without seeing the function, tables, data, etc.. Also, what have you tries...

I'm glad to hear you found the answer. Just an FYI, BOL stands for Books On Line. if is a set of documentation that Microsoft creates to help...

There are limits to the max and min dates allowed for Samlldatetime date types. Look in BOL.

give this a try

declare @temptrans table (rn int, accno int, trandate smalldatetime,

classification char(3), runningtotal tinyint)

insert into @temptrans

SELECT 1 [RN], 1234 [Accno], '01/01/2010' [TranDate] , null, null UNION ALL -- c1

SELECT...

I don't remember, but...

Have you tried using OpenQuery instead?

Select * from OpenQuery(MyLinkedServer,'Select * from MySchema.MyTable')

In SSMS, expand table B and go to keys. Right-Click FK and select modify. Under Table Designer, expand INSERT And UPDATE Specific, Unde Delete Rule Select Cascade....

how are the foreign keys setup? If they are setup as Cascade Deletes, then just deleting the records from Table A will also delete the records in Table B...

here's a proc that I use to get the status of a job. I put it in the master db, that's why the naming convention

Create procedure [sp_IsJobRunning]

...

How big is the XML you are passing in? I've seen issues where if this is large, then it will take a while to parse through it. I've...

try a CTE

CREATE TABLE [dbo].[test](

[EnrolleeID] [int] NULL,

[LanguageID] [int] NULL,

[LanguageName] [varchar](20) NULL

)

GO

INSERT INTO [dbo].[test]([EnrolleeID], [LanguageID], [LanguageName])

SELECT 20, 1, N'English' UNION ALL

SELECT 20, 2, N'Spanish' UNION ALL

SELECT 20, 3, N'Portugese' UNION...

sounds like it's specific to the file. Can you provide a sample file as well as the table layout you're trying to import into?

as part of the sp_addarticle procedure used to publish the articles for replication, one of the parameters is @filter_clause. I've never used it, but you could potentially put a...

The where vctmovementmonth = jan-10 is limiting what is coming back, so you won't be able to compare the MovementMonth calc the way you have it. Try using an...