Forum Replies Created
Viewing 15 posts - 4,846 through 4,860 (of 13,460 total)
-
RE: Importing multiple .txt files into one table - no SSIS
for the delimiter issue, use something you KNOW will not exist in the data; a tilde ~ for example.
then everything will come in as asingle column of wide data.
For...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Importing multiple .txt files into one table - no SSIS
here's an example i've posted lots of times.
this inserts allt eh data into a table named "BULKACT, that has a single column "RAWDATA"
it imports all the files in four different...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Importing multiple .txt files into one table - no SSIS
it's fairly easy; you would want to use BULK INSERT to bring the text files into a SQL table...but you have to know the layout of the data, and create...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Schema for cascading style sheets
well, CSS wise, the closest assignment to the object overrides the css at the higher level;
do you have a set number of levels, or at least some method to identify...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: HTML, T-SQL, E-MAIL and you...
John Waclawski (8/27/2012)
LOWELL!! MY SQL HERO!! Let me give this a shot & see how it works!Thanks. BTW...did you get my reply from our other thread?
for assigning...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: HTML, T-SQL, E-MAIL and you...
John here's your example you posted, modified so every other row is manill folder/white;
if i have specific cells i want colored, i usually use a CSS class.
let me know if...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Help needed in converting an int datatype to MM/DD/YYYY and converting another int to HH:MM PM
ok, this gets you your value as datetime, right? i guess you could manipulate it a bit more if you really wanted AMPM in it, but i would want the...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Help needed in converting an int datatype to MM/DD/YYYY and converting another int to HH:MM PM
if you convert to CHAR(12), most of the string gets truncated no matter the format.
try a CHAR(37) instead.
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Oracle Database
Jo Pattyn (8/27/2012)
... any good programmer is also worth his/her weigth in gold.lol according to this web site,
http://www.onlygold.com/tutorialpages/yourweightingold.asp
a fat boy like me is worth 5.4 million dollars or so;...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Help: Encryption and Decryption in T-SQL and VB.NET
ok I see that works;
With my example values, I also saw that SQL DES and TRIPLE_DES are not interchangable with the results from your function;
I think you'll have to...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Backing Up/Restore to non-local drive
andersg98 makes me think you could do a proof of concept;
create a new job that does a COPY ONLY with verify backup to the network share;
set it to...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Connection keeps Changing When Switching Between Queries
The new Query button will open up with the connection information for whatever Server/Database is currently selected in the Object Explorer.
If Object Explorer is not visible the connection info is...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Help: Encryption and Decryption in T-SQL and VB.NET
well, my simple copy paste of your class, and a button to call it returns an error form vb.net;
All i wanted was a string and it's encrypted value, with a...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Create view with no outer joins
an indexed view cannot have functions applied to any of the columns,right? so the CASE and CONVERT statements in the query you posted will disqualify the view from being indexed,...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Help: Encryption and Decryption in T-SQL and VB.NET
probably. If you can give an example of the unencrypted value / encrypted value as it would be processed from vb.net, we can see if there is a matching algorythm...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!
Viewing 15 posts - 4,846 through 4,860 (of 13,460 total)