Forum Replies Created

Viewing 15 posts - 7,261 through 7,275 (of 13,460 total)

  • RE: Data type for Encrypted value

    it depends on the encryption algorythm;

    many encrypt to varbinary, but some others can encrypt to varchar/nvarchar for the encrypted values (AES =varchar, for example),

    SQL's built 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!

    June 29, 2011 at 7:10 am

    #1345901

  • RE: How to do ?

    what does not working mean?

    you are showing something from excel that you pasted...that doesn't have anything to do with SQL errors or not working as expected or anything., though...

    help us...

    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!

    June 29, 2011 at 6:57 am

    #1345888

  • RE: How to do ?

    TOP 1 isn't useful without an ORDER BY.

    if you run this:

    SELECT * FROM table

    where psp_item_no = 'DRR07DFAB0034'

    AND psp_ps_no = 16

    how many rows show up? if there is more...

    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!

    June 29, 2011 at 6:47 am

    #1345874

  • RE: Replace sigle and double quotes

    nested replaces is the way to do it...same as you started:

    replace(replace (xxx,"'","^") ,"""","^")

    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!

    June 29, 2011 at 6:15 am

    #1345847

  • RE: How to fix the Error 18456(Login problem)

    if you have physical access to the server(laptop?), the first thing to do is right click SSMS...run as...administrator and see if that gets you in.

    after that, you might 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!

    June 29, 2011 at 5:48 am

    #1345826

  • RE: only run trigger if...

    a trigger runs with every update of course, but the action that it does inside might be limited based on some logic.

    also you've got to consider multiple rows in 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!

    June 29, 2011 at 5:15 am

    #1345806

  • RE: create table through cursor

    try like this:

    insert into ##tmp (ColumnListMatchingsp_dependsOutput)

    EXEC (@sql)

    if you identify the specific columns, you can have more columns in the table than the proc would 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!

    June 28, 2011 at 2:53 pm

    #1345520

  • RE: Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server

    SQL 2005? is this 64 bit or 32 bit?

    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!

    June 28, 2011 at 2:48 pm

    #1345513

  • RE: How is data arranged when a clustered index is created?

    there is no default order by.

    without an ORDER BY , ther eis no guarantee the data is returned in any order.

    sometimes, by coincidence, the data is returned in 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!

    June 28, 2011 at 2:44 pm

    #1345509

  • RE: Automate data retrieval

    it kind of sounds like some dynamic sql and using sp_sendmail would do the trick, just as Welsh Corgi suggested; i'd like to see a little more detail, like 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!

    June 28, 2011 at 12:38 pm

    #1345421

  • RE: Opinion on Rebuilding Views or Views' Indexes

    here's my quick take.

    1. Rebuild Indexes - good.

    2. Update Statistics - only for those columns NOT participating in an index, since the Rebuild of the Index takes care of 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!

    June 28, 2011 at 9:35 am

    #1345276

  • RE: Find date difference

    i cannot think of another way to do it easily; row_number makes the join simpler, but you could join two copies of the tables together based on the name ...

    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!

    June 28, 2011 at 9:00 am

    #1345249

  • RE: Making multiple copies using a Schema

    no way to do types, views , procs or functions automatically...you have to edit them and make their definitions find-and-replace ready for editing.

    the originals typically may reference items in 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!

    June 28, 2011 at 8:55 am

    #1345247

  • RE: Create provider

    the list is a list of all ODBC drivers installed and registered on the server .

    the ace driver gets installed when you install this:

    http://www.microsoft.com/downloads/details.aspx?FamilyID=c06b8369-60dd-4b64-a44b-84b371ede16d

    it might also be installed if 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!

    June 28, 2011 at 8:12 am

    #1345205

  • RE: using function in query

    looks like you are missing another function: dbo.weeknumber

    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!

    June 28, 2011 at 7:53 am

    #1345193

Viewing 15 posts - 7,261 through 7,275 (of 13,460 total)