Viewing 15 posts - 151 through 165 (of 1,228 total)
Velveeta22 (2/13/2015)
I took the SELECT query that creates...
February 13, 2015 at 2:48 pm
Velveeta22 (2/13/2015)
I took the SELECT query that creates...
February 13, 2015 at 2:46 pm
You're absolutely right Steve, it's an OUTER APPLY coded using CROSS APPLY! I'd love to see some ddl and dml for the tables referenced within it. If the rest of...
February 12, 2015 at 11:37 am
sgmunson (2/12/2015)
Just curious, but I've never seen anyone use an ON clause together with CROSS APPLY. Given that it's an ON 1=1, it would seem to be completely...
February 12, 2015 at 10:55 am
carrieathomer (2/11/2015)
for every document i am going to set a primary key that will be an alphanumeric value (may be 4 digits)
n...
February 11, 2015 at 2:31 pm
carrieathomer (2/11/2015)
i need to create random alphanumeric characters as primary key values when inserting a record.
eg: cmSbXsFE3l8
it can start from 4 digit characters and can grow to 6, 7 as...
February 11, 2015 at 1:10 pm
Nevyn (2/5/2015)
Doesn't the WHERE clause within your apply guarantee that the both of those values are the same, meaning that the conditions are always both...
February 5, 2015 at 2:07 pm
Tom John-342103 (2/5/2015)
The problem was solved by running some index rebuilds. So frustrating when people aren't careful about performing routine maintenance.
Index rebuilds = plan recompiles. There are a few...
February 5, 2015 at 12:03 pm
robert.wiglesworth (2/5/2015)
Say you have a table that has records...
February 5, 2015 at 10:48 am
Jeff Moden (2/2/2015)
February 2, 2015 at 12:57 pm
shadabkhan87 (2/1/2015)
I have a task to be accomplished at work and would like to ask you a question about it.
To give you a little background, there is a...
February 1, 2015 at 11:26 pm
prasadau2006 (1/28/2015)
I need help with the following query, this query is taking more than 20mins to complete. I'm using a left join to
pull the data.
Query:
Insert into dbo.SecondTable
Select b.*...
January 29, 2015 at 2:38 pm
Lookup OR in Books Online, the help system for SQL Server. Also, look at the difference between IF, which conditionally runs statements, and CASE, which operates within a statement.
January 29, 2015 at 2:29 pm
toraghubiz (1/28/2015)
...Could you optimize the query so that we calculate only the departments with more than 1000 employees?
That's illogical, captain.
What you could do is precalculate, using insert/delete triggers on the...
January 28, 2015 at 12:12 pm
Saujib (1/26/2015)
Project workflow recorddsany changes to these tables as a history.
I want to find out all the process that are in status =...
January 26, 2015 at 1:47 pm
Viewing 15 posts - 151 through 165 (of 1,228 total)