use this code to create the default constraint.

ALTER TABLE tbl_nm

ADD CONSTRAINT DFLT_Tblnm_Columnnm DEFAULT default_value for [column name]

Hi Unnati, see below.

1) Have a SQL Function to validate the file name. Make sure the sql function returns either 0 or 1 upon failure or success.

2) Pass the file...

What do you mean to say, when you want to pass 16 in the code. It's not even a valid...

You can do it in different ways.

1) Have a table with all file names and using for each loop get the file name in an order and use it.

2) If...

I believe the problem is with impersonation. What you might need to do is

1) See if your OLAP Service is started(Quick check in the services).

2) Open the cube, double click...

If the format keeps changing you can try using a Script task as Destination and you need to use a significant amount of code, I tried once.. I will try...

what do you mean when you say, code is not saving? If you have recently renamed the file using sp_rename and trying to pull the procedure using sp_helptext, I have...

Try this...

SELECT DISTINCT sttckt, stdescr

FROM @Input t1

WHERE stdescr <> 'freight'

AND EXISTS (SELECT 1 FROM @Input t2 WHERE t2.sttckt = t1.sttckt AND t2.stdescr = 'Freight')

Good Luck 🙂 .. visit www.sqlsaga.com...

refer to this post...

http://sqlsaga.com/sql-server/how-to-calculate-running-totals-in-sql-server/[/url]

step by step explained...

Erland Sommarskog (7/21/2013)

---

DECLARE @X XML = '<Movies>

...

Thanks Steven..

Thanks Alan. Worked well for me.

sarwaanmca (12/10/2012)

---

Hi,

I Successfully Imported the Following XML File ...

Again I Want to Export (Generate) the Same XML File Format...

Using The Output Data (Table Value )....

How To Generate XML File...

pls Any...

U.T (12/31/2012)

---

Can anyone point out what is wrong with following query

declare @Territory varchar(max)

set @Territory = 'Domestic'

SELECT *

FROM Account

WHERE PrimaryCountry IN (CASE WHEN @Territory = 'Domestic' THEN 'USA, CAN' ELSE PrimaryCountry...

Select *

from demo d

INNER JOIN elections e ON e.sno = d.sno

Inner join electionshist esh ON esh.ssno = e.ssno and esh.sno = d.sno

where d.status <> 't'

and e.electionstartdate is null

and e.electionstermdate...