Programming SQL

Dynamic SQL , Discussion about Erland's Article
Bassam (egbas(a)yahoo.com) writes: The solution he offers thru sp_executesql is very complicated in many situations , like , if we have 10 parameter options for the user to choose from in the client , its not just ' = ' that the user can select for the parameter , it can be > , < , = , Like , Not Like , Betw... 3 Jul 2008 11:29

How to Create a Parameterised GROUP BY Without Using Dynamic-SQL
Hi all I have read Erland's treatise on dynamic-SQL, and now I want to avoid it like the plague. But one of the areas that still seems problematic is the GROUP BY clause. Depending on the parameters passed into my sproc, I want to group on different columns. What is the neatest way to do this without dynami... 3 Jul 2008 11:29

Formatted Text
I have a varchar column which has formatted text in it...bullets, tabs, hard returns, etc.. If I write a SQL script against this table, it will not paste these edits into Excel. However, if I Open the Table in SSMS and copy from SSMS and paste into Excel row by row, the edits are there. If I just copy the Open... 3 Jul 2008 13:33

Connecting to subscriber instance via business logic handler...
Hello, I have a customer resolver for replication where I am trying to open up a connection to the subscriber to execute stored procedures when synchronizing the data. This seems to work well with a LAN configuration, but when it is configured for a web synchronization, the Open fails for the database connect... 2 Jul 2008 16:02

Outer Join newbe question
Hi all, Pretty new to this so I would be very glad if any of you could point me in the right direction. I have three tables (see below) and I'm trying to get this result: DepID DepName FirstName LastName 1 Dep1 Andy Ason 2 Dep2 Dave Dson 4 Dep4 Null Null I do not get the last row. It is the "4 Dep4 Null... 3 Jul 2008 05:20

run a job under job agent
I need to run a job under a specific ID and password so it can read a file on a shared drive. When I change the owner to this ID the job still fails, how can I use a specific ID and password that has access to this shared drive on the network? ... 2 Jul 2008 18:05

executing an SQL Stored procedure from within a function
I want to execute an existing SQL Server 2000 stored procedure from within a user defined function. I am using this function within a view. The stored procedure I want to execute returns a numeric value that ultimately I want the function to return when it is called. I have been unable to find anything on the... 9 Jul 2008 12:41

using between to seach for date
I am trying to search for a table for some information using this query select * from table A where lastdate between '07/01/06' AND '07/30/06' the lastdate column dates are listed as date and time '2007-01-08 15:38:50.877' but I am interested in only the date. the sql above does not return anything - ... 2 Jul 2008 13:58

Using an SQL function as part of a view
I am using SQL Server 2000 and have written a fucntion that I would like to include in a view. The function returns a decimal value. When I go to my view, right click and select "Add table..." and then click on the "Functions" tab, there is nothing there to pick. What am I missing? How do I include an SQL serv... 5 Jul 2008 19:40

now sex teen -2008
http://www.k00n.com/2008.htm Sex sexy sexo sex teen sexs teens shemale Video a preto e branco downloadGay Sex Videos Click Here http://www.k00n.com/2008.htm http://www.k00n.com/2008.htm Sex sexy sexo sex teen sexs teens shemale Video a preto e branco downloadGay Sex Videos Click Here http://www.k00n... 2 Jul 2008 11:54