Forum Replies Created

Viewing 15 posts - 11,311 through 11,325 (of 13,460 total)

  • RE: Applying roles to ssrs using active directory - DELAY

    duplicate post.(actually triplicate!)

    no need to cross post to multiple forums it fractures the answers you get and makes posters duplicate others work.

    the "Recent Posts" link shows us everything.

    continue the thread...

    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!

    April 3, 2009 at 6:16 am

    #971450

  • RE: Applying roles to ssrs using active directory - DELAY

    duplicate post.(actually triplicate!)

    no need to cross post to multiple forums it fractures the answers you get and makes posters duplicate others work.

    the "Recent Posts" link shows us everything.

    continue the thread...

    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!

    April 3, 2009 at 6:15 am

    #971449

  • RE: Conversion of PDF to Chinese and Japanese

    duplicate post.(actually quaduplicate!)

    no need to cross post to multiple forums it fractures the answers you get and makes posters duplicate others work.

    the "Recent Posts" link shows us everything.

    continue the thread...

    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!

    April 3, 2009 at 6:14 am

    #971447

  • RE: Conversion of PDF reports of english to chinese and japanese

    duplicate post.(actually quaduplicate!)

    no need to cross post to multiple forums it fractures the answers you get and makes posters duplicate others work.

    the "Recent Posts" link shows us everything.

    continue the thread...

    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!

    April 3, 2009 at 6:14 am

    #971446

  • RE: COnversion of PDF reports of english to chinese and japanese

    duplicate post.(actually quaduplicate!)

    no need to cross post to multiple forums it fractures the answers you get and makes posters duplicate others work.

    the "Recent Posts" link shows us everything.

    continue the thread...

    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!

    April 3, 2009 at 6:14 am

    #971445

  • RE: Third-party security issues. Can I allow read access by using views?

    I've seen an app like that, and upon investigation, found out that giving rights to Public was a knee jerk reaction to fix permissions by someone who did not understand...

    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!

    April 2, 2009 at 8:48 pm

    #971277

  • RE: Need to get Non repeated values from more than one table..

    you can use SELECT DISTINCT ....[columns]...FROM YOURTABLE to eliminate duplicates.

    if the whole row of data is not unique, then you'll have to use GROUP BY , putting columns you don't...

    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!

    April 2, 2009 at 3:36 am

    #970478

  • RE: Restore the database to new location

    edit your new posts so they do not use huge font, and remove the two duplicates...very annoying.

    the error message says it all...Google could have saved you hours of waiting.

    you are...

    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!

    April 2, 2009 at 3:13 am

    #970463

  • RE: Giving a page number to a specific number of row in data

    fredsql (4/2/2009)

    I am actually looking to do something slightly different, I want to number data returned in a query the first 25 row would be numbered 1 the second 25...

    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!

    April 2, 2009 at 3:06 am

    #970460

  • RE: I need to remove duplicate columns, but it's not that easy

    drewsx2 (4/1/2009)

    Sorry Glich in first posting!

    Hello,

    I have a Table in my DB that is used by multiple other tables. It looks like this:

    ID Type User_ID

    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!

    April 1, 2009 at 8:28 pm

    #970350

  • RE: Giving a page number to a specific number of row in data

    here's an example, assuming you are using row_number() function to decide how many rows:

    you might need to fiddle with it,

    declare @WhichPage int

    Set @WhichPage = 3

    SELECT * FROM (

    select row_number()...

    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!

    April 1, 2009 at 11:00 am

    #970078

  • RE: Table Design issue

    GilaMonster (4/1/2009)

    Is that table properly normalised? Do all of those columns belong in there?

    Gail has identified the root cause of your problem...I've yet to see a table with that many...

    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!

    April 1, 2009 at 9:49 am

    #970015

  • RE: Table Design issue

    say you want to add 100 new fields to your Table250.

    I would simply add a new table, with a foreign key to the original table, and a UNIQUE constraint 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!

    April 1, 2009 at 9:47 am

    #970008

  • RE: Get remote sql server properties

    because SERVERPROPERTY() is a function, even if you had " FROM RemoteServer.master.dbo.sysobjects" as the from clause, the function will return the info from the machine you are connected to...not 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!

    April 1, 2009 at 9:21 am

    #969980

  • RE: Fetching the IP address of SQL Server instance.

    the old chicken and the egg; which do you need first?

    you need to connect before you can run a query to try and find the IP,

    ....but you need 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!

    April 1, 2009 at 7:56 am

    #969843

Viewing 15 posts - 11,311 through 11,325 (of 13,460 total)