Forum Replies Created
Viewing 15 posts - 391 through 405 (of 844 total)
-
RE: Need simpler way to see a list of my posts and possible replies to them
Under the 'Topics' there is a column in the view for 'Last Post'. It would be nice if that column was on the 'Replies' view. This would...-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret. -
RE: Fairly straightforward IF question
andycadley - Wednesday, June 6, 2018 2:48 AMRE: Fairly straightforward IF question
Makes more sense now. So you want columns returned for the 'Fed' values and columns returned for the 'state' if they exist.
You could set up multiple joins to...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.RE: Fairly straightforward IF question
Still not clear to me what you are after.
If this is a one to many:
INNER JOIN VisualCACTUS.ProviderLicenses AS l
ON p.Provider_K = l.Provider_K-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.RE: Fairly straightforward IF question
Not real sure what you are asking for. Are ou wanting to set a field in your select statement for licensetype? You could use a CASE statement for that. Or...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.RE: Previous one year and previous two years in sql
Based on the assumption that the report_begin_date will always be the first date of the year, this logic will get the correct dates. If you calc the 1 year back...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.RE: Link account to multiple email adresses
Steve Jones - SSC Editor - Monday, July 3, 2017 1:14 PM-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.RE: Help with Query
If you do an inner join to the BUD table you shouldn't need the EXISTS.
SELECT GLT.GLL_Account AS Account,
GLT.Amount AS Current_Expenses,
GLT.COP_Period AS Period,
GLT.GLT_TransDate AS Trans_Date,-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.RE: How do you keep yourself from burning out?
"I'd rather take lower pay and work 40 hours/week versus a higher pay and not have a life."
I had this conversation in an interview. A couple years ago I...-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.RE: Find all stored procedures that use a particular db.
Here is some SQL I stole that will search across all databases on the server.
DECLARE @sql VARCHAR(8000);
DECLARE @SearchText NVARCHAR(255);-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.RE: Performance issue with the table having 40M rows
archana.mandiriappan - Wednesday, May 9, 2018 6:08 AM-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.RE: Performance issue with the table having 40M rows
You will need to give more details for the best answer. Look at what Indexes are on each table and provide that info. Table definitions, and some sample data would...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.RE: Can I do this in SQL? maybe SSIS or Stored Procedure?
I would use SSIS to bring in the CSV file into a SQL table, as mentioned earlier. Then use SQL to compare the data.
You could look at the...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.RE: The SQL Joke Thread
Jeff Moden - Wednesday, May 2, 2018 10:25 AM-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.RE: The SQL Joke Thread
TitusCrews - Thursday, May 3, 2018 9:27 AM-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.Viewing 15 posts - 391 through 405 (of 844 total)
