Forum Replies Created

Viewing 15 posts - 3,466 through 3,480 (of 13,460 total)

  • RE: Separating distinct invoices under one sales order

    Sean Lange (5/13/2013)

    Lowell (5/13/2013)

    Sean Lange (5/13/2013)

    Lowell - you win this time. 😉

    Only because i have a macro that converts pasted text to a CTE; you built a complete sample DDL...

    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!

    May 13, 2013 at 3:27 pm

    #1614796

  • RE: Same SQL Server Instance name on two different Windows 2008 R2 servers

    raghusg (5/13/2013)

    Hi,

    We have two different Windows 2008 R2 servers (Server1 and Server2) on the same domain. The questions I have are:

    1) Can I have the same...

    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!

    May 13, 2013 at 3:14 pm

    #1614792

  • RE: Separating distinct invoices under one sales order

    Sean Lange (5/13/2013)

    Lowell - you win this time. 😉

    Only because i have a macro that converts pasted text to a CTE; you built a complete sample DDL for it.

    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!

    May 13, 2013 at 3:07 pm

    #1614789

  • RE: Separating distinct invoices under one sales order

    it seems like a basic grouping can get you the data you want;

    run this in SSMS, does this give you teh data youa re looking for?

    with mySampleData ([Sales Order #],[InvoiceID],[InvoiceDate],...

    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!

    May 13, 2013 at 2:44 pm

    #1614782

  • RE: ssms 2012 express?

    you need the version with SQL 2012 with Advanced Services or SQL 2012 Express with Tools:

    Advanced Services includes the SSMS Express version.

    http://msdn.microsoft.com/en-us/evalcenter/hh230763.aspx

    http://www.microsoft.com/en-us/sqlserver/editions/2012-editions/express.aspx

    since you already installed the Express engine, you could...

    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!

    May 13, 2013 at 1:57 pm

    #1614767

  • RE: Difference in SQL

    Both Have SQL = "Structured Query Language" in their names;

    As Far as I know, T-SQL (Transact SQL) is the nickname for Microsoft's version of SQL, as opposed to PL SQL(Oracle's...

    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!

    May 13, 2013 at 12:56 pm

    #1614746

  • RE: how can I get the DTS Wizard?

    That's part of SSIS, so you'd need either SQL Developer, or SQL Standard/Enterprise/Data Center editions. it is not included in the Express editions.

    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!

    May 13, 2013 at 12:26 pm

    #1614737

  • RE: Connecting to SQL Server from a Visual Studio 2012 Express Class

    Tim in this case, i'm not sure;

    I created a Simple Class library, and this is teh entire code, which compiles correctly in the full version of Visual Studio 2010;

    My project...

    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!

    May 13, 2013 at 8:28 am

    #1614617

  • RE: Trace Group Simular Statemments

    SpiderDK (5/13/2013)

    Yes, but this only allows me to group on class / type of statement.

    I would like to group simular statements

    select * from table1 where id = 1 order by...

    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!

    May 13, 2013 at 7:56 am

    #1614599

  • RE: View creation on Linked Server

    also, to create a view on Server 2, FROMserver 1, you need to do one of two things:

    either the SQLcmd needs to actually connect to server 2, and not...

    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!

    May 13, 2013 at 6:32 am

    #1614570

  • RE: View creation on Linked Server

    can't help that much yet;

    you didn't mention any specific error you get back, and it might be nice to see the actual command you are using in sqlcmd 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!

    May 13, 2013 at 5:46 am

    #1614557

  • RE: update MySQL from SQL Server

    martin.kerr 34088 (5/13/2013)

    Hi All,

    I have managed to set up a linked server to a MySQL database and i want to update the MySQL database using a table within SQL Server....

    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!

    May 13, 2013 at 5:43 am

    #1614555

  • RE: code folding in ssms?

    http://www.ssmstoolspack.com/Download

    http://www.ssmstoolspack.com/Licensing

    Licensing is only applicable to SSMS 2012 and higher versions.

    For previous SSMS versions the SSMS Tools Pack is still FREE.

    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!

    May 10, 2013 at 2:14 pm

    #1614314

  • RE: Syntax error in From running SMSS import Excel to SQL

    if your SQL2008 is 64 bit, you must install the 64 bit ACE drivers; the JET driver is only valid for 32 bit, and it won't work on .xlsx files(or...

    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!

    May 10, 2013 at 12:07 pm

    #1614286

  • RE: Specific user account access only

    i think it's the usual; there's no easy way, but you can use the metadata to build your commands to add everyone to a deny everything group

    something like this 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!

    May 10, 2013 at 11:52 am

    #1614284

Viewing 15 posts - 3,466 through 3,480 (of 13,460 total)