Viewing 15 posts - 46 through 60 (of 187 total)
I know you posted in the 2005 group, but 2008 has probably the ideal solution for your problem: Table Valued Parameters. Or else I would make a second procedure that...
April 13, 2010 at 8:24 am
I forgot to add a space before the 1:
SET @sql = 'INSERT INTO rt_planTMP (departman,planlanangun) SELECT TOP ' + CONVERT(VARCHAR, @i)
+ ' 1, GUNLER' +
...
April 13, 2010 at 8:03 am
volkanalkilic (4/13/2010)
When i try use this code i get a:
"Subqueries are not allowed in this context. Only scalar expressions are allowed."
how can i solve this?
DECLARE @sql NCHAR(255)...
April 13, 2010 at 1:51 am
Killing other people's processes without notice is administering in a very bad way, nonetheless.
Calling something urgent without explaining is frowed upon on SSC. Did people die from it?
February 11, 2010 at 2:17 am
I guess the color coding in QA/SSMS does it? Paste it instead into Notepad++ or an equal text editor that has color coding for SQL, so you can't accidentally execute...
February 3, 2010 at 6:45 am
Do you have PAGE_VERIFICATION on the database? Seems to me a page was corrupt and with the restart repaired.
Looking at the query though, I would rewrite it to this....
October 16, 2009 at 5:21 am
r.hensbergen (10/14/2009)
I think this link covers your needs quite well. Windows Scheduler can start your job this way.
Err, and then I forgot to paste the link... http://blogs.msdn.com/michen/archive/2007/03/22/running-ssis-package-programmatically.aspx
October 14, 2009 at 2:56 pm
I think this link covers your needs quite well. Windows Scheduler can start your job this way.
October 14, 2009 at 2:55 pm
You have this code:
if @single_list_id is not null
set @list_conditions_query=@list_conditions_query+' and id='''+convert(nvarchar(36),@single_list_id)+''''
INSERT INTO #list_conditions (list_ID, conditions)
EXEC sp_executesql @list_conditions_query
Though I think the preferred way to pass variables into dynamic sql with sp_executesql...
October 14, 2009 at 11:11 am
hodgy (10/14/2009)
October 14, 2009 at 3:57 am
I completely agree with this, though I was this time lucky I found the bit this time. But this is not testing for knowledge about the meaning of bitwise comparising,...
October 14, 2009 at 3:24 am
I don't have DB2 experience, but I'll give it a try...
I think, if collation is an issue for table and column names, you should consider renaming them into names only...
September 8, 2009 at 11:35 am
I've googled 'SSAS Excel 2007' and found several links that look useful...
September 5, 2009 at 7:16 am
From your questions, it makes me think that you also have a disk space issue. Maybe the files are growing too fast, or you need to restore a database for...
September 5, 2009 at 7:11 am
Viewing 15 posts - 46 through 60 (of 187 total)