Viewing 15 posts - 391 through 405 (of 3,544 total)
FOR %%f IN (*.sql) DO ....
Far away is close at hand in the images of elsewhere.
Anon.
February 2, 2017 at 6:58 am
Far away is close at hand in the images of elsewhere.
Anon.
February 1, 2017 at 2:03 am
Far away is close at hand in the images of elsewhere.
Anon.
January 26, 2017 at 4:01 am
With your data
Contains(dbcode, '"3*"') will return all the rows (providing each code you posted is in a separate row)
Contains(dbcode, '"*3*"') will not return any rows as the * prefix...
Far away is close at hand in the images of elsewhere.
Anon.
January 24, 2017 at 9:17 am
I tested your code and it returned your expected results.
Contains(dbcode, '"*3*"') is the valid FTS format, however you cannot use * as a prefix as it is used...
Far away is close at hand in the images of elsewhere.
Anon.
January 24, 2017 at 6:49 am
Far away is close at hand in the images of elsewhere.
Anon.
January 20, 2017 at 7:03 am
DECLARE @value varchar(20) = Far away is close at hand in the images of elsewhere.
Anon.
January 18, 2017 at 6:55 am
Far away is close at hand in the images of elsewhere.
Anon.
January 17, 2017 at 7:48 am
1. The update should be in the trigger there is no need for an additional procedure
2. The UPDATE statement will update every row in the JOURNAL table not just...
Far away is close at hand in the images of elsewhere.
Anon.
January 17, 2017 at 2:06 am
Far away is close at hand in the images of elsewhere.
Anon.
January 12, 2017 at 9:36 am
Grant Fritchey (1/11/2017)
Brandie Tarvin (1/11/2017)
BLOB EATER (1/11/2017)
GilaMonster (1/11/2017)
I really would like to attend Bits this year (hint, hint)you have my vote!
So someone tell me who those "Steve Jones" and "Grant...
Far away is close at hand in the images of elsewhere.
Anon.
January 11, 2017 at 6:31 am
If you output your data as tab delimited to an .xls (not .xlsx) file
Excel will be able open the file if you accept the prompts (depending on version of Excel)
Far away is close at hand in the images of elsewhere.
Anon.
January 11, 2017 at 6:19 am
Notwithstanding Thom's reply.
If you can change the data then include page number, output the invoice data with odd page numbers and a single row of null values with even page...
Far away is close at hand in the images of elsewhere.
Anon.
January 11, 2017 at 6:12 am
WITH x (ID,FirstName,LastName,UserName,UserNum) AS (
SELECT e.ID,e.FirstName,e.LastName,LEFT(e.FirstName,t.N)+e.LastName,
ROW_NUMBER() OVER (ORDER BY LEN(LEFT(e.FirstName,t.N)+e.LastName) ASC,LEFT(e.FirstName,t.N)+e.LastName ASC,ID ASC)
FROM #Employee e
JOIN master.dbo.Tally t ON t.N BETWEEN 1 AND LEN(e.FirstName)
WHERE NOT EXISTS (SELECT * FROM #TEMP_USER u...
Far away is close at hand in the images of elsewhere.
Anon.
November 7, 2016 at 9:03 am
Eirikur Eiriksson (11/7/2016)
This fails as it returns duplicates in the generated user names
Oh well it was close 😛
Far away is close at hand in the images of elsewhere.
Anon.
November 7, 2016 at 8:45 am
Viewing 15 posts - 391 through 405 (of 3,544 total)