Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. linda105

    if...in the where clause

    Since you are passing in parameters then maybe it is a stored procedure that you are running? If so you could construct your sql statement in code based on the inputs declare @sqlString as varchar(255) ... select @sqlString = @sqlString + @sqlwhere ... EXEC master.dbo.sp_SQLEXEC @sqlString
  2. linda105

    Stored procedure

    This looks to me like a problem with the date format e.g. dd/mm/yy or mm/dd/yy - Do you get the same problem if you pass through dates like '04/04/2002' rather than '04/20/2002'? If this is the problem then you could try either passing the string in the SQL server default format (this depends...
  3. linda105

    Where is the data stored in sql!!

    When you create a database you will have specified devices, and whenever you create a table you specify which device to store it on, or it goes to the default device. There isn't necessarily one device per database. You should be able to view the devices in the console, or you can find the .dat...
  4. linda105

    SQL Server Shows different results for a query - Why ?

    I got a bit confused with what your problem was. However, I know that I have had HUGE problems with date formats, with different computers getting different results when using the same asp page and the same database..... I now try to always format the month in letters. Here is a bit in asp to...
  5. linda105

    sp help

    what about select t1.c, t1.num, t2.num, t3.num from (select contributor as c, count(*) as num from table where medal = 1 group by contributor ) as t1, (select contributor as c, count(*) as num from table where medal = 2 group by contributor ) as t2, (select contributor as...
  6. linda105

    Specifying a new line in the formula editor

    Try using the Ascii 13 for a new line eg. select product + CHAR(13) + product_grade
  7. linda105

    Stored procedure

    I don't know if this is the problem, but in my version of SQL server I don't seem to have a TOP function. To accomplish the same thing though: SET ROWCOUNT 5 SELECT sample_number FROM sample Order by sample_number DESC SET ROWCOUNT 0

Part and Inventory Search

Back
Top