Forum Replies Created

Viewing 15 posts - 11,086 through 11,100 (of 13,460 total)

  • RE: Populate a Status column

    it's the * for the column list.

    there's no problem running that statement all by itself, but if ytry to create a VIEW of it, you'll have problems because the emp_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!

    May 17, 2009 at 12:18 pm

    #996054

  • RE: Populate a Status column

    here's some consumable data to help look at the problem.

    i think in your example you said one column was c_date, but int he SQL you referenced clocking_date; i added both...

    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!

    May 17, 2009 at 6:08 am

    #995979

  • RE: Invalid object name 'My Table Name'

    then it is probably owned by a different schema than dbo, and needs to be identified by that.

    what is the real, exact error message?

    maybe if you have a user named...

    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!

    May 15, 2009 at 10:30 pm

    #995815

  • RE: Invalid object name 'My Table Name'

    if it literally says 'table name' , with a space, you'll need to wrap any name with spaces in double quotes or brackets:

    SELECT * from [My Table Name] WHERE [First...

    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!

    May 15, 2009 at 9:51 pm

    #995809

  • RE: Deleting own post ?

    i tried creating a brand new post, and immediately deleting it.

    http://www.sqlservercentral.com/Forums/Topic718433-433-1.aspx

    i was unable to delete 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!

    May 15, 2009 at 9:34 pm

    #995806

  • RE: Deleting own post ?

    i think if you create a brand new post, you can delete it , but if it's a reply to a post, instant-notification emails might have foreign keys to 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!

    May 15, 2009 at 1:03 pm

    #995604

  • RE: Map hyperlink to c:\ drive or shared drive in ssrs

    more details from you before anyone can help; it's all specific to YOUR network.

    what is the address of yout SSRS server? are you connecting to a .com address or 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!

    May 15, 2009 at 10:06 am

    #995482

  • RE: Without installing MSSQLSERVER can view MSSQL database

    you can also establish a regualr ADODB connection and connect to the server, without having any SQL client tools installed. there are a lot sample apss that can do that...

    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!

    May 15, 2009 at 7:25 am

    #995308

  • RE: Database mail not sending Reply email to multiple recepients

    you'll need to handle errors a s a separate email, something like this:

    DECLARE @Results int

    EXEC @Results = msdb.dbo.sp_send_dbmail

    @profile_name = 'AdventureWorks Administrator',

    @recipients = 'danw@Adventure-Works.com',

    @body='Whatever 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!

    May 15, 2009 at 5:53 am

    #995210

  • RE: Case in where clause

    this was about the only thing that made sense to me;

    SELECT

    ID,

    [month],

    [year],

    CASE

    WHEN month(getdate()) IN...

    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!

    May 14, 2009 at 8:36 pm

    #995020

  • RE: SQL Server 2008 Developer Edition easy question

    this is actually a question for Network Solutions...if they expose their SQL Server to allow you to connect directly, then yes.

    If it is hidden behind a firewall, then no.

    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!

    May 14, 2009 at 7:44 pm

    #995004

  • RE: Finding specific types of change in a ChangeLog -- cursorless?

    the secret is to join the table against a copy of itself.

    this example is most of the way there...the only problem is that it returns more than one row.

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

    May 14, 2009 at 5:26 pm

    #994975

  • RE: Select distinct and order by without order by column

    mcginn (5/14/2009)

    I have a table where each row has a unique timestamp column. In many cases other then the timestamp column, all of the other values are dups of another...

    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!

    May 14, 2009 at 1:13 pm

    #994822

  • RE: Map hyperlink to c:\ drive or shared drive in ssrs

    it's still just a hyperlink...your computer resolves the path for you.

    Some Excelfile on a web server with DNS

    Some Excelfile on personal web server by name

    Some Excelfile...

    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!

    May 14, 2009 at 10:13 am

    #994677

  • RE: Add a column (in a specific place) in a table

    it's best to use the GUI in designer. you cannot actually insert between column...behind the scenes you have to create a new table with the newly designed "correct" structure 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!

    May 14, 2009 at 7:45 am

    #994520

Viewing 15 posts - 11,086 through 11,100 (of 13,460 total)