SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• Generating Next Numeric Strings

  Hi folks, sorry if this has been posted somewhere already - I thought it would be but I've searched…

  MH-1148887

  5 replies

  16 years ago

  By: GSquared

• stored procedure to csv

  Hi I need to create a SP and then export the results from it to a CSV file. However there seems to …

  guestuser31

  2 replies

  16 years ago

  By: guestuser31

• XML Data Type... Format of XML Data

  I am working with the XML data type. I have noticed the systax in the xml of: I am looking to ge…

  mhilligas

  11 replies

  16 years ago

  By: Johan Bijnens

• SQL teaser...easu for you pros !

  HI..I am stuck.. I have data like this... Data1 Data2 Data3 .... A 100 20* A …

  Digs

  5 replies

  16 years ago

  By: Digs

• create constraint on strings in table

  We have clients pushing data to us. I need to prevent them from inserting strings containing the fo…

  micheal_murphy

  3 replies

  16 years ago

  By: SQLRNNR

• Encrypted Procedues

  Hello, We are moving our DB from SQL Server 2000 to SQL Server 2005. One issue we have is in SQL Se…

  Yasir Masood

  2 replies

  16 years ago

  By: SQLRNNR

• Getting data from a different database

  I need to run a stored procedure from one database (which is working fine), but now I also need it …

  Brad Allison

  11 replies

  16 years ago

  By: SQLRNNR

• SSRS Prompt Customization

  Is there a way that we can turn off autocomplete for the prompt boxes in a sql report? We have a r…

  jim_piller

  1 replies

  16 years ago

  By: jim_piller

• How best to do concurrent, near real-time table updates

  Hi All We port data from our legacy mainframe system to SQL Server to support ad-hoc queries, Data …

  Nik A

  4 replies

  16 years ago

  By: thermanson

• How to create SSRS report with 2 diffrent datasources, Oracle 10g and Sql Server 2005?

  I am working on a report (in SQL Server Reporting Services 2005) that has two data sources, one is …

  swenri

  2 replies

  16 years ago

  By: swenri

• Can we configure SharePoint 2007.

  Resolved. Cheers, - Win. " Have a great day "

  - Win.

  1 replies

  16 years ago

  By: - Win.

• Column '(x) ' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

  Hi There, I am getting many errors because my group by clause is incorrect. Can someone please help…

  paula_sql

  25 replies

  16 years ago

  By: ta.bu.shi.da.yu

• Problem with a simple update query - Update value in row from value in previous identical row

  Hello I wondered if anyone could help. This is probably very simple. I have a table with three colu…

  conmcgarry

  15 replies

  16 years ago

  By: Supriya.S

• Returning max and min dates based on a group by

  I hope I word this correctly so it is not confusing. I have a stored procedure that is returning m…

  Brad Allison

  3 replies

  16 years ago

  By: LutzM

• Error while passing date variable in Open Query

  Declare @SalesMonth int Declare @SalesYear int DECLARE @TSQL varchar(8000) Set @SalesMonth = 5 Set …

  Shree-903371

  1 replies

  16 years ago

  By: Shree-903371