Viewing 15 posts - 46 through 60 (of 188 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...
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
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' +
...
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
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)...
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
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?
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
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...
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
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....
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
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
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
October 14, 2009 at 2:56 pm
I think this link covers your needs quite well. Windows Scheduler can start your job this way.
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
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...
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
October 14, 2009 at 11:11 am
hodgy (10/14/2009)
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
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,...
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
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...
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
September 8, 2009 at 11:35 am
I've googled 'SSAS Excel 2007' and found several links that look useful...
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
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...
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
September 5, 2009 at 7:11 am
What's it about? I don't read French very well...
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
July 1, 2009 at 4:41 am
Viewing 15 posts - 46 through 60 (of 188 total)