Recent content by bmacbmac

Hi Everyone, I have the following test.json file: { "imageRoot": "https://path/", "name": "Test", "documents": [ { "imageUrl": "D0205936.tif", "json": { "indexingRecordId": "281972", "bookType": "OPR", "bookNumber": "14"...

Hello... I have about 25,000 Word Docs where I would like to import just the text data from each file. Reading other forums, I have tried: create table Documents (DocName nvarchar(40), DocContent Varbinary(max)) INSERT INTO Documents SELECT...

Ah yes.. sqlcmd was the way to go!

Hello! I have over 100,000 records in SQL that I need exported to json. My query is: SELECT documentinfo.irecordid, (select tempparties.* from tempparties WHERE tempparties.irecordid = documentinfo.irecordid and tipartytype = 1 FOR JSON AUTO) AS first, (SELECT tempparties.* from tempparties...

OMG you are a life saver! That worked perfectly!

Hi there, I have the following data in an xml file: <?xml version="1.0" encoding="utf-16"?> <documents> <document ArchivedFileName="40243702\6665414.tif" DocumentId="6665414" FileSize="304790" OriginalFileName="ptmcdfd.tif" DocumentTypeName="8" FileNumber="40243702"...

Hi. I have a table full of names. I am trying to find all names that contain a non alphanumeric character, but I want to exclude spaces, dashes - , and ampersand &. I am trying this: select * from mytable where name like '%[^a-zA-Z0-9 -&/]%' However, I am getting names returned like...

Andrzejek - Yes each mdb file has just one table, 5 columns. All have the same structure.

Man I have no idea how to do this. I think I may need to hire this out!

Hi! I have 800 little MDB files that I need to import into SQLServer 2008 R2. I'm really hoping I don't have to do the data import wizard 800 times, but I can't find much of a T-SQL solution. I'm hoping there is some sort of insert script I can run for each MDB file. Any ideas? Thanks!

Brilliant! that worked like a charm

Hello... I have the following data: create table #temp (instrumentID varchar(25), saddition varchar(50), block varchar(10), Lot varchar(10), LotLength int) insert into #temp values ('aa11', 'SP1', '5', '9', 1) insert into #temp values ('aa11', 'SP1', '5', '10', 2) insert into #temp values...

Hello, I have the following table / values: create table #temp (counter int, imageid int, newpage int) insert into #temp values (1,400, 1) insert into #temp values (2,400, NULL) insert into #temp values (3,400, NULL) insert into #temp values (4,400, NULL) insert into #temp values (5,400...

Hi Everyone, I have the following table: create table August2018 (counter int identity(1,1), County varchar(25), Locates int, Billed varchar(1), ToBill varchar(1)) Insert into August2018 (county, tobill) values ('Bellingham', 'x') Insert into August2018 (county, tobill) values ('Adams'...

I work with about 75-100 databases. I find myself typing the exact same select statement(s) several times per day in various databases. They are pretty short: select * from table1 t1 join table2 t2 on t1.recordid = t2.recordid join table3 t3 on t2.nameid = t3.nameid Is there some sort of...