Hi,

i m taking copy of existing phone number table every week. So if i take copy this week it is different than last week copy. It might happen that in...

Hi,

i think it might be problem with ur table name sys.foreign_keys. please check the name of table. there is no obvious ? sysntax error anywhere.

regards,

vijay

Hi there,

i have got the same problem and i found solution as primary key on internet. But it is something more required to solve it.

Please insert one column in...

Hi,

If you have 10 years of experience then i believe there is no need to do your bachelor's degree. As when you apply for job it says equivalent experience of...

Hi,

i was getting same error. The solution is when you select each field you need to specify default database collate as mark said.

e.g.

select field1 Collate database_default, field2 Collate database_default

from...

hi,

please clarify whether online and student is just a text or table.?

regards,

vijay

Hi,

If you dont want to generate report automatically, then you should not select default value. When you define report parameter, you can just select dafault as NULL so that it...

Hi,

i believe u need to use crosstab queries. Here is 2 link which will be useful for you.

http://www.sqlmag.com/Articles/Index.cfm?ArticleID=15608&DisplayTab=Article

http://www.simple-talk.com/sql/t-sql-programming/creating-cross-tab-queries-and-pivot-tables-in-sql/

regards,

vijay

Hi,

it happens with me as well. I tried 2-3 times and it worked. But the best way is to save it as CSV file and then save it to XSL...

Hi,

just wondering what you mean by delete it? You can deploy report to some place and you have copy saved some where on your machine or server.

What you mean?...

Hi,

If you are taking column from different database then when you join two column you have to specify "collate latin1_general_ci_as" after name of the column.

say left outer join on this.that...

hi,

it works fine. thank you for your help.

regards,

vijay

Hi,

there is no first function in SQL Server. So First(ward) cant work.

thanks,

vijay

Hi,

You can schedule your package in 2005 as below. Please refer the link.

http://www.sql-articles.com/articles/schedule_SSIS_package.htm

thanks,

vijay

Hi,

it is first from table X. I have 4 fields in the table.

Table X -

reference date ward code

1001...