Forum Replies Created

Viewing 15 posts - 5,161 through 5,175 (of 13,460 total)

  • RE: i want sql query

    we are looking for something like this, that anyone on the interwebz can copy and paste so we can build sample queries for you to test with:

    CREATE TABLE [dbo].[TAGTABL] (...

    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!

    July 18, 2012 at 6:48 am

    #1514179

  • RE: How to get Create script of an existing table

    if you've gotta do it via TSQL, instead of stepping out via SMO to get it , i've spent a lot of time refining a few stored procedures to do...

    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!

    July 18, 2012 at 6:18 am

    #1514161

  • RE: Query Help

    the function attached to this article is recommended by myself any my peers:

    http://www.sqlservercentral.com/articles/Tally+Table/72993/

    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!

    July 18, 2012 at 5:43 am

    #1514143

  • RE: Query Help

    vijayarani87.s (7/18/2012)

    Hi I need to take the result by passing more ID, below is the sample query, I am getting error converting vachar to INT ERROR. Because data type for...

    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!

    July 18, 2012 at 5:31 am

    #1514137

  • RE: forcing parallelism when excecuted via asp.net

    nope no way to force it.

    you can use MAXDOP to limit the parallelism, but there's no MINDOP feature.

    if the execution plans were the same, it should use the same paralell...

    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!

    July 17, 2012 at 11:49 am

    #1513772

  • RE: There is a way to send an email file that is stored in a column 'binary' through 'msdb.dbo.sp_send_dbmail'?

    i haven't done it since i discovered CLR, but it's possible with bcp; google bcp binary blob for examples, but here's one:

    bcp "select document_binary_data from databaseName.dbo.tableName where id...

    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!

    July 17, 2012 at 11:25 am

    #1513750

  • RE: Why does the syntax work for insert and not insert into?

    ok i know that you can create a table on a linked server using EXECUTE AT, but i think you have to create the table first, and then insert into...

    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!

    July 17, 2012 at 11:19 am

    #1513740

  • RE: There is a way to send an email file that is stored in a column 'binary' through 'msdb.dbo.sp_send_dbmail'?

    well here's one way using CLR:

    if you were to install Elliot Whitlow's project at http://nclsqlclrfile.codeplex.com/

    you could save the binary to disk on the server, and then send the attachment.

    --MSPSaveFileImage

    -- ...

    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!

    July 17, 2012 at 9:42 am

    #1513675

  • RE: Server drop connection error

    santhosh411 (7/17/2012)

    Any more suggestions on this

    what did you try?

    what did not work?

    did you upgrade the driver like Gail suggested?

    did you try the suggestions i posted,and what were 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!

    July 17, 2012 at 7:37 am

    #1513593

  • RE: Server drop connection error

    is the database set to single user?

    select * from sys.databases WHERE user_access_desc = 'SINGLE_USER'

    if it is, and should not be, you need this command:

    ALTER DATABASE [YourDatabaseName] SET MULTI_USER

    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!

    July 17, 2012 at 6:55 am

    #1513567

  • RE: Permissions required for using view that points at different database on same server

    for a cross database query, the login needs to be either a user in both databases, or in a group that exists in both databases.

    so for a specific example, you...

    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!

    July 17, 2012 at 6:50 am

    #1513564

  • RE: Identify Orphan Data "Data Integrity"

    tapaskumardm (7/17/2012)

    Can you put some more light on above explanation....

    I will be happy to get some conclusion on this.

    Thanks.

    not sure what you need, sorry.

    run the first query. does it return...

    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!

    July 17, 2012 at 6:41 am

    #1513556

  • RE: Finding the version of sql server 2005 from backup files

    yes it's possible. SQl lets you restore previous versions of SLQ server, up to three versions behind, i think?( so SQL 2008 can restore SQL 7 or SQL 2000 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!

    July 17, 2012 at 6:32 am

    #1513550

  • RE: Is it possible to loop through all excel files in a folder using T-sql

    like brain donor's example, my two examples would involve a cursor to process the files after i got the list of files.

    my example for xp_cmdshell is really similar:

    --a 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!

    July 17, 2012 at 6:11 am

    #1513536

  • RE: Maximum Memory Windows Server 2003 32 bit?

    for the operating system, i *think* it's 192 gig, based on this page:

    http://msdn.microsoft.com/en-us/library/windows/desktop/aa366778(v=vs.85).aspx#memory_limits

    for SQL 2005, a lot of it depends on the AWE and PAE settings, since it's probably a...

    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!

    July 17, 2012 at 5:54 am

    #1513528

Viewing 15 posts - 5,161 through 5,175 (of 13,460 total)