Forum Replies Created

Viewing 15 posts - 7,981 through 7,995 (of 13,460 total)

  • RE: Execute the Query based on dynamic values

    but he mentioned he's pulling from oracle...so joining a linked server table to your local table will threaten performance, because the command will copy the entire oracle table to tempdb,...

    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!

    March 7, 2011 at 1:27 pm

    #1295565

  • RE: Creating TempTable for output of Stored Procedure using Select * into #TmpTable

    not like you are asking, no ...you cannot dynamically create a table by calling your procedure.... have to create a table with the appropriate columns and datatypes first.

    a work around...

    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!

    March 7, 2011 at 1:03 pm

    #1295554

  • RE: Insert statement not working - require scalar expression

    the issue is to NOT use the INSERT...VALUES syntax, but INSERT...SELECTinstead:

    insert into sbsincome (incomekey,flightkey)

    select

    MAX(incomekey)+ 1 AS incomekey,

    116040 AS flightkey

    from sbsincome

    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!

    March 7, 2011 at 7:44 am

    #1295340

  • RE: data arranged in alphabetical order then paged in groups of 10

    mick i'm afraid i'll end up sending you to do some reading; i don't have a handy SQL 2000 solution to paste here for you;

    as i remember it, if your...

    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!

    March 7, 2011 at 7:18 am

    #1295323

  • RE: data arranged in alphabetical order then paged in groups of 10

    you posted in SQL2000; are you limited to using sql 2000 for this solution?

    sql 2005 introduced the row_number() function, which makes it really easy to do; your page would just...

    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!

    March 7, 2011 at 6:40 am

    #1295302

  • RE: Is there any way to create a temp table on the remote server via OpenQuery?

    not with openquery, but the linked server has an EXECUTE AT command that allows you to do some things;

    i've created real tables, bu tnot temp tables(except inside a full set...

    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!

    March 6, 2011 at 7:58 pm

    #1295166

  • RE: ASP/ Express 5/ Win 2003 connection problem

    I believe that by default an installed instance does not listen to the default port of 1433.

    take a look at your configuration and see which ports it is currently listening...

    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!

    March 6, 2011 at 9:46 am

    #1295113

  • RE: How to show the updates that were made

    CREATE TABLE #temp (

    NEWVALUE varchar(100),OLDVALUE varchar(100) )

    Update MYTABLE

    SET COLUMNA = COLUMNB

    OUTPUT

    INSERTED.COLUMNA,

    DELETED.COLUMNA

    INTO #temp(NEWVALUE,OLDVALUE)

    where COLUMNA <> COLUMNB

    SELECT * FROM #temp

    drop...

    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!

    March 4, 2011 at 2:47 pm

    #1294900

  • RE: Create a foreign key constraint

    a foreign key can only be created on a a unique or primary key.

    that unique constraint or primary key constraint can span multiple columns.

    so if you changed your table 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!

    March 4, 2011 at 1:54 pm

    #1294879

  • RE: sql code works fine - front end application is slow?

    the other option isusing locally declared variables. then the compiler cannot use parameter sniffing;

    something like

    CREATE PROCEDURE AVOIDSNIFFING(@Param1 int=0,@Param2 datetime = NULL)

    AS

    DECLARE @localParam1 int,

    ...

    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!

    March 4, 2011 at 1:16 pm

    #1294869

  • RE: Efficient way to copy images from one db to another db on same server

    i might consider doing it this way...

    migrate all the data except the blob/images themselves, and then migrate the images 1000 at a time so i can see progress and have...

    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!

    March 4, 2011 at 1:11 pm

    #1294864

  • RE: Screwed Up, left where of update, messed up a few thousand records, recourse?

    you should be able to attach the mdl/ldf files as a new database name. I'm a little afraid that if the database was in use by SQL server, that the...

    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!

    March 4, 2011 at 12:21 pm

    #1294840

  • RE: Screwed Up, left where of update, messed up a few thousand records, recourse?

    nope; you'll have to grab a backup, restore it as a different db, and compare the two tables, migrating the good data to replace the unwanted changes;

    SSMS uses implicit transactions,...

    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!

    March 4, 2011 at 11:59 am

    #1294831

  • RE: sql code works fine - front end application is slow?

    definitely my first instinct, the parameter sniffing issue, is what i would check first. what you are describing is a classic symptom.

    does your stored procedure have default values for any...

    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!

    March 4, 2011 at 11:24 am

    #1294819

  • RE: I see a session in SQL Activity Monitor But no Task State

    it really depends on the application that is connecting;

    For example, I have a dozen tabs open in SSMS to various databases;each tab shows up as a sessionID; they all...

    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!

    March 4, 2011 at 9:54 am

    #1294769

Viewing 15 posts - 7,981 through 7,995 (of 13,460 total)