Forum Replies Created

Viewing 15 posts - 3,226 through 3,240 (of 13,460 total)

  • RE: Subquery returned more than 1 value. This is not permitted when the subquery follows

    you have two queries that could potentially be comparing more than one row to a single value;

    one is a simple test for a value:

    if (select UNITE_COUT_MATERIEL from DIM_INTER_MATERIEL) =...

    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!

    June 26, 2013 at 5:47 am

    #1627493

  • RE: query

    nicklibee I'm sorry if you took any of the comments here as harsh.

    Sean and I,as well as other regular volunteers here have both contributed to tens or hundreds of thousands...

    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!

    June 26, 2013 at 5:19 am

    #1627475

  • RE: best approach

    you still will need occupied/empty records at the individual seat level; you might organize them in cubes, but your level of detail is deeper;

    i'd also like to see the 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!

    June 25, 2013 at 2:04 pm

    #1627309

  • RE: query

    Sean Lange (6/25/2013)

    I have a feeling this thread is going like the last one from the poster. http://www.sqlservercentral.com/Forums/Topic1465520-391-1.aspx

    Lots of completely vague posts and suddenly, voila! The OP posts a complete...

    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!

    June 25, 2013 at 1:33 pm

    #1627285

  • RE: unexpected Error occured in the database server Time out expired

    that's an application error,and not SQL server.

    a lot of applications will have a default connection timeout of 30 seconds, unless someone explicitly adds some longer timeouts to the connection string.

    if...

    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!

    June 25, 2013 at 1:21 pm

    #1627278

  • RE: query

    ok if you have a master table of regions, you can join it agaisnt your transacitons? table?

    ;With Regions(REGION)

    AS

    (SELECT 'a' UNION ALL

    SELECT 'b' UNION ALL

    SELECT 'c' UNION ALL

    SELECT...

    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!

    June 25, 2013 at 1:16 pm

    #1627275

  • RE: query

    well here's a runnable query base don your copy/paste, but i couldn't figure out where the b 0 0 data came from for the desired results;

    if you can explain 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!

    June 25, 2013 at 1:11 pm

    #1627274

  • RE: Script for mirroring and log shipping

    lmacdonald (6/25/2013)

    Oh nice, that may just work )

    However my linked server is actually on the same machine, but another instance. There is a syntax error, it does not like...

    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!

    June 25, 2013 at 12:39 pm

    #1627258

  • RE: Script for mirroring and log shipping

    lmacdonald (6/25/2013)

    Yes but those DDL commands often specify a from clause which is where I can put in the linked server. These do not.

    ahh, you missed the point.

    I created...

    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!

    June 25, 2013 at 12:25 pm

    #1627256

  • RE: Script for mirroring and log shipping

    For Linked servers, i know you can do DDL commands, like CREATE TABLE, via EXECUTE AT;

    I'd bet any other commands like the ALTER and CREATE ENDPOINT would work just as...

    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!

    June 25, 2013 at 11:37 am

    #1627245

  • RE: SQLXMLBULKLOAD mapping file

    duplicate post.

    There's no need to post the same question in multiple forums.

    The Recent Posts>>Posts Added Today function which most people use shows us your post immediately.

    crossposting will wastes people's 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!

    June 25, 2013 at 11:22 am

    #1627244

  • RE: SQLXMLBULKLOAD mapping file

    duplicate post.

    There's no need to post the same question in multiple forums.

    The Recent Posts>>Posts Added Today function which most people use shows us your post immediately.

    crossposting will wastes people's 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!

    June 25, 2013 at 11:22 am

    #1627243

  • RE: how to restore a stored procedure from a backup

    SQLHeap (6/25/2013)

    The db is too big to restore fully, can't even just restore the primary filegroup anywhere. How can I get a single stored procedure back?

    grab the trial version...

    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!

    June 25, 2013 at 11:13 am

    #1627241

  • RE: How much Ram required.

    i don't think there is a hard and fast rule you can just say, it depends on the data and how often it gets accessed;

    SQL will use all the RAM...

    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!

    June 25, 2013 at 10:47 am

    #1627236

  • RE: How to connect SQL SERVER 2012 EXPRESS ADVANCEd to a PROGRESS database ?

    Lidou123 (6/25/2013)

    Hi Lowell,

    Thank u for your answer.

    I tried to connect via linked server and that wooooorks !!!!!!!!!!!!!!! 🙂

    Thank U.

    So, now I can create a report and deploy it ??

    Or I...

    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!

    June 25, 2013 at 10:31 am

    #1627225

Viewing 15 posts - 3,226 through 3,240 (of 13,460 total)