Development

• Topics

  Started by

  Posts

  Last post

• Dynamic Select in cursor

  Hi sorry for question, but I didn`t find answer. can i do something like; declare @i int cursor beg…

  gorenak

  4 replies

  13 years ago

  By: t.brown 89142

• Neew help in Query please

  I need to do a pull in each db.... Thanks in advance for help... --------------------- Server: Msg …

  Ghanta

  2 replies

  13 years ago

  By: satish.setti

• SQL Server XML QUERY Parent and Client node together

  Hello, I'm having a XML file in this structure <Class> <ClassNumber>111</ClassNumber…

  mistryman06

  1 replies

  13 years ago

  By: Matt Miller (4)

• Internet Movie Database

  I'm a big fan of Internet Movie Database, but there are a few points on which it cou…

  Chris Xavier

  2 replies

  13 years ago

  By: Jay Pete

• Store proc or trigger

  I have a situation where, we have SQL Server 2005 Standard edition SP4 - Over 100 little table per…

  hp_dba_uk

  3 replies

  13 years ago

  By: Orlando Colamatteo

• Database Size

  In My Production server i am facing following problem. Totally my database size showing 134 GB.But …

  vs.satheesh

  6 replies

  13 years ago

  By: Divine Flame

• Help with trending db growth

  I have a script that runs nightly that shows that size of each database on the server. I would like…

  Mike Gray-474150

  4 replies

  13 years ago

  By: naga.rohitkumar

• UDF In SQL 2005 when invoked throws error msg 512: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

  Hi, I have a UDF in SQL 2005 that throws the following error when invoked by a select query. msg 51…

  dilbagh.king

  2 replies

  13 years ago

  By: dilbagh.king

• create procedure with execute as

  I have stored procedure which includes bulk insert, activating and deactivating the access to xp_cm…

  Chuck 17099

  14 replies

  13 years ago

  By: Orlando Colamatteo

• QUERY: Daily database size occupation

  Hi all... while trying to find which of the 40 databases in the server is growing without control I…

  emfigueiredo

  3 replies

  13 years ago

  By: emfigueiredo

• Select Statements in Stored Procedure gets Error converting data type DBTYPE_DBTIMESTAMP to datetime.

  I have a select statement that executes successfully by itself, so I used it in an stored procedure…

  Juan Sanchez-352749

  9 replies

  13 years, 1 month ago

  By: CynthiaCols

• Step by Step approach to add an identity colum to an existing table.... Please Comment...

  I have an existing Person table with about 4 million rows. I have an existing PkeyColumn, PersonId,…

  mmgorman

  6 replies

  13 years, 1 month ago

  By: SREERAJ. R

• procedure

  Could not find server 'SGEXP01' in sysservers. Execute sp_addlinkedserver to add the server to syss…

  eboucicaut

  2 replies

  13 years, 1 month ago

  By: Lowell

• Pivot query

  I have the following data... uid fieldid vaue 11725000 11725001 Development,support,man…

  rabisco

  7 replies

  13 years, 1 month ago

  By: rabisco

• How to get current week as 0 for any year using week

  Hi, I need to display current week as 0 for any year in the report......using week column in week t…

  84gopi

  4 replies

  13 years, 1 month ago

  By: 84gopi