Forum Replies Created
Viewing 15 posts - 1,906 through 1,920 (of 13,460 total)
-
RE: Modified_date is not changing in sys.tables!!!!!!
you'd have to add something to the table ; either a new column of type datetime, plus a trigger to always populate it on update, or a column of type...
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: Bulk Insert (How do I find my rowterminator?)
ok , the issue is this is one of those file swhere there's layers of data;
three from your screenshot:
OHD record
HDR record
DTL record(s) that are related to the HDR row above...
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: Additional join causing duplicates
yes, it's certainly possible.
i was thinking import down bloew but you mena tto export.
you want to select distinct provider, base don NPI number, as oneexport, adn a seperate export 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: Bulk Insert (How do I find my rowterminator?)
try both slash r and slash n.
open the file in notepad++, which can give you the exact ascii character it is terminating in.
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: File System Task Problems
BWFC (3/10/2015)
Can anybody recommend a decent article about Dynamic File System tasks in SSIS. I've followed the instructions to the letter on all those I've found and every time...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: Add 15 minutes to a time in char format
this is a great example of using the wrong datatype. you have to jump through extra hoops to get data done right.
you'll have to convert to time or datetime, add...
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: Bulk Insert (How do I find my rowterminator?)
most files end in slash r if they came from unix/other systems, or slash n if they came from windows.
try changing your bulk insert to use those:
\n = vbCrLf =...
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: I need Syntax help to use BCP to load a bunch if INSERT STMTS in a file....
bcp cannot help. bcp bulk loads data...it cannot execute each row as if it were a command.
open the file in SSMS and execute it instead. you might need to insert...
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: DB Access is not working
each database is seperate, so you need to explicitly add thelogin as a user to the other database
IF NOT EXISTS(SELECT * FROM sys.server_principals where type_desc='WINDOWS_LOGIN' AND name = 'omh\srinathp' )...
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: DB Access is not working
what does "still not working" mean?
is the end user using SSMS? queries? is there a specific error message?
rereading your original post, you said it's happening in one database only, 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: DB Access is not working
to view the table structure, you want to GRANT VIEW DEFINITION TO SomeUser instead of db_owner
that effectively allows them to see sys.tables/sys.columns, etc...all the metadata.
it lets them see procedure and...
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: Additional join causing duplicates
a practitioner could have more than one location; you know, he works at Baptist East, Baptist North and Baptist South, so that would be normal to see the same provider...
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: query to find SQL Servers from active directory
i just used this powershell script, that i found after investigating your request
http://blogs.metcorpconsulting.com/tech/?p=343
i had to find and replace wierd left and right double quotes with normal double quotes to make...
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: trace flag 610
adding some background, because i didn't know what 610 did, let along as it pertains to availability groups
http://sqlblogcasts.com/blogs/simons/archive/2010/11/17/trace-flag-610-when-should-you-use-it.aspx
Trace Flag 610 – When should you use it?Thanks to Marcel van der...
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: Find 95th percentile
to find the percentile, you need the age, gender and BMI. then you could use a lookup table.
Body mass index-for-age percentiles: Boys, 2 to 20 years
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 - 1,906 through 1,920 (of 13,460 total)