Jeff Moden (8/5/2015)

Since its conspicuously absent for all the above, what of backups and what's the DR plan at the company? What condition are you leaving the company in? ...

Luis Cazares (8/5/2015)

---

Kutang Pan (8/5/2015)

---

Hi Luis,

Thanks for that. I've started preparing a list of some Q/A but i can't find a nice one about dynamic sql writing. I would like...

Hi Luis,

Thanks for that. I've started preparing a list of some Q/A but i can't find a nice one about dynamic sql writing. I would like check the candidates basic...

vipin_jha123 (8/5/2015)

---

Hi When I am trying to execute below command I am getting error

BULK INSERT ##MD_GEOGRAPHYLEVELTYPE

FROM 'H:\Spectrum_V2_ETL\Loading_Geography_Table_Data\Loading_Geography_Table_Data\MD_GEOGRAPHYLEVELTYPE_US.txt'

WITH ( FIELDTERMINATOR =',', FIRSTROW = 9 )

error

Msg 4861, Level 16, State 1,...

You can use BULK INSERT

have a look here https://msdn.microsoft.com/pl-pl/library/ms188365(v=sql.110).aspx

Start with sttairways

http://www.sqlservercentral.com/stairway/72494/[/url]

EDIT:

too late :hehe:

if your query will return only one row, the code will work, but more then that it will fail because you can't assign many rows into a varchar variable using...

I'm a foreigner in UK and already have a 3’rd position working as DBA/DB Dev, never had a problem with nationality.

i assume Temp_Table contains many rows thats why you can't assign all of them to one variable.

What is the output you expecting? I can;t see declaration of @TheUser is that...

What country are you talking about?

Try this query, should give you the same result

SELECT COUNT(a.dex_row_id)

FROM (SELECT dex_row_id, ROW_NUMBER() OVER (PARTITION BY idfaktury ORDER BY dataexportu DESC) AS RowNo

FROM...

GilaMonster (7/28/2015)

---

Answer: Why are you enforcing silly and unrealistic restrictions on my code? Should I be...

you can as well try sp_helpExpandView from Andy Yun to understand what is lying underneath your views

https://sqlbek.wordpress.com/2015/03/03/debuting-sp_helpexpandview/[/url]

Have a look here

http://sqlandme.com/2011/07/13/sql-server-login-auditing-using-logon-triggers/[/url]

did someone do Insert on replicated table on subscriber? i would say reinitialize subscription.