Viewing 15 posts - 331 through 345 (of 390 total)
anthony.green (7/4/2012)
REPLACE will work with underscores
DECLARE @OrigString VARCHAR(100)
DECLARE @SearchFor VARCHAR(100)
DECLARE @ReplaceWith VARCHAR(100)
SET @SearchFor ='DBName'
SET @ReplaceWith = 'Replaced_DBName'
SET @OrigString = 'Newdb.[DBName].dbo.TableName'
SET @OrigString = REPLACE(@OrigString, @SearchFor, @ReplaceWith)
SELECT @OrigString
What about this
DECLARE @OrigString...
--rhythmk
------------------------------------------------------------------
To post your question use below link
https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
š
July 4, 2012 at 5:30 am
No š
I lost the 7 points as did not see the movie š
--rhythmk
------------------------------------------------------------------
To post your question use below link
https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
š
July 4, 2012 at 5:16 am
Ray K (7/3/2012)
Brandie Tarvin (7/3/2012)
crookj (7/3/2012)
rhythmk (7/2/2012)
Revenant (7/2/2012)
Brandie Tarvin (7/2/2012)
RumbaRoomba
Brazil
brazier
bazaar
bizzare
A bizzare turn of events for Azzurri in EURO 2012 and Spain proved themselves best again.A team to beat.
Spain !!!!!
--rhythmk
------------------------------------------------------------------
To post your question use below link
https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
š
July 3, 2012 at 10:33 pm
Koen Verbeeck (7/3/2012)
rhythmk (7/3/2012)
Koen Verbeeck (7/3/2012)
Are we talking about SSIS 2012 environment variables or Windows environment variables?
Hey Koen,
Correct me if wrong we can't use SSIS 2012 environment variables in SSIS...
--rhythmk
------------------------------------------------------------------
To post your question use below link
https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
š
July 3, 2012 at 3:44 am
Koen Verbeeck (7/3/2012)
Are we talking about SSIS 2012 environment variables or Windows environment variables?
Hey Koen,
Correct me if wrong we can't use SSIS 2012 environment variables in SSIS 2005.
--rhythmk
------------------------------------------------------------------
To post your question use below link
https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
š
July 3, 2012 at 1:54 am
Also have a look on below article.
http://sqlinthewild.co.za/index.php/2009/08/17/exists-vs-in/
--rhythmk
------------------------------------------------------------------
To post your question use below link
https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
š
July 3, 2012 at 12:38 am
Mark Eckeard (7/1/2012)
--rhythmk
------------------------------------------------------------------
To post your question use below link
https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
š
July 3, 2012 at 12:28 am
Revenant (7/2/2012)
Brandie Tarvin (7/2/2012)
RumbaRoomba
Brazil
--rhythmk
------------------------------------------------------------------
To post your question use below link
https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
š
July 2, 2012 at 10:41 pm
Sagar Sawant (7/2/2012)
I am using SET ROWCOUNT because the value comes from a parameter into my procedure.
SET ROWCOUNT @take
SELECT * FROM Something
SET ROWCOUNT 0
Is it possible to another...
--rhythmk
------------------------------------------------------------------
To post your question use below link
https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
š
July 2, 2012 at 3:51 am
eatemadnia.f (7/1/2012)
i want to import a big text file with a fixed record length(288) to tables.i need to read a record and check it then call a store procedure...
--rhythmk
------------------------------------------------------------------
To post your question use below link
https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
š
July 2, 2012 at 12:10 am
cadm777 (6/28/2012)
The table I need to pull data from has a column called LASTUPDATE(datetime). When a new balance is reached for the data,...
--rhythmk
------------------------------------------------------------------
To post your question use below link
https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
š
July 1, 2012 at 2:26 pm
mgee1038 (6/30/2012)
I need to be able to get the last date earlier than a parameter entered date.
I write a function...
--rhythmk
------------------------------------------------------------------
To post your question use below link
https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
š
June 30, 2012 at 8:25 pm
denisribeiro (6/29/2012)
Sometimes, some action, triggered for someone blocks the database, in other words, querys that should be executed quickly, takes too long.
Question:
Is there some tool that could help me to...
--rhythmk
------------------------------------------------------------------
To post your question use below link
https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
š
June 29, 2012 at 7:21 am
Sean Lange (6/28/2012)
rhythmk (6/28/2012)
Mahesh Gupta-325917 (6/28/2012)
Lets say in table1, I have data saying 4,2,3,1
Now I need...
--rhythmk
------------------------------------------------------------------
To post your question use below link
https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
š
June 29, 2012 at 12:05 am
achen9291 (6/28/2012)
--rhythmk
------------------------------------------------------------------
To post your question use below link
https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
š
June 28, 2012 at 11:14 am
Viewing 15 posts - 331 through 345 (of 390 total)