Forum Replies Created

Viewing 15 posts - 8,881 through 8,895 (of 13,460 total)

  • RE: TALLY TABLE REPLACING LOOPS

    the devil is in the details, so "it depends"

    this:

    /*

    DO SOME SQL LOGIC

    */

    depedning on what that is doing, or going to do, you might not need a loop or tally table...

    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!

    August 24, 2010 at 6:19 am

    #1210951

  • RE: Cursor Causing Problem in Sql Serever 2005

    show us the script you are using...are you tal\king into consderation non-standard database names?

    ie select * from [My Database With Spaces Or a Reserved Word].dbo.sys.objects?

    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!

    August 23, 2010 at 11:27 am

    #1210616

  • RE: how to insert the output of a sotred proc into a table

    you have to define a table with the proper columns before you call the procedure.

    if your proc, which is using dynamic sql, returns a different number of columns depending on...

    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!

    August 23, 2010 at 10:03 am

    #1210558

  • RE: Connections to sql server 2008

    that would limit all connections, whether from your web app or form Management Studio; remember your web server will try too pool connections, so it'll be reusing some of...

    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!

    August 23, 2010 at 9:03 am

    #1210505

  • RE: Help with understanding a WHERE clause

    Denesh Naidoo (8/23/2010)

    Hi All,

    Working on SQL Server 2005.

    Have a query that has a WHERE clause as follows:

    WHERE (Documents.Flags & 0x18)=0

    Can someone please explain the & 0x18 part which I 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!

    August 23, 2010 at 7:48 am

    #1210441

  • RE: Connect To Database Engine does not respond

    monietamarind (8/23/2010)

    I am trying to Connect To Database Engine. I was able to get connected before. But, I am not able to do so now. The SQL...

    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!

    August 23, 2010 at 7:31 am

    #1210435

  • RE: GETDATE() does not return any data

    Parthi i mentioned before that while you can use CAST and CONVERT on the columns, it's best practice to stay within the same datatype by using DATE ADD/DATEDIFF functions;

    when...

    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!

    August 20, 2010 at 12:48 pm

    #1209870

  • RE: connect to a sql server 7 instance

    VNC/Remote Desktop/ TeamViewer / PCAnywhere / GoToMyPC are desktop viewers,

    you don't need that.

    SQL Server Management Studio is the interface of choice and is backwards compatibile, and can connect 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!

    August 20, 2010 at 12:09 pm

    #1209850

  • RE: substring

    ny66 (8/20/2010)

    havent gotten that far yet on the insert into, need to get the syntax together prior to creating the new table.

    it's pretty basic:

    --get just the data we need 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!

    August 20, 2010 at 12:05 pm

    #1209849

  • RE: Best way to select a large amount of data?

    ricardo_chicas (8/20/2010)

    Ok lets do this, forget about the original problem

    what I really want to know is for a suggestion on what is the best way to retrieve large amount of...

    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!

    August 20, 2010 at 11:32 am

    #1209834

  • RE: password creation

    newbieuser (8/20/2010)

    Hi friends,

    I'm creating an application role, the password for the role should be read from a table. Is it possible to do this?

    The table need 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!

    August 20, 2010 at 11:21 am

    #1209828

  • RE: substring

    Lowell (8/17/2010)

    can you post the example data as an actual INSERT INTO query?(don't paste my example back...that already worked correctly)

    chopping stuff up with substrings not hard to do...but we need...

    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!

    August 20, 2010 at 11:04 am

    #1209815

  • RE: Comparing 2 identical database servers.

    ouch; Steve's analysis is right on....it'll be tough to determine what changed and what should be kept, especially if competing applications used two different databases at the same time.

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

    August 20, 2010 at 10:26 am

    #1209793

  • RE: Julian Date Conversion Function Issue

    sharp analysis drew... i would not have inferred the regional settings affecting the implicit conversion.

    here's my version of the procedure, which seems to return the data with seconds:

    CREATE FUNCTION [dbo].[fn_JulianDateConversion](@JulianDate...

    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!

    August 20, 2010 at 10:14 am

    #1209782

  • RE: assigning db roles to a sql 2005 user

    laddu4700 (8/20/2010)

    Thank you very much.

    2 more questions on sql security

    1. Can we create a SQL login with out creating a windows user?

    yes, of course. sql supports two kinds of...

    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!

    August 20, 2010 at 9:42 am

    #1209754

Viewing 15 posts - 8,881 through 8,895 (of 13,460 total)