Search results for query: *

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...

Hello, I have a table (Subs2) with the following data: Textlist S~U~BRANCH CREEK 19-28-3~1019-7~Y~N~~~~~~~~~~~~ S~U~13TH STREET SPORT PARK~13SSP~Y~N~~~~~~~~~~~~ S~U~77-SUNSET MOBILE HOME PARK - DOUGLASS~77SMHP~Y~N~~~~~~~~~~~~ I am trying to parse out the fields (with ~ as the delimiter) to...

Thanks gmmastros. I like that idea... Out of curiosity, is there a reason to use the brackets? Does this: like '%[ ][ ]%' do the same thing as: '% %'? Or was that just for illustration?

Hi. I have data in a table like this: NW 35 6 6 55 PLAT ID 111 T176 BERKS I'd like to remove the long strings of spaces in the middle of this string, but I dont' want to remove the single space between words. I thought about just replacing double...

oh wait.. i think I figured it out by setting the starting number before the while loop. declare @foldernumber int set @foldernumber = 1 while (select count(id) from mytable where folder is null) > 0 begin update mytable set folder = 'FOLDER' + convert(varchar(5), @foldernumber) set...

Hello. Trying something like this. I am trying to set a @variable to 1 so I can update some records to FOLDER1. At the end of my script I would like to set the @variable to + 1 so I can set the next records to FOLDER2, etc. How can I set a starting @variable and then add + 1 to it? When...