Search results for query: *

I am running crystal reports using a VB reports scheduler. This scheduler has been working fine for years with SQL Databases. I have now added a report which uses a Remedy ODBC as a datasource. This is a simple crystal report which runs and opens correctly within crystal reports itself. However...

I have a problem trying to run dynamic sql<>? when running the following query.. 'create ' + @dbname + '..tablename etc. this is all run as dynamic sql. The problem I am having is, the table being created is more than 8000 characters long...(defined as a sql command). The table has over 200...

I am writing a series of sql queries which go thru the following steps. 1. create the data base using a date extension.. 2. create a number of tables in the database created in step 1 3. populate the tables created in step 2 The problem I keep having is, even when I try to create the tables...

I'm trying to delete rows from a database table using a stored procedure. Unfortunately, I the transaction log keeps filling up. I think I should be able to delete successfully in batches of 50,000. How do I do this within a stored procedure... The only thing I'm sure about is I use a while...

I have created a sql query which executes another sql query within it. Unfortunately the query within is quite long and seems to exceed the 8000 limit for varchar. Does anyone have any ideas on how I can can execute this query... unfortunately, I can't split the query.. I am using a table which...

I am running a dynamic sql query which I have declared as varchar(8000). The query is longer than 8000 characters long. Does anyone have any ideas of how I can code this. Thanks Bunmi

I'm trying to display the following 'No entry', 'No exit' in the result set of a sql query (on two seperate lines)... using dynamic sql. could you please spot what I am doing wrong.. I cannot seem to get the quotes right!! here is the code declare @scomm1 char set @scomm1 = ' print ' +...

How do you create acomma delimited flat file from a sql table. I know how to do it using a print statement withing a cursor. but I would like to do it using a select staement only. (and not the cursor.) any ideas???

I tried adding columns to a table on a database manually. Unfortunately the database doesnt have a lot of free space, and on saving the columns, it was slowly running out of space. I made the decision to end the (sql enterprise) task via task manager. I am now unable to get into enterprise... I...

I am trying to create a database within a stored procedure, so that the database name is generated each time. Please review the attached code, as sql seems to error out on '@dname' select @iStatus = 0 select @dbname = 'offline' + '_' + convert(char(6),getdate(),112) create...

I keep getting the error 'TSQL subsystem failed to load, the job has been suspended'. This error happens on a SQL server job on a daily schedule. It only seems to occur occassionaly. This problem has occured twice in the last week. It doesnt seem to happen on a particular job step, but when it...