Topics
Started by
Posts
Last post
Cany anyone explain to me why the query below does not work in SSMS 2005? Every time I run this I …
7 replies
How to export the results of the system stored procedure into text file. I tried bcp "xp_readerror…
4 replies
I was wondering if the datepart function could produce the format in yyyymmddhhnnss. Aslo, if not s…
4 replies
Hi, I need a query to list the Name, Sal and cumulative of the salary, in increasing order of Salar…
20 replies
I am working on someone else's code and came across a right outer join I am not familiar with. Basi…
4 replies
I have a stored procedure that is looping through a sequential tally table to grab date ranges DECL…
10 replies
I have a table Info with Name, address,Mob.No.,Designation as Columns. Some of the records in the t…
4 replies
SELECT O.ORDERID, c.FIRSTNAME, c.LASTNAME, '' AS CREDITCARDNUMBER, '' AS COUNTRY, 'Soundex' AS GR…
3 replies
exec master..xp_cmdshell 'bcp "SELECT au_fname, au_lname FROM pubs..authors ORDER BY au_lname" quer…
3 replies
I have exported data from a Sybase SQL Anywhere db table. Which I can successfully import into a S…
2 replies
I have two columns that have integer values. I would like to concatenate them as text and add them …
10 replies
I have a table 'PurchaseHistory'. Products are listed numerous times. I would like to return the P…
8 replies
I am having problem with this where clause. I need the it else select the SpecialtyCode when Local_…
4 replies
I was curious if a select statement could be run to avoid a join. For example: use ScratchDB crea…
2 replies
I am new to triggers and I thought I knew what I was doing until I started playing with multiple re…
5 replies
Viewing 15 topics - 7,966 through 7,980 (of 12,230 total)
You must be logged in to create new topics.