Viewing 15 posts - 1 through 15 (of 2,893 total)
Have everything organized in separate tables... As for queries, If you have the right structure and indexes, it shouldn't be a...
November 5, 2015 at 3:14 am
November 4, 2015 at 9:16 am
You cannot use sub-query in OUTPUT, but you can do it with intermediate "always empty" table.
Here is self-explanatory example:
create table src (col int)
insert src select 1
insert src select 2
November 4, 2015 at 8:12 am
As some others suggest: your question and setup is not clear at all.
Could you please provide DDL for your tables and some test data with example of required output. It...
November 4, 2015 at 7:54 am
You need to bring your JOINs to the sub-query FOR XML PATH.
If you provide DDL for your objects and some test data setup I could give you exact and details...
November 4, 2015 at 7:50 am
And would like to get my results in 1 row with the Customer then 2 columns for Products, 6 columns for Name/Value/Charges/NewCharges.
Could anyone help or am I being...
October 28, 2015 at 10:48 am
And glitch in the functionality beyond SQL Server control may...
October 28, 2015 at 10:12 am
What do you by "snapshot results from a query"?
Do you want to save results?
You can extract it out by BCP or SSIS or you can save it in another dedicated...
October 28, 2015 at 7:48 am
What OP is asking is next to impossible to achieve.
Using Jeff Moden splitter may not be the best in this case, as having few more "x" in the strings...
July 21, 2015 at 8:44 am
Why would you wrap single insert statement in transaction?
There is no reason to use nolock hint, untill you want some records to be missed or duplicated.
July 21, 2015 at 6:10 am
Yes, you can:
June 10, 2015 at 10:41 am
What I need is a count of each of the 3 or 4 character OpCodes - they are usually found between position 40 and 73 on a given line. (I...
June 10, 2015 at 9:53 am
I hope that following link should help you to understand what is "remote connection"
As for SSMS, go to Tools/Options select "Query Execution" in the left panel.
You will see that...
June 10, 2015 at 8:43 am
Have you heard about data normalization?
I would suggest to do exactly that.
Store data in the database table as supposed to; report/display it as you wish (comma separated list or...
June 10, 2015 at 8:38 am
...what I want to do is add course date from a courses table linked to the appointment
... each gp practice is returned multiple times as a row is returned...
April 20, 2015 at 4:46 am