Hi

Nice design RbarryYoung. A slight variation from your design.

AssnType in DemoAddr_Assn can also keep that a particular address is the good one. So we can avoid AddID column in...

Hi

There is not a great difference between SQL 2005 & SQL 2008. Since you have no previous experience on SQL Server it does not make a big difference whether you...

I assume this is what you want

Select col1,col2... from table1 where col2 between 2007/01/01 12:00:00:000' AND '2007/02/28 23:59:59:997' .

Check if this works...

Declare @sql VARCHAR(MAX)

SET @sql = 'SELECT * FROM (

SELECT UNIQ_ID,COMPANY_ID,COMPANY_CODE,COMPANY_NAME,BRANCH_ID,BRANCH_CODE,BRANCH_NAME,TRANS_ID,SNO,POSTING_DATE,DOCUMENT_TYPE,DOCUMENT_NO,DOCUMENT_DATE,CONTROL_ID ACCOUNT_ID,CONTROL_CODE ACCOUNT_CODE,CONTROL_NAME ACCOUNT_NAME,DR_AMT,CR_AMT,BALANCE,ACT_DR_AMT,ACT_CR_AMT,INST_NO,INST_DATE,NARRATION,REMARKS,CURRENCY,GROUP_CODE,GROUP_NAME,(CASE ACCOUNT_TYPE WHEN 'E'THEN 'EXPENSES'WHEN 'I'THEN 'INCOME' WHEN 'Assets'THEN 'APPLICATION OF FUNDS'WHEN 'Funds Transfer'THEN 'APPLICATION...

if your bigint value exceeds the maximum value for int then its not possible to convert.

No not in a stored proc in SQL 2005. You can use XML variable instead or use a table valued function if possible in your case.

Can u tell us the specific error that you are getting. Did you try declaring the variable as Varchar(MAX). Incorrect syntax does not always mean variable size issue, it could...

Chris Morris (12/30/2008)

---

Mark (12/29/2008)

---

Does anyone know how to create an addition column in sql.

For example, I have a column called POINTS. This column stores the total points a user...

Well you could join on the date columns and use CASE in the select query so that for 03/01/2008 emp is null.

Thing is why do u want such a...

Hi

Seems to be a registry issue. I read somewhere that reinsatlling mdac might solve the issue not sure though. Saw a lot of links in google about the issue. Try...

Check for existing data in the table or check how the data is getting inserted into the table.

One of the diff ways

-- to find out columns of DB1.TableA which are THERE IN DB2.TableA

select * from DB1.information_schema.columns A

WHERE column_name = SOME (SELECT column_name from DB2.information_schema.columns B WHERE...

Santhosh (12/23/2008)

---

Chirag (12/23/2008)

---

Hi

Iam afraid you will have to write your own storedproc/ trigger. I cant do that for you. If you know oracle then doing it in SQL should not...

Hi

Well iam going off now and will be on leave for a couple of days so cant go in detail.

The best way to do this is to use the tally...

what do you mean by free days.