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: *

  • Users: NastiaMurzin
  • Order by date
  1. NastiaMurzin

    XSD SCHEMA creation and use in T-SQL

    you cannot create an xml file with sql without internet. reboot.
  2. NastiaMurzin

    Svr 2000 Terminal Services Issue

    If reboot doesn't work, try finding anything that might block the signal, like external devices. It could be external harddrives, laptops, notebooks. If that doesn't work, can you set a landline connection instead of a remote one?
  3. NastiaMurzin

    UNPIVOT with MultiColumns

    Or, something like that, --Unpivot the table. SELECT ID, columnthatusedtobearow, columnwithvaluesthatdidnothaveacolumnbefore, column1, column2, column3 FROM (SELECT ID, Emp1, Emp2, Emp3, Emp4, Emp5 FROM pivoted) p UNPIVOT (columnwithvaluesthatdidnothaveacolumnbefore, column1, column2...
  4. NastiaMurzin

    UNPIVOT with MultiColumns

    --Unpivot the table. SELECT ID, Name, Value FROM (SELECT ID, Emp1, Emp2, Emp3, Emp4, Emp5 FROM pivoted) p UNPIVOT (Value FOR Name IN (Emp1, Emp2, Emp3, Emp4, Emp5) )AS unpivoted; GO
  5. NastiaMurzin

    Filegroup is full....

    If you refresh the logfile constantly, then it will drop off the old records, i think. You just have to recreate the log file over again at your own convenience. But large log file like 500 mb is a good idea.
  6. NastiaMurzin

    distinct on union selects

    Instead of using this statement three times in the following query: <code> "SELECT shop_products.productid, shop_products.shop_producers_id, shop_products.productcategory, shop_products.productcategory2, shop_products.productcategory3, shop_products.productname, shop_products.productlongdesc...
  7. NastiaMurzin

    Better Practice of SQL query

    ...production; GO WHILE (SELECT AVG(listprice) FROM production.product) < 300.00 BEGIN UPDATE production.product SET listprice = listprice * 2 SELECT MAX(listprice) FROM production.product IF (SELECT MAX(listprice) FROM production.product) > 500.00 BREAK ELSE...
  8. NastiaMurzin

    adding users using sript

    As for the rest, the following script should work, USE tableschema; CREATE CERTIFICATE acertificatename1 WITH SUBJECT = 'username01 certificate in tableschema database', EXPIRY_DATE = '31-Dec-2010'; GO create login username01 with password somepassword02 must_change, default_language =...
  9. NastiaMurzin

    Multi-Column Pivot?

    Try that. Select tablename1.analyte, sampledate, location, result from (select * from tablename1) as aliasnamefortablename1 pivot( tablename1.analyte for tablename1.location in sampledate, location, result ) as aliastablepivotedname2 order by aliastablepivotedname2.column1;
  10. NastiaMurzin

    Filegroup is full....

    If you create a file with a certain memory allocation limit, then you won't go pass that limit. You will know, then, when to recreate the log file over again. I prefer to do it manually. Here is the script for creating a log file with a certain memory allocation. use tableschema; go alter dbo...
  11. NastiaMurzin

    SQL Server 2005 Management Studio - Filters on Tables, Views, Etc

    ...recent tables from today and yesterday. --Partitioned view as defined on Server1 CREATE VIEW Customers AS --Select from local member tables SELECT * from tablename1; select * from tablename2; --Select from local member tables SELECT * from tablename1 union all select * from tablename2 union...
  12. NastiaMurzin

    Filegroup is full....

    May be your files are overloaded in the temporary folder, check that. If that's ok. Then try modifying files to have greater capacity. Here is the script. USE tableschema; GO ALTER DATABASE dbo MODIFY FILE (NAME = filename1, SIZE = 20MB); GO
  13. NastiaMurzin

    How to import tab delimited files into a table using BCP

    bulk insert dbo.tableschema.tablename from '\\foldername\filename.txt'; go I think that could work.
  14. NastiaMurzin

    Is the Right Join the WRONG Join??

    select * from users, tr_drills, tr_individuals where users.deptid = tr_drills.deptid and tr_drills.drillid = tr_individuals.drillid and tr_drills.drilltime >= 3.00 order by tr_drills.drillid; no?
  15. NastiaMurzin

    Filegroup is full....

    Ok, first of all, you might have something wrong with your computer, so, first thing u do is turn off your comp and turn back on. You might need to do it 2-3 times. If you still have problem with your memory allocation, then check how much memory u've got by opening from bottom left start a...
  16. NastiaMurzin

    How to import tab delimited files into a table using BCP

    Here are some of the options that you have: bcp dbo.tableschema.tablename "select column1, column2, column3, column4 into dbo.tableschema.DUMP_Vids from dbo.tableschema.tablename order_by somecolumnnameoutofchosenfour" queryout outputfilename.txt in outputfilename.dat -f...
  17. NastiaMurzin

    NESTED CASE Statement Question

    select * from tablename order by personid asc; try it!
  18. NastiaMurzin

    Previous Row

    It is very simple. You cannot choose from what you don't have. I will explain. You have only select privileges. You do not have a column Seq. You cannot select it, and you cannot insert values into column that does not exist. The only way to select from Seq is by creating column Seq first. Who...
  19. NastiaMurzin

    SQL Using triggers and SPs to limit records for a particular column

    ...go insert into dbo.Wings_IVR_CallInformation values ('some message for ivr_msg column'); go select count(ivr_msg) from dbo.Wings_IVR_CallInformation; go select * from tablename where bArchived != '%true%' order by dDateTime; go select count(sSamplePointID) from tablename; go I hope it works.
  20. NastiaMurzin

    RESTORE LOG Issue

    Try RESTORE DATABASE DB FROM Backups WITH MOVE 'Data' TO 'C:\MySQLServer\tdb.mdf', MOVE 'Works_Log' TO 'C:\MySQLServer\tdb.ldf'; GO

Part and Inventory Search

Back
Top