Forum Replies Created

Viewing 15 posts - 2,641 through 2,655 (of 13,460 total)

  • RE: Our Wonderful Forums

    Everything you mentioned is exactly why i try to donate some time here and help people.

    I've sometimes put in a lot of time creating a solution on a topic...

    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!

    January 23, 2014 at 5:49 am

    #1682731

  • RE: SCUD?

    netmikem (1/22/2014)

    I've come across this acronym in a few places recently, one being a SQL Server DBA job description. Does anybody know what it stands for, in database related terms?

    I've...

    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!

    January 22, 2014 at 2:41 pm

    #1682588

  • RE: MY package dont work ??!!! Why

    the error seems pretty clear to me:

    "Violation of PRIMARY KEY constraint 'PK_incident_id'. Cannot insert duplicate key in object 'dbo.incident'. The duplicate key value is (129).".

    does your process expect to insert...

    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!

    January 22, 2014 at 8:36 am

    #1682454

  • RE: Table Constraint

    yes it's possible; you can create a CHECK constraint that uses a user defined function, that say returns 1 or 0 if the criteria is valid or not.

    with DDL 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!

    January 22, 2014 at 7:29 am

    #1682398

  • RE: select latest records

    create a new table with the appropriate primary key or unique constraint.

    insert into that new table grouping by the the same appropriate primary key or unique constraint criteria from 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!

    January 21, 2014 at 6:18 am

    #1681855

  • RE: problem with default constraint

    even if you have a default constraint in place, if you have a data access layer that explicitly sends NULL to be the column value, then NULL it shall be.

    defaults...

    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!

    January 21, 2014 at 5:40 am

    #1681836

  • RE: Copy logins with their password

    microsoft supplies a proc named sp_help_revlogin here that scripts out sql users with hashed passwords, for importation onto other servers.

    you'll need to grab the right version off of the MS...

    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!

    January 17, 2014 at 3:09 pm

    #1681280

  • RE: Where we can download SQL Server 2008

    for that i think you'll have to search and read a bit for yourself: it's far to much for a forum post to highlight for you.

    https://www.google.com/search?q=difference+between+sql+2005+and+sql+2008

    https://www.google.com/search?q=difference+between+sql+2005+and+sql+2008R2

    https://www.google.com/search?q=difference+between+sql+2005+and+sql+2012

    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!

    January 17, 2014 at 1:18 pm

    #1681241

  • RE: Convert(Varchar,GetDate(),???) - List of Format Codes

    format 108 givesw the time including seconds, includingpreceeding zeros, so you could do a substring/left of that:

    SELECT LEFT(CONVERT(VARCHAR,getdate(),108),5) --09:10

    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!

    January 17, 2014 at 7:12 am

    #1681060

  • RE: SP changing database contect in SP

    Edward-445599 (1/17/2014)

    Hi,

    I was wondering what is the best way to change context within a DB.

    For example you could have a simple script which restores a DB you might have something...

    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!

    January 17, 2014 at 6:33 am

    #1681042

  • RE: Embedd Image from databse mail

    actually, using the content id (cid:) is the right way.

    by leaving it out, you are just taking advantage of some email clients smart features of filling in missing tags, 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!

    January 17, 2014 at 6:06 am

    #1681036

  • RE: Deprecated]Function call can be extracted from the WHERE clause to avoid unnecessary table scan.

    dateadd is not deprecated.

    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!

    January 16, 2014 at 10:20 am

    #1680756

  • RE: Select 4 Distinct Suppliers for each stock number in Single Query

    glad i could help a little bit!

    let us know how it goes or if oyu need another pair of eyes to look at the issue.

    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!

    January 16, 2014 at 5:35 am

    #1680609

  • RE: find the count of rows all tables based on created date

    since you know the 53 tables, and you know the date, i think this is just a big UNION query:

    SELECT 'Table1',count(*) FROM Table1 WHERE CreateDate > '2014-01-01' UNION ALL

    SELECT 'Table2',count(*)...

    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!

    January 16, 2014 at 5:31 am

    #1680607

  • RE: How to login using a different domain ID in SSMS?

    edit: since you don't have access, you couldn't use execute as, sorry.

    this solution might depend on whether your application maintains a dedicated connection or just connects and disconnects as needed...

    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!

    January 15, 2014 at 2:27 pm

    #1680450

Viewing 15 posts - 2,641 through 2,655 (of 13,460 total)