Search results for query: *

Based on my understanding. Let us know if that is correct. Select m.*, d.* from master m inner join detail d on m.pk=d.fk where m.name ='something'

Looks like YOG is an alias for StudMR.StudMRGradYear. So replace StudMR.StudMRGradYear wit your new case statment. Make sure you put END at the end of case statement.Same thing has to be added to your group by also. HTH

Another solution without using sqlserver is using a datamodel tool like Erwin, visio, powerdesigner to do a reverse engineering for a table and generate ddl from the model.

Do you want to combine the total of WHAT? or Do you want to concatenate the fields 20U,20A,20W?

[SQL Server Destination [52]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E07. An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80040E07 Description: "Error converting data type DBTYPE_DBTIMESTAMP to...

Is there a text file stored in a local drive for the execution results after the is package executed? Sometimes the message in execution result is truncated unless I copy and paste the message into a notepad. So I like to see if these results are stored somewhere else? TIA

Try this SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition') HTH

Created a FK after a 1.5million records table being loaded. Is there any draw backs for doings this? Do I need to rebuild the indexes? or reindex is automatic after creating the FK? TIA

OK. Thanks. I will try.

I have a sql task which takes tablename as a parameter and writes in a file with tablename as part of the file name. Unique table names can be available from a table. Right now I am generating one file at a time inputing the table name every time. Can I do this task using a Foreachloop...

Is your TEST CONNECTION working OK?

Found it. It is on deleted table.

If I have a base table customer with custid, name1, name2, add1, add2, begdate, enddate. And I have a update on name2 and add2 then I want to capture the change and write in a staging table with the whole old record except the enddate. Enddate I want to put the current date. Is that old...

I know it looks like dangerous but it is not. Thanks for your response. Yes, we need to execute this temporary proc to create the trigger. We drop the temporary proc after creating the trigger. Thanks any way. If I am doing this from the scratch, I do not go with this approach but we are...

Is there any filters at the destination?

Only reason I am using SSIS is to append the text to a file. What I am doing is inserting the standard script in to a text and using the table name as a parameter and getting the columns information from the system tables. This is a template sql for moving data from base to staging tables. So...

I want the syntax for something like this create proc if condition then create trigger else do soemething. TIA

Got it. select publication from distribution.dbo.mspublications

I have a base table and audit table are like this SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[Mytest]( [TestID] Int NOT NULL, [TestDesc] [varchar](35) NOT NULL, [EffBegDate] [datetime] NOT NULL, [EffEndDate] [datetime] NOT NULL, PRIMARY KEY CLUSTERED (...

How to select the current publisher? Is there a query? I can look in SSMS under replication/local publications. But is there a query I can use for some programming? TIA