SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• Best way to store images

  Hi. I recognized if we store an image in binary type in SQL SERVER they take more space. For exampl…

  masoudk1990

  17 replies

  11 years, 10 months ago

  By: Jeff Moden

• DateAdd - Show past year, 2 years, 3 years

  Hi I am trying to create a query which shows data from the past 1, 2, 3 4 and 5 years in seperate c…

  tonyabrhm

  2 replies

  11 years, 10 months ago

  By: Dwain Camps

• Filtering multiple alias for single column in sql

  My query is as below which works perfectly fine: SELECT [le].[id] AS [eventId] ,MAX(Conver…

  srikarkalle

  3 replies

  11 years, 10 months ago

  By: SQLRNNR

• Pass Parameter

  I am trying to pass a parameter to my report. This parameter is a calculated one , so needs to be i…

  sharonsql2013

  2 replies

  11 years, 10 months ago

  By: Dwain Camps

• Need Help With Coalesce

  I've been struggling with this on my own for a week now and I've finally come to the realization th…

  Colonel_Derp

  8 replies

  11 years, 10 months ago

  By: Luis Cazares

• load Report Model in Report Builder - Entities/daataset not shown

  When report model is open in report builder3.0from report manager dataset is not populated by defau…

  xlav

  2 replies

  11 years, 10 months ago

  By: sqlpro

• Sharing Temporary Table between 2 stored procedures

  Hi Everyone ProcA Create the temporary table Table1 ProcA call ProcB ProcB insert into temporary Ta…

  dquirion78

  3 replies

  11 years, 10 months ago

  By: chris.rogers00

• ansi .txt

  Hello I need to export a query to a .txt file in ANSI format, i came to this but the .txt format is…

  carlos cachulo-318532

  1 replies

  11 years, 10 months ago

  By: higgim

• Selective SELECT on data

  IF OBJECT_ID('tempdb..#temp1') IS NOT NULL DROP TABLE #temp1; CREATE TABLE #temp1( Symbol VARCHAR(1…

  Digs

  4 replies

  11 years, 10 months ago

  By: Dwain Camps

• Help on Calculation of days between Start & End Date (Including BOTH the Start & End Dates)

  Dear friends, I needed a urgent help on a critical task, for a field named "[ORC Position Duration…

  dhananjay.nagarkar

  12 replies

  11 years, 10 months ago

  By: dhananjay.nagarkar

• Count with Year,Month,Week

  I am trying to count all devices and arrange them on a weekly basis. so So the output should be th…

  sharonsql2013

  1 replies

  11 years, 10 months ago

  By: Luis Cazares

• How to make T-SQL query SARGable?

  Hi Experts I am trying to turn this query into something more SARGable (mainly the LEN(CardNumber..…

  imran.adam

  4 replies

  11 years, 10 months ago

  By: imran.adam

• Understanding the question at hand (word problems!)

  As I read through the training books for SQL, and the forums for that matter I have a hard time vis…

  rho_pooka

  5 replies

  11 years, 10 months ago

  By: rho_pooka

• Converting big integers into DateTime

  I know this is a common question and scenario and trust me, I've tried to do my homework before pos…

  RedBirdOBX

  3 replies

  11 years, 10 months ago

  By: AndrewSQLDBA

• How to create view in Database that uses a Linked Server on the same SQL Server "contains more than the maximum number of prefixes"

  Sorry to be such a newbie. What would be the best options here? The Linked Server query time even …

  Mile Higher Than Sea Level

  2 replies

  11 years, 10 months ago

  By: Mile Higher Than Sea Level