comprasconencanto1

I currently have a school assignment that involves both PHP and asp.net. Now the assignment is that… Read more Connecting To An Sql Server Mdf File Via Php

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 used jQuery Full Calendar in my project.My events are stored in MS SQL Server table(events), I go… Read more Events Adding And Loading Problem In Jquery Full Calendar Using Sql Server And Php

Googling SQL PIVOT brings up answers to more complex situations than I need with aggregations, and … Read more Simple Sql Pivot

I have a table where I store customer sales (on periodicals, like newspaper) data. The product is s… Read more Sql Query Advice - Most Recent Item

I'm looking for a pure-SQL way (SQL Server 2012 if it matters) to convert row data to columns. … Read more Sql Transpose Row Data Into Columns

Original output: Desired output: Solution 1: Check this below example for your reference or else … Read more How To Pivot Table In Sql Server With A Stored Procedure?

I have a table over which I have built an ETL service. Goods records (arrival / departure) go to th… Read more Delete Or Change Records In Etl

How can I make a program use a SQL Server database, and have that program work on whatever computer… Read more I'm Trying To Grasp The Concept Of Creating A Program That Uses A Sql Server Database, But I'm Used To Running It Only On My Local Machine

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 have this query to get all detail of Bills between two dates: SELECT DT.* FROM DetailTable DT, B… Read more Timeout Expired, Optimize Query

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 data like below with a start and end date. The record could start and finish on the same day… Read more Split/extrapolate Single Records By Date Range Into Multiple Records

Goal I am attempting to migrate data from a multi-layered XML file with nested elements to a single… Read more Data Migration From Multilevel Xml To Single Table With Ssis

I'm wondering if there is a tool to generate the UPDATE statement based on data already inserte… Read more Generate Update Statement In Sql Server For Specific Table

I am writing a stored procedure. I have a problem on EP.Clerepartition column. I want to select thi… Read more Select With Case

I have a table including: ID Name Period0Id Period1Id Period2Id What I would like to receive data … Read more How To Write An Attribute Name To The Select Query Dynamically

I know there have been a lot of questions about Entity Framework doing cross database queries on th… Read more Can Code-first Entity Framework Do Cross Database Queries With Sql Server Dbs On The Same Box?

Not ASC or DESC.... Order by custom... I have tried using case but not successfully SELECT * FROM C… Read more Custom Order By In Sql Server Like P, A, L, H

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