comprasconencanto1

How can I extract the year and week combination from a date in SQL Server using T-SQL and have it m… Read more Yearweek On Sql Server

I want get the maximum value for this record. Please help me: SELECT rest.field1 FROM masterta… Read more Sql Server : How To Use An Aggregate Function Like Max In A Where Clause

I am new to Full Text Search, how do I perform a search using Contains instead of using like in the… Read more Using Fts Query, Can You Find All Entries Contains 'abc'

I have a the following table ItemStatus ---------- id item_id status I want to select all item_ids… Read more Select Records From A Table Where All Other Records With Same Foreign Key Have A Certain Value

I have a table that looks like this: RecNo | TaskDesc | SeqNumber 1 | test | 1 2 | tes… Read more How To Reorder A Sql Table

I have a table in database with numbers of tenants, each tenant lists a record of their sales per d… Read more Fill Missing Dates In A Date-sequenced In Sql Using Tally Table

I am using SQL Server 2008. I have two table Shift and Break with following data: The shifts will b… Read more Calculate Work Time From Shift And Break Table

How can I get ID of last inserted row from SQL Server by PyQt4.QtSql module? Now I'm using SQL … Read more How To Get Id Of Last Inserted Row By Qsqlquery.lastinsertid() From Sql Server?