Forum Replies Created

Viewing 15 posts - 8,356 through 8,370 (of 13,460 total)

  • RE: Automatic date command instead of manual change

    sure, if you can assume that *today* decides that you want the first of the current month; so if you run the report, witht hat condition, the date range changes...

    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!

    November 30, 2010 at 5:42 am

    #1256718

  • RE: Registering 300+ SQL Servers to management studio from a list

    learned something new today; thanks graham; didn't even know about the Registered Servers panel until this post. lots of options like automatic discovery of all servers on the network and...

    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!

    November 30, 2010 at 5:31 am

    #1256712

  • RE: badly need help

    InfiniteError (11/29/2010)

    thanks for the responce,

    honeslty, the exact thing that i want to do is to modify the date modifed column for a

    stored procedure, and regarding the encryption, all 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!

    November 29, 2010 at 6:54 pm

    #1256563

  • RE: badly need help

    InfiniteError (11/29/2010)

    thanks for the reply

    Im sorry i use the sql 2005 keyword, the changes that i want to made is in sql server 2000, i google it and many said...

    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!

    November 29, 2010 at 6:32 pm

    #1256560

  • RE: Need to check who is connected:

    dsohal (11/29/2010)

    Hello, actually I do not want him to connect using cnsuser, but on the otherside I do not want that if I add the trigger as above, I 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!

    November 29, 2010 at 5:52 pm

    #1256554

  • RE: get the name of the bit column set to 1

    ==edit== too slow again....

    it'll have to be a case statement i think:

    SELECT

    CASE

    WHEN col01 = 1 THEN 'col1'

    WHEN col02 = 1...

    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!

    November 29, 2010 at 1:58 pm

    #1256486

  • RE: Need to check who is connected:

    well then there is two parts to your issue:

    I want to see if the developer is using to connect

    you can do that with a login trigger...you can write 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!

    November 29, 2010 at 1:09 pm

    #1256461

  • RE: Star Wars

    When Starship Troopers first came out, I wanted to see it, since i had read the book a long time ago...

    took my kids to see it when they were 8...

    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!

    November 29, 2010 at 11:49 am

    #1256413

  • RE: Need to check who is connected:

    here is a simple model that might help: take a look a this thread on a similar subject, where limits were needed to prevent connections from anywhere but the "right"...

    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!

    November 29, 2010 at 11:34 am

    #1256400

  • RE: using BULK INSERT how to insert data into table having 5 columns and text file having 3 columns with unmatched columns(table and text file)

    it seems to me that unless you want the name and phone number fields to be null, you have to join to another table (by ID?) to get those other...

    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!

    November 29, 2010 at 6:15 am

    #1256208

  • RE: Hai iam unable to connect to SQL SERVER MANAGEMENT STUDIO

    himabindu020 (11/29/2010)

    [font="Times New Roman"][/font]

    The original poster says he has installed SQL server, but cannot connect via SQL Server Management Studio. He also wants to learn BI, but is just getting...

    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!

    November 29, 2010 at 6:05 am

    #1256200

  • RE: Hi all

    Please don't crosspost. It just wastes people's time and fragments replies.

    (cross posting is asking the same question multiple times in different forums)

    By checking Recent Posts>>Posts Added Today

    other forum...

    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!

    November 29, 2010 at 6:01 am

    #1256196

  • RE: Enumerate the registers

    Not enough information, my friend; remember we can't see the query that you are refering in your question...you'll need to show us the query you started with, so we can...

    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!

    November 29, 2010 at 5:56 am

    #1256193

  • RE: Searching stored procedure for table name but ignoring comments

    I have this snippets saved which might help; it's using a pair of loops table to strip out any comments , so you can then search just the remaining proc...

    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!

    November 28, 2010 at 12:05 pm

    #1256059

  • RE: using bulk insert with the into command

    it depends on the source.

    any SQL statement that features a FROM Clause can optionally have an INTO NEWTABLENAME in it.

    so the trick is to wrap BULK INSERT so it has...

    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!

    November 25, 2010 at 6:20 am

    #1255551

Viewing 15 posts - 8,356 through 8,370 (of 13,460 total)