Forum Replies Created

Viewing 15 posts - 346 through 360 (of 1,473 total)

  • RE: Stored procedure ignores DENY INSERT

    GSquared (12/2/2009)

    Brandie Tarvin (12/2/2009)

    Nope. That did NOT work. I even did a DENY INSERT on schema dbo and had the user's default schema as MySchema and had the proc saved...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    December 2, 2009 at 8:47 am

    #1086569

  • RE: Temp Table to Gather Data

    If your beer is agonizing, stop drinking bud light.

    Yes, I went there. 😉

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    December 2, 2009 at 8:37 am

    #1086558

  • RE: Stored Procedures that converts a table's column data type from char to nchar and varchar to nvarchar

    I thought I did? I made very slight modifications to the code you posted(based off of Gus') above and explained all of them.

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    December 2, 2009 at 8:19 am

    #1086533

  • RE: How to get True /False

    Please include the code you are using to determine true/false. You're giving us the variables that you're passing in and the data you're checking it against, but you're not...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    December 1, 2009 at 10:41 pm

    #1086263

  • RE: Stored Procedures that converts a table's column data type from char to nchar and varchar to nvarchar

    My fault, I read this one a bit too quickly. I thought you were going to be constantly altering the lengths of the fields. I can definitely see...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    December 1, 2009 at 4:51 pm

    #1086192

  • RE: Stored Procedures that converts a table's column data type from char to nchar and varchar to nvarchar

    Gotta tell you, between this and the last question about SET IDENTITY INSERT in a trigger, I'm a bit frightened about what is going on in your database. Are...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    December 1, 2009 at 3:10 pm

    #1086162

  • RE: Best way to get data from multiple tables

    My pleasure. I wish I could give you a better answer, but without knowing the structure of the data/tables, any answer is potentially wrong.

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    December 1, 2009 at 3:05 pm

    #1086156

  • RE: Best way to get data from multiple tables

    Not really. You need sample data. The relationships of these 3 tables is very unclear. Are there tables linking them together like ClassStudent and ClassSubject?

    The...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    December 1, 2009 at 2:56 pm

    #1086145

  • RE: How would one create a datasource to use in TSQL?

    This may help you:

    http://msdn.microsoft.com/en-us/library/ms177544.aspx

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    December 1, 2009 at 2:34 pm

    #1086126

  • RE: Best way to get data from multiple tables

    It only returns the redundant data if you select it. If you just use SELECT *, then yes, you'll get a ton of stuff you don't need, but doing...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    December 1, 2009 at 2:31 pm

    #1086123

  • RE: Best way to get data from multiple tables

    Ordinarily, you'd accomplish this with joins between the tables. If you want to provide table structure / sample data (see the first article in my signature for how) and...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    December 1, 2009 at 2:08 pm

    #1086112

  • RE: How to Group and batch select/cursor results in stored procedure

    It was a valiant attempt at sample data, but unfortunately it's not quite there. Here are a few of the errors:

    No insert statement for the table

    Word often...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    December 1, 2009 at 2:05 pm

    #1086111

  • RE: Making ROWS to be acts as another tables' Columns

    You're missing a ton of information here. Where are the values coming from?

    FullName Address City Country

    Ravi aaaaa aaa aa

    Andy bbbbb bbb bb

    Apollo ccccc ccc cc

    Sounds like an EAV system....

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    December 1, 2009 at 9:31 am

    #1085911

  • RE: How to search junk charcaters in a column

    Here's a slighly modified version of a function that I use for something like this. It requires a Tally Table. See the article on Tally tables in...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    December 1, 2009 at 8:20 am

    #1085846

  • RE: Select statment problem in cursor using datetimes

    rons-605185 (12/1/2009)

    Per Lynn's quoted reply below. Being new to SQL (my background was some light VB programming) I am unclear by what is meant by a set based solution. Most...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    December 1, 2009 at 8:13 am

    #1085840

Viewing 15 posts - 346 through 360 (of 1,473 total)