Development - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• change Daily info to Weekly periods in pivot report

  hi I create a report base on categories and sales of goods. Now I have Daily Info abaout all Produc…

  MotivateMan1394

  3 replies

  10 years ago

  By: MotivateMan1394

• sp_addrolemember not working

  Hi, I'm on SQL Server 2014. Trying to add my user to a group. I use the following: exec sp_addr…

  jellybean

  2 replies

  10 years ago

  By: jellybean

• Pivot, NestedPivot, unPivot?

  Trying to work out some code that involves a pivot, and I'm stuck. Grateful for some assistance...…

  shorton2

  22 replies

  10 years ago

  By: shorton2

• Restore the latest transactional log file job

  Dear All, I'm trying find a way of crating an sql server job which would restore only transactional…

  tt-615680

  10 replies

  10 years ago

  By: Johan Bijnens

• Hresult: 0x80004005 Description: "The metadata could not be determined because the statements not compatible with the statement

  Dear Experts, I am running below TSQL from SSIS package and its failing but runs successfully when …

  Kummu

  10 replies

  10 years ago

  By: Kummu

• Performance factors of insert

  Hi There, Im have a situation to insert data from multiple sources to a single table. ie., multiple…

  squvi.87

  1 replies

  10 years ago

  By: Grant Fritchey

• omit rows that have NULL value

  Greetings All, It's been a while since I last posted on here, about 4 years maybe more. Anyway I'm …

  cthorn112

  9 replies

  10 years ago

  By: Matt Miller (4)

• Case statement troubles.

  Hi All, I am having trouble with a certain query - being the only SQL resource in my company, I do…

  aldous.chris

  3 replies

  10 years ago

  By: WayneS

• ISDATE function not working as expected

  Declare @var varchar(100) set @var = '2000' select case when ISDATE(@var ) =1 then 'Valid Date' w…

  squvi.87

  2 replies

  10 years ago

  By: Kristen-173977

• Need Help in Recursive Query in SQL using CTE

  I need help in sql recursive query, for example purpose i m providing sample table with insert scri…

  ravikumar401 69525

  6 replies

  10 years, 1 month ago

  By: Jeff Moden

• best isolation level to use in a long delete insert query

  hi all, i use a single stored procedure to update many tables in sql server 2014 database, using de…

  fabriziodb

  8 replies

  10 years, 1 month ago

  By: fabriziodb

• How to Import Data to SQL Server from Access Database using TSQL Script

  I want to import the data from specific Access Database and Table to SQL Server, using SQL Script. …

  tlp6327

  7 replies

  10 years, 1 month ago

  By: pietlinden

• Similar quires produce different output !! why ?

  create table #t1 (id int) create table #t2 (id int) insert into #t1 values (1) insert into #t1 valu…

  squvi.87

  3 replies

  10 years, 1 month ago

  By: WayneS

• Query fails with invalid column name but succeeds as a sub-query with unexpected results.

  -- The 3rd query uses an incorrect column name in a sub-query and succeeds but rows are incorrectly…

  bruce.kulig

  2 replies

  10 years, 1 month ago

  By: bruce.kulig

• Cannot open SSRS 2014 Report Manager URL on Windows Edge Browser (Windows 10)

  I was using Windows 7 and had SSRS 2014 installed. Having set up the inbound rule on Windows Firewa…

  chris.asaipillai 94746

  7 replies

  10 years, 1 month ago

  By: Koen Verbeeck