Viewing 15 posts - 1,666 through 1,680 (of 3,221 total)
Found this, which might be useful to you:
Pattern matchingMatches patterns of characters
-- Author Gianluca Sartori
--http://www.sqlservercentral.com/Forums/Topic1008514-391-1.aspx
-- Table to hold the words to search for
DECLARE @Patterns TABLE (
...
October 21, 2010 at 1:10 pm
subhankar02dey
First I altered your T-SQL code:
set @d='select * from employees where'+@a+@b+@c;
PRINT @d -- added
---???????????????????????????WHAT TO DO TO EXECUTE @d?
return
Then executed the resulting SP as procedure1 'NY','ABC','SAM'...
October 21, 2010 at 8:25 am
Steve Jones - SSC Editor (10/20/2010)
I'll try to make it. Not sure about the timing
Thanks for considering it (us) ....
October 20, 2010 at 3:44 pm
Steve, nice info for a beginners tract on a SQL Saturday. Now how to lure you to SQL SAT #60 (Cleveland)...
October 20, 2010 at 3:24 pm
Blake
You will want to create a parameterized stored procedure along the lines of:
CREATE PROC [dbo].[Blake]
@Start DATETIME
AS
DECLARE @Syr VARCHAR(4)
DECLARE @Smon VARCHAR(2)
SET @Syr = DATEPART(yyyy,@Start)
SET @Smon = DATEPART(mm,@Start)
SET @Smon...
October 20, 2010 at 3:02 pm
Let's hope what happens in Vegas stays in Vegas
October 19, 2010 at 8:04 pm
robert693
Thanks for your reply, and I like you did not spot it first off, now let me ask did you use a blank character or stick with those NULLs?
October 19, 2010 at 3:08 pm
Now this could be a result of your typing in the BCP command, and NOT an error in the actual BCP command you are using, however in looking at what...
October 19, 2010 at 2:52 pm
Where you have NULL as [End Date], can you substitute a blank character as:
'' ' AS [End Date]
For example
SELECT Subject, ' ' AS [End Date], ' ' As [End...
October 19, 2010 at 12:29 pm
Can anyone help this OP?
http://www.sqlservercentral.com/Forums/Topic1004378-149-1.aspx#bm1004658
Thaks
October 15, 2010 at 5:07 pm
You might want to run this select statement and either output to text or to a file. Set SSMS to output text to a new window, you can cut...
October 14, 2010 at 10:04 pm
Are you familiar with the TRY - CATCH construction? If not the following link will be most helpful.
October 14, 2010 at 9:45 pm
natalie_orlovsky
In order to receive a tested reply please post table(s) definitions, some sample data, and any T-SQL statements that you may have attempted to use to solve your problem.
Please click...
October 14, 2010 at 2:14 pm
Is Mr Celko mellowing? Admitting there is something he does NOT know, or has his character drastically changed?
http://www.sqlservercentral.com/Forums/Topic1002440-1292-2.aspx
October 14, 2010 at 12:37 pm
This code takes the data you wish to manipulate and places it into a temporary table
SELECT c.FirstName, c.LastName, e.Title, a.AddressLine1, a.City, sp.Name AS [State/Province], a.PostalCode
INTO #EmployeeAddresses
The results of the first...
October 14, 2010 at 11:49 am
Viewing 15 posts - 1,666 through 1,680 (of 3,221 total)